Jump to content

Prestashop 1.5.6 problem mail alerts


Recommended Posts

Hi to all, after the upgrade to 1.5.6 of prestashop i have a problem with the module mail alerts

Prestashop alerts with this message

- mailalerts :
No upgrade has been applied
To prevent any problem, this module has been turned off

 

and automatically disable the module even it i try to reactivate

 

Waht must i do to adjust this situation?

Thank you in advance for your kind replies

Edited by lucifer1976 (see edit history)
Link to comment
Share on other sites

Me too. I'm receiving all other emails but I don't receive the New Order email from MailAlerts after updating from 1.4.9 to 1.5.6

I've tried different versions of Mail Alerts module, replaced all the folders Classes, Controllers, Tools, Modules with the original 1.5.6 version but still no success...

Edited by lozaria (see edit history)
Link to comment
Share on other sites

Hey, I think you should delete the module from the back office or via FTP (after you make sure you have a backup)

 

Then install this module directly from your backoffice/modules/add new module/upload

 

I will attach it here. Let me know how it goes. Thanks! 

Hi Benjamin can you post the module with the italian translation inside?

thank you in advance

Link to comment
Share on other sites

Mail Alert Problems too...

 

Translation files all good

Module installed and configured properly

Uninstalled and deleted Mail Alerts and re-uploaded the version above - no go

Uninstalled and deleted Mail Alerts and re-uploaded the version from Prestashop 1.5.6.0 - no go. 

 

Is the current version of Mail Alert still ver 2.4? In my backoffice it says Mail Alert 2.4 - however, I notice there is an upgrade folder which has the following code:

<?php

if (!defined('_PS_VERSION_'))
	exit;

function upgrade_module_2_5($object)
{
	return Db::getInstance()->execute('
		ALTER TABLE '._DB_PREFIX_.'mailalert_customer_oos 
		ADD '.mailalerts_stripslashes_field('id_lang').' INT( 10 ) UNSIGNED NOT NULL , 
yadda yadda...

My table is empty of data. is that correct?

 

Is that supposed to be upgrading to version 2.5??? 

 

I've been working on this for many hours now and can't get it working. 

Customers get their emails but the Merchant Mail Alert doesn't work for me. 

  • Like 1
Link to comment
Share on other sites

update :

 

it works. thank youBenjamin Utterback

buyer can receive, and the admin too.

 

But now i have problem with the {order_name},

 

fyi, i'm using Order reference change module, http://www.prestasho...-cart-id/page-1

 

i set the the order id with format NM000X, and it works.

if as a buyer, i received the notif with the right order id that i set before, e.g NM0006

but the email sent to admin/seller i got the wrong format with the right queue. # 000006

 

 

in BO, the order id and format is right, as same as the customer received, NM0006.

i see the email template to admin is different with core, it use the template from mail alert module.

and the email template to buyer is from prestashop core.

 

pls help me,

Edited by luxnux (see edit history)
Link to comment
Share on other sites

I have another problem with the module mails alert, i have the setting "Product availability:" so when the product is NOT AVAILABLE, he can put his email to get an alert, but that field show when product is availabe or not available, is supposed to be hide when the product is available.

 

please help.

  • Like 1
Link to comment
Share on other sites

Hello,

Nice topic.

I have the same problem:  I use PrestaShop™ 1.5.6.0, Mailalert 2.5 and I don`t receive emails alerts.

I tried  to change the module, with bouth versions from this topic, and still don`t working.

I tried to change the Mail.php but still don`t working.

I have all translations ok.

 

Can you help me?  My website is: http://gerocossen-online.ro

Thank you !  

  • Like 1
Link to comment
Share on other sites

Hello,

Nice topic.

I have the same problem:  I use PrestaShop™ 1.5.6.0, Mailalert 2.5 and I don`t receive emails alerts.

I tried  to change the module, with bouth versions from this topic, and still don`t working.

I tried to change the Mail.php but still don`t working.

I have all translations ok.

 

Can you help me?  My website is: http://gerocossen-online.ro

Thank you !  

Same for me, I have tried averyting suggested here. Just nothing

Link to comment
Share on other sites

Looks like some kind of bug, help pls.

 

+1, same problem here...

 

I'm using 1.5.6.1 (upgraded from 1.5.6.0 but that didn't help), mails are sent to customers but mail alerts aren't sent to the admin. Trying the different things in this thread didn't help.

 

Any hints on how to debug this?

 

Thanks.

Link to comment
Share on other sites

Hi, I also have this problem upgrading from 1.5.6.0 to 1.5.6.1 but when I turned on error reporting I got the message below.

[PrestaShopDatabaseException]

Duplicate column name 'id_lang'

		ALTER TABLE `ps_mailalert_customer_oos` 
		ADD `id_lang` INT( 10 ) UNSIGNED NOT NULL , 
		DROP PRIMARY KEY , 
		ADD PRIMARY KEY (`id_customer` , `customer_email` , `id_product` , `id_product_attribute` , `id_shop`)
	

I edited the modules/mailalerts/upgrade/install-2.5.php file and removed the line

"ADD `id_lang` INT( 10 ) UNSIGNED NOT NULL , "

 

It then upgraded sucesfully and I received the following message,

 

The following module(s) were upgraded successfully

  • - mailalerts :
    Current version: 2.8
    1 file upgrade applied

Cheers

Steve

Edited by stevell (see edit history)
Link to comment
Share on other sites

The following module(s) were upgraded successfully

  • - mailalerts :

    Current version: 2.8

    1 file upgrade applied

 

...and you are able to receive messages when new orders arrive? I'll check later today the database structure, but my shop upgraded without errors I think...

 

Jose.

Link to comment
Share on other sites

Mail Alert Problems too...

 

Translation files all good

Module installed and configured properly

Uninstalled and deleted Mail Alerts and re-uploaded the version above - no go

Uninstalled and deleted Mail Alerts and re-uploaded the version from Prestashop 1.5.6.0 - no go. 

 

Is the current version of Mail Alert still ver 2.4? In my backoffice it says Mail Alert 2.4 - however, I notice there is an upgrade folder which has the following code:

<?php

if (!defined('_PS_VERSION_'))
	exit;

function upgrade_module_2_5($object)
{
	return Db::getInstance()->execute('
		ALTER TABLE '._DB_PREFIX_.'mailalert_customer_oos 
		ADD '.mailalerts_stripslashes_field('id_lang').' INT( 10 ) UNSIGNED NOT NULL , 
yadda yadda...

My table is empty of data. is that correct?

 

Is that supposed to be upgrading to version 2.5??? 

 

I've been working on this for many hours now and can't get it working. 

Customers get their emails but the Merchant Mail Alert doesn't work for me. 

Your fix worked for me. Thanks!

Link to comment
Share on other sites

I edited the modules/mailalerts/upgrade/install-2.5.php file and removed the line

"ADD `id_lang` INT( 10 ) UNSIGNED NOT NULL , "

 

As far as I can see the right soultion would have been to replace 'id_lang' with 'id_shop' so it looks that this instead:

ADD `id_shop` INT( 10 ) UNSIGNED NOT NULL , 

 

My version is still 2.5 after succesfull upgrade, so where do you get the version 2.8 from?

Link to comment
Share on other sites

As far as I can see the right soultion would have been to replace 'id_lang' with 'id_shop' so it looks that this instead:

ADD `id_shop` INT( 10 ) UNSIGNED NOT NULL , 

 

My version is still 2.5 after succesfull upgrade, so where do you get the version 2.8 from?

 

I upgraded from 1.5.6.0 to 1.5.6.1 and Mail Alerts was upgraded as part of that process but was unable to complete. I have checked and it is definitely version 2.8

 

It appears to be sending alerts correctly.

Cheers Steve

Link to comment
Share on other sites

I have the same problem!

 

My mailalerts don't send me e-mails about new orders and I don't know what to do, as I did all the changes that I read in forums.

 

I updated to 1.5.6.1 and still don't receive e-mails on new orders....

 

I receive the e-mails of out of stock products, but I don't receive e-mails on new orders... really strange as I'm receiveing all the e-mails except of the new orders....

 

Any idea?

 

Thanks,

Link to comment
Share on other sites

I have the same problem!

 

My mailalerts don't send me e-mails about new orders and I don't know what to do, as I did all the changes that I read in forums.

 

I updated to 1.5.6.1 and still don't receive e-mails on new orders....

Did the module mailalerts install successfully?

If not, you can turn on error reporting or debug mode in /config/defines.inc.php to see what the problem is when trying to install the module.

Edited by elund (see edit history)
Link to comment
Share on other sites

I can install the mailalerts module successfully on ver. 2.4.
For installing successfully ver. 2.8 I have to remove the file "/upgrade/install-2.5.php"

 

Is really strange, as I'm receiving all the e-mails except of the new orders using an account created for me as a test.

 

I have another Prestashop installed in the same host, using 1.5.6.0 and using mailalets ver. 2.4 and it works perfectly!

I used this version and the Mail.php file on the other shop 1.5.6.1 but nothing happen, don't receive the e-mails of new orders....

Link to comment
Share on other sites

For installing successfully ver. 2.8 I have to remove the file "/upgrade/install-2.5.php"

I you have removed the file "/upgrade/install-2.5.php" then you havn't made a succesfully install.

"/upgrade/install-2.5.php" is updating the table mailalert_customer_oos.

For some strange reason my table was named mailalert_customer_oos_new and that was the second reason for why the install didn't work for me initially (I upgraded from 1.5.6.0 to 1.5.6.1).

How is your mailalert table named?

Link to comment
Share on other sites

Hi elund!! You gave me the solution!! and I found my problem and now is working on 1.5.6.1 the ver 2.4 of mailalerts

 

The problem was that I hadn't the table ps_mailalert_customer_oos on my Database and for this reason the module didn't work!!

 

So I exported the table ps_mailalert_customer_oos from my other shop and I imported to the new shop and installed the mailalerts ver 2.4 that was working on my other shop and the same for the file classes/Mail.php

 

Now I'm receiving all the orders that I'm making for test!!

 

So everyone that had a similar problem, check if you have on your Database the table ps_mailalert_customer_oos installed!!

 

Thanks elund!!

Link to comment
Share on other sites

Hey, I think you should delete the module from the back office or via FTP (after you make sure you have a backup)

 

Then install this module directly from your backoffice/modules/add new module/upload

 

I will attach it here. Let me know how it goes. Thanks! 

 

Hello

 

I just upgraded from 1.5.6.0 to 1.5.6.1 and have this error message about this module.  

 

I was going to do as you say and delete/uninstall and reinstall the module however when I go to uninstall the module I get this message popup:

 

"are you sure you want to delete all customer notifications"

 

What does that mean exactly?  

 

I have a lot of customer messages recorded against customer orders and I do not want to lose those and that message sounds a bit like that's what's going to happen if I uninstall it.  Or does it mean something else, if so, what?

Link to comment
Share on other sites

Hi alwaysperplexed,

 

this message means exactly what it says. The mailalerts module creates a database table named ps_mailalert_customer_oos where the notifications are stored. During the unistall process these infomations are deleted by the following function:

 449  	static public function deleteAlert($id_customer, $customer_email, $id_product, $id_product_attribute)
 450      {
 451          $query = 'DELETE FROM `'._DB_PREFIX_.'mailalert_customer_oos` 
 452          WHERE `id_customer` = '.intval($id_customer).'
 453          AND `customer_email` = \''.pSQL($customer_email).'\'
 454          AND `id_product` = '.intval($id_product).'
 455          AND `id_product_attribute` = '.intval($id_product_attribute).';';
 456          return Db::getInstance()->Execute($query);
 457      }
 458  }

So I wouldn't recommend to follow Benjamin Utterbacks advice in case that you don't want that the entries get lost.

Link to comment
Share on other sites

Hi alwaysperplexed,

 

this message means exactly what it says. The mailalerts module creates a database table named ps_mailalert_customer_oos where the notifications are stored. During the unistall process these infomations are deleted by the following function:

 449  	static public function deleteAlert($id_customer, $customer_email, $id_product, $id_product_attribute)
 450      {
 451          $query = 'DELETE FROM `'._DB_PREFIX_.'mailalert_customer_oos` 
 452          WHERE `id_customer` = '.intval($id_customer).'
 453          AND `customer_email` = \''.pSQL($customer_email).'\'
 454          AND `id_product` = '.intval($id_product).'
 455          AND `id_product_attribute` = '.intval($id_product_attribute).';';
 456          return Db::getInstance()->Execute($query);
 457      }
 458  }

So I wouldn't recommend to follow Benjamin Utterbacks advice in case that you don't want that the entries get lost.

Hi there

 

Thanks for that. That's what I thought it meant so I don't want to lose all the entries so far.

 

But that means I am still stuck with mail alerts problem that led me to this thread :(

Link to comment
Share on other sites

Thanks for that. That's what I thought it meant so I don't want to lose all the entries so far.

 

But that means I am still stuck with mail alerts problem that led me to this thread :(

Normally the ps_mailalert_customer_oos table is empty (mine was), so check if the table is empty.

If yes, then you will loose no data, if you follow Benjamin Utterbacks advise

Link to comment
Share on other sites

  • 2 weeks later...

Hi, anyone who can help me to modify the $itemsTable?
 
In the mail alert new_order.html, the {items} field gets the info on the products from mailalerts.php $itemsTable right?
 
The calculation in my emails are wrong, the unit price shows the total price of the products and the total price is calculated again. Se below

neworder.jpg

 

It should be:

stk pris: 2750, antal: 3, samlet pris (3x2750) 8.250,-

 

 

Also I would love to add the product ID also! :)

Edited by SaraL (see edit history)
Link to comment
Share on other sites

Hi, anyone who can help me to modify the $itemsTable?

 

In the mail alert new_order.html, the {items} field gets the info on the products from mailalerts.php $itemsTable right?

 

The calculation in my emails are wrong, the unit price shows the total price of the products and the total price is calculated again. Se below

 

 

Also I would love to add the product ID also! :)

 

I need the same but i am not being able to understand where to edit this info

Link to comment
Share on other sites

Hello,

 

I try to use the out of stock alert and set the threshold to 1.  

 

But no email received when the quantity of a product becomes zero.

 

I did received the new order email alert.  So what's wrong?

 

Thanks!

Link to comment
Share on other sites

  • 3 weeks later...

This seems to be no problem of the module. You got to check your product settings.

before updating the module worked! I check in product setting some function but i think that the problem is a bug module! 

 

http://forge.prestashop.com/browse/PNM-746 (this is a similar bug report)

 

I view "Email me when available" but the product is available.

 

Best regard.

 

 

Link to comment
Share on other sites

before updating the module worked! I check in product setting some function but i think that the problem is a bug module! 

 

http://forge.prestashop.com/browse/PNM-746 (this is a similar bug report)

 

I view "Email me when available" but the product is available.

 

Best regard.

 

 

 

I´ve got the same.

 

Product is available, but i can register email for notification...

Link to comment
Share on other sites

I'm afraid to disagree with you, but with activated

  • Allow ordering of out-of-stock products
  • Enable stock management

     

and deactivated

  • Enable advanced-stock management

it works perfect for me. No bug!

Yes it's works, but if a product is not available you can order it anyway. This is not regular. 

I view "Email me when available" but the product is available.(this is a bug)

Thank's eleazar for the reply. :)

 

Link to comment
Share on other sites

I've been using Prestashop 1.5.6.1 and Mail Alerts module v3.2.


 


At the first, I am set the Contact Shop with my email (*@live.com). Mail Alerts worked for the seller when order was placed. Then I am changed the Contact Shop with my hosting email (*@domain.com), the seller wasn't got order email anymore.


 


I am not sure what else need to configure?


  • Like 1
Link to comment
Share on other sites

Hey guys,

 

I'm also having issues with the Mail Alert module. I'm using PS version 1.5.6.1, and the module version is 3.2.

 

On the admin module configuration panel I'm getting the input for the emails addresses been populated with an error text:

 

post-722539-0-23616000-1392570073_thumb.png

 

The error text is:

 

Notice: Undefined index: cols in R:\wamp\www\store\cache\smarty\compile\ec\69\96\ec69962cbe3655cfcad7d258ace3e4f96bcdfde0.file.form.tpl.php on line <i>467</i>

 

Does anyone has the same issue?

Have any of you correct it?

 

Kind regards.

Pedro Avila

post-722539-0-23616000-1392570073_thumb.png

  • Like 1
Link to comment
Share on other sites

hello. help me please. version prestashop 1.5.6.2, Module 3.2, below screenshot

my-acount.jpg

 

Hi

 

You can solve this problem by adding the following code to your template, i had this problem and i can confirm this is a bug,

 

Go to your modules / mailalerts / views / templates / hook folder and open my-account.tpl and replace with the following code : Because, in the upgrade, the line <img .... will be missing.

<li class="mailalerts">
	<a href="{$link->getModuleLink('mailalerts', 'account')|escape:'html'}" title="{l s='My alerts' mod='mailalerts'}" rel="nofollow">
<img src="{$module_template_dir}img/icon-alert.png" class="icon" />
		{l s='My alerts' mod='mailalerts'}
	</a>
</li>

Edited by indus (see edit history)
Link to comment
Share on other sites

Can you post version 3.2 cause my module isnt going to update by prestashop admin panel...thanks

 

Hey guys,

 

I'm also having issues with the Mail Alert module. I'm using PS version 1.5.6.1, and the module version is 3.2.

 

On the admin module configuration panel I'm getting the input for the emails addresses been populated with an error text:

 

 

 

The error text is:

 

Notice: Undefined index: cols in R:\wamp\www\store\cache\smarty\compile\ec\69\96\ec69962cbe3655cfcad7d258ace3e4f96bcdfde0.file.form.tpl.php on line <i>467</i>

 

Does anyone has the same issue?

Have any of you correct it?

 

Kind regards.

Pedro Avila

 

Link to comment
Share on other sites

I have another problem with the module mails alert, i have the setting "Product availability:" so when the product is NOT AVAILABLE, he can put his email to get an alert, but that field show when product is availabe or not available, is supposed to be hide when the product is available.

 

please help.

 

I have the same problem and solved it? after adding and testing field insert email disappears

Link to comment
Share on other sites

 

I've been using Prestashop 1.5.6.1 and Mail Alerts module v3.2.

 

At the first, I am set the Contact Shop with my email (*@live.com). Mail Alerts worked for the seller when order was placed. Then I am changed the Contact Shop with my hosting email (*@domain.com), the seller wasn't got order email anymore.

 

I am not sure what else need to configure?

 

I have the same problem and solved it? after adding and testing field insert email disappears ps 1.5.4.1

Edited by Ron morales (see edit history)
Link to comment
Share on other sites

  • 2 weeks later...

Hello, 


 


I used Prestashop version 1.5.6.1 and mailalerts version 3.2.3


My site is located on my computer,the problem is I can not configure any mail.


I tried various emails but in vain.


I read all the posts on the email settings but all the changes I made ​​did not lead to any results.


If i run this code :


<?PHP

phpinfo();

?>

 

The result on the email is:





 

If I send a test email to [email protected] gives me this error : Error: Please check your configuration

Sending failed using mail() as PHP's default mail() function returned boolean FALSE.


 


What can I do to be able to function?


 


Tnx

Link to comment
Share on other sites

  • 2 weeks later...

:wub:

Hello all 

Try this hope it will work for ya all.

 

1.Uninstall your Mailalert Modules Or Dellete Mailalert from Admin office ..

Download : Mailalert

Download Mail.php from Benjamin Utterback

------------------------------------------------------------------

Replace the file mail.php @ /class/mail.php Note: the old mail.php not get replace Delete it or download as backup.

upload your new mail.php

Now install your module Mailalert from admin office .

Configure it and Save it ....

Note if you want it to work fine don't update after installing. Just test your email and hope it will work for ya  ..... Mine Work Perfectly after long time ..

:)  :rolleyes:  :wub:  :)  :rolleyes:

 

Cheers 

Link to comment
Share on other sites

Kamran, could you please tell us what is the correct file for Mail.php? Your link is direct to member page Benjamin Utterback and I've tried with one that I found out from him in another thread but it is not working...

 

Thanks!

 

:wub:

Hello all 

Try this hope it will work for ya all.

 

1.Uninstall your Mailalert Modules Or Dellete Mailalert from Admin office ..

Download : Mailalert

Download Mail.php from Benjamin Utterback

------------------------------------------------------------------

Replace the file mail.php @ /class/mail.php Note: the old mail.php not get replace Delete it or download as backup.

upload your new mail.php

Now install your module Mailalert from admin office .

Configure it and Save it ....

Note if you want it to work fine don't update after installing. Just test your email and hope it will work for ya  ..... Mine Work Perfectly after long time ..

:)  :rolleyes:  :wub:  :)  :rolleyes:

 

Cheers 

  • Like 1
Link to comment
Share on other sites

Kamran, could you please tell us what is the correct file for Mail.php? Your link is direct to member page Benjamin Utterback and I've tried with one that I found out from him in another thread but it is not working...

 

Thanks!

 

Download Mail.php From   http://www.mediafire.com/download/pt0erd3wl6tqe5z/Mailphpfile.rar

 

Hope it will work for ya 2 

Thanks

Link to comment
Share on other sites

Hi Kamran!

 

Thanks once again for your help.

 

It didn't work but at least I could try it exactly as you... I'm going crazy with this issue. If I knew what would happen I never updated mailalerts module...

I've already tried every solution I found on forums about this issue but none was work...

I've tried php function, smpt definitions, another mail.php, another mailalert module version, I've changed files in the /tools/swift folder... Nothing was worked :(

Has a store owner I receive the e-mails but the customers don't receive any - no new orders, no welcome message when they create an account on the store, no order status updates...

What I did was install a fresh 1.5.2 prestashop version and I've installed the same modules that I have in my shop - guess what... the e-mails works just fine!!!!

Any other clue about this issue anyone?

Link to comment
Share on other sites

YES, FINALLY IT'S  WORK

 

after trying all possible solutions

The problem was a template translate in my language

check the translation in your language by ftp 

 

PS 1.5.6

mailalert 3.8 with o without upgrade ;)

and with or without mail.php

Yes!!

  • Like 1
Link to comment
Share on other sites

  • 3 weeks later...

YES, FINALLY IT'S  WORK

 

after trying all possible solutions

The problem was a template translate in my language

check the translation in your language by ftp 

 

PS 1.5.6

mailalert 3.8 with o without upgrade ;)

and with or without mail.php

Yes!!

 

what does it mean "a template translation"?? Could one describe what I have to look for and where in PS or FTP?

So nothing particular to fix in Mailalert 3.2.8? The problem is somewhere else?

 

Having same issue with PS1.5.6.2. Mails not working in the shop. Not on order, not from Contact form, nothing.

The mailboxes do work as sending from Outlook without issues. Testmail from PS also works perfectly.

Link to comment
Share on other sites

Awesome, I'm glad you sorted it out. Let us know if you need any more help. Thanks for choosing PrestaShop !

 

There is an updated version from today.

 

Please make sure to backup and use this module to replace mailalerts for 1.5x .. Let me know if this solves your problems. Thanks for the feedback!

Hello, it this version of Mail Alert compatible with 1.6 ?

Link to comment
Share on other sites

  • 2 weeks later...

yes if you see in the translation about this module(in FTP), you will see  missing the translation, there is only in english, so you have to copy and paste the same folder(in english) and rename it in your language ;)

after edit inside the files always in your language

Edited by BillMartin (see edit history)
Link to comment
Share on other sites

Hi members,

 

 

i have sometime problem with mailalerts module on different sites with PS 1.5. If customers mail work fine and mailalert not work - my solutions:

 

 

1. Problem with hosting. On server must be correct instaled sendmail extension. After try use e-shop main mail with same server name. For example: e-shop: sale.com, mail must be [email protected]. Try use manual setting for SMTP server. Try use modified mail.php classes. 

 

2. Problem with version module. Try mailalert version 2.4 or 2.5. Always work fine. Can download on this topic. Before instal another version: uninstall module. After instal - activate module, reset and make settings.  

 

 

3. The problem with your themes. Try use mailaler on another themes, for example on default theme. If all ok check the translation in your language by ftp. Try to remove folder with your template on mailalert module (for example: shop.com/themes/mytheme/modules/mailalert/mail  )

Edited by www.bio-krby-kamna.cz (see edit history)
  • Like 1
Link to comment
Share on other sites

  • 3 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...