Jump to content

Prestashop 1.5.6 problem mail alerts

lucifer1976
 Share

Recommended Posts

lucifer1976 Newbie

lucifer1976

Posted
Posted (edited)

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
lozaria Newbie

lozaria

Posted
Posted (edited)

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
lucifer1976 Newbie

lucifer1976

Posted
  • Author
Posted

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
koolrifz Newbie

koolrifz

Posted
Posted

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
luxnux Newbie

luxnux

Posted
Posted (edited)

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
bprado Newbie

bprado

Posted
Posted

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
levis31cv Newbie

levis31cv

Posted
Posted

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
YvonneM Newbie

YvonneM

Posted
Posted

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
prestaden Newbie

prestaden

Posted
Posted

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
stevell Apprentice

stevell

Posted
Posted (edited)

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
prestaden Newbie

prestaden

Posted
Posted

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
koolrifz Newbie

koolrifz

Posted
Posted

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
elund Newbie

elund

Posted
Posted

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
stevell Apprentice

stevell

Posted
Posted

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
axelsan Newbie

axelsan

Posted
Posted

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
elund Newbie

elund

Posted
Posted (edited)

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
axelsan Newbie

axelsan

Posted
Posted

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
elund Newbie

elund

Posted
Posted

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
axelsan Newbie

axelsan

Posted
Posted

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
alwaysperplexed Newbie

alwaysperplexed

Posted
Posted

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
 eleazar Newbie

 eleazar

Posted
Posted

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
alwaysperplexed Newbie

alwaysperplexed

Posted
Posted

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
elund Newbie

elund

Posted
Posted

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...
SaLiC Newbie

SaLiC

Posted
Posted (edited)

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
nspinheiro Newbie

nspinheiro

Posted
Posted

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
lauwh Newbie

lauwh

Posted
Posted

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...
Fablux Newbie

Fablux

Posted
Posted

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
distrax Newbie

distrax

Posted
Posted

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
Fablux Newbie

Fablux

Posted
Posted

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
andrefadila Newbie

andrefadila

Posted
Posted

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
pavila Newbie

pavila

Posted
Posted

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
indus Newbie

indus

Posted
Posted (edited)

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
pixelmatto Newbie

pixelmatto

Posted
Posted

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
Ron morales Newbie

Ron morales

Posted
Posted

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
Ron morales Newbie

Ron morales

Posted
Posted (edited)

 

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