Unknown column ERROR after confirming order

[CSEpe]

Since a few days we get this error.

Fatal error: Uncaught Unknown column 'id_shop' in 'field list'<br /><br /><pre> SELECT id_customer, customer_email, id_shop, id_lang FROM `ps_mailalert_customer_oos` WHERE `id_product` = 339 AND `id_product_attribute` = 0</pre> thrown in /home/public_html/classes/db/Db.php on line 791

There is no id_shop in this table. Nor in the old backups

When I disable mailalerts module payment by Paypal and Bank works but cash gives error:

Catchable fatal error: Argument 4 passed to ToolsCore::displayPrice() must be an instance of Context, boolean given, called in /home/public_html/modules/cash/cash.php on line 360 and defined in /home/public_html/classes/Tools.php on line 637

So after disabling Cash module v 0.3 by Librasoft  and Mailalerts module it works again.

 

Edited April 8, 2016 by CSEpe (see edit history)

[tuk66]

It is about two independent errors.

1) The ps_mailalert_customer_oos table should have this schema:

CREATE TABLE IF NOT EXISTS `ps_mailalert_customer_oos` (
  `id_customer` int(10) unsigned NOT NULL,
  `customer_email` varchar(128) NOT NULL,
  `id_product` int(10) unsigned NOT NULL,
  `id_product_attribute` int(10) unsigned NOT NULL,
  `id_shop` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_customer`,`customer_email`,`id_product`,`id_product_attribute`,`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[Prestachamps]

Hi,

Go to go to modules and reset the mailalerts module, this will fix your database table structure for the ps_mailalert_customer_oos table. After that you will not have this issue.

If this will not fix your issue, then the problem is in the Cash module . Your Catchable fatal error from the Cash module can be fixed easily, I can help you with that after you have solved the "Fatal error: Uncaught Unknown column" error.

Regards, Leo

[CSEpe]

The Mail alert issue is fixed.      

Cash module:  same error

[Prestachamps]

Would you mind sending me in PM the source of the file home/public_html/modules/cash/cash.php and the exact version of your prestashop, and I can reply to you with the exact modification that will fix the function call.

Regards, Leo.