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)

Share this post


Link to post
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)

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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)

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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.

Share this post


Link to post
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)

Share this post


Link to post
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.

Share this post


Link to post
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!

Share this post


Link to post
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?

Share this post


Link to post
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

Share this post


Link to post
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,

Share this post


Link to post
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)

Share this post


Link to post
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....

Share this post


Link to post
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?

Share this post


Link to post
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!!

Share this post


Link to post
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?

Share this post


Link to post
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.

Share this post


Link to post
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 :(

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

I have 1.5.6.1 and I would like to receive an email notification when a new customer registers like with the old module memberalert in prestashop 1.4


 


Can you help me?


 


Regards


Andrea


  • Like 1

Share this post


Link to post
Share on other sites

  • 2 weeks later...

Hi

 

I have PS 1.5.6 and i have mailalert 2.5. I am not being able to receive the e-mail alerts with the new orders.

 

It seems to be a common problem, but i read there exists a 2.8 version? is it right? i am not being able to find it for download

Share this post


Link to post
Share on other sites

You don't need to download the new version. Just check if module pages shows the update button/link and click it.

 

Did you check if the module configuration has emailing new order notifications enabled?

 

Ok, no option to update... 

 

Yes, it is enabled

Share this post


Link to post
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

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)

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

I also needed to have Client Group Description. I was able to get

 

'{customer_groups}' => $customer_group->id_Group

 

but i need to now grab this and make the label for it accordant with the information on group_lang->name

Share this post


Link to post
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!

Share this post


Link to post
Share on other sites

  • 3 weeks later...

PrestaShop 1.5.6.x contains mailalerts 2.8, PrestaShop 1.6. in contrast 2.7. I don't know the reason why.. Both versions are in some parts different from 3.2.

 

If it's helpful for you, here's mailalerts version 3.2 for download:

 

Works fine with 1.5.6.1.

  • Like 3

Share this post


Link to post
Share on other sites

PrestaShop 1.5.6.x contains mailalerts 2.8, PrestaShop 1.6. in contrast 2.7. I don't know the reason why.. Both versions are in some parts different from 3.2.

 

If it's helpful for you, here's mailalerts version 3.2 for download: attachicon.gifmailalerts_3-2.zip

 

Works fine with 1.5.6.1.

Tank's eleazar! :)

Share this post


Link to post
Share on other sites

When product availability in mailalert is active in the product page i view "Email me when available" but the product is available. The module is upgrade with 3.2, my prestashop installation is upgrade from 1.5.3.1 to 1.5.6.2! Thank's for help! 

Edited by Fablux (see edit history)

Share this post


Link to post
Share on other sites

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.

 

 

Share this post


Link to post
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...

Share this post


Link to post
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. :)

 

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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)

Share this post


Link to post
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

 

Share this post


Link to post
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

Share this post


Link to post
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)

Share this post


Link to post
Share on other sites

Add me to the list of people having problems with mail alerts. Though i have added a new theme, so that might also be a reason. Notify me when available shows even if product is in stock.

  • Like 1

Share this post


Link to post
Share on other sites

  • 2 weeks later...