Edit History

Checkout broke a couple of days (at least that's when I noticed it) in my webshop runnning on PS 1.7.7.

Since the error was connected to the PayPal-module I reset its settings and tried again, but get the following error-message:
 

[PrestaShopDatabaseException]

Table 'myshop.ps_mailalert_customer_oos' doesn't exist<br /><br /><pre> SELECT id_customer, customer_email, id_shop, id_lang FROM `ps_mailalert_customer_oos` WHERE `id_product` = 38 AND `id_product_attribute` = 0</pre>
at line 769 in file classes/db/Db.php

764.         if ($webservice_call && $errno) {
765.             $dbg = debug_backtrace();
766.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
767.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
768.             if ($sql) {
769.                 throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
770.             }
771. 
772.             throw new PrestaShopDatabaseException($this->getMsgError());
773.         }
774.     }

DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 613 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 313 - modules/ps_emailalerts/MailAlert.php] - [1 Arguments]
MailAlert::getCustomers - [line 174 - modules/ps_emailalerts/MailAlert.php] - [2 Arguments]
MailAlert::sendCustomerAlert - [line 598 - modules/ps_emailalerts/ps_emailalerts.php] - [2 Arguments]
Ps_EmailAlerts->hookActionUpdateQuantity - [line 988 - classes/Hook.php] - [1 Arguments]
HookCore::coreCallHook - [line 412 - classes/Hook.php] - [3 Arguments]
HookCore::callHookOn - [line 925 - classes/Hook.php] - [3 Arguments]
HookCore::exec - [line 620 - classes/stock/StockAvailable.php] - [2 Arguments]
StockAvailableCore::setQuantity - [line 518 - classes/stock/StockAvailable.php] - [5 Arguments]
StockAvailableCore->postSave - [line 477 - classes/stock/StockAvailable.php]
StockAvailableCore->update - [line 171 - src/Core/Stock/StockManager.php]
PrestaShop\PrestaShop\Core\Stock\StockManager->updateQuantity - [line 545 - classes/stock/StockAvailable.php] - [6 Arguments]
StockAvailableCore::updateQuantity - [line 537 - classes/order/OrderDetail.php] - [5 Arguments]
OrderDetailCore->checkProductStock - [line 738 - classes/order/OrderDetail.php] - [2 Arguments]
OrderDetailCore->create - [line 779 - classes/order/OrderDetail.php] - [7 Arguments]
OrderDetailCore->createList - [line 1085 - classes/PaymentModule.php] - [7 Arguments]
PaymentModuleCore->createOrderFromCart - [line 346 - classes/PaymentModule.php] - [17 Arguments]
PaymentModuleCore->validateOrder - [line 58 - modules/ps_wirepayment/controllers/front/validation.php] - [9 Arguments]
Ps_WirepaymentValidationModuleFrontController->postProcess - [line 295 - classes/controller/Controller.php]
ControllerCore->run - [line 518 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]

 As I didn't find anything related to this db-table (ps_mailalert_customer_oos) here in the forum I decided to setup a fresh install of PS 1.7.7 on a test-server to copy the table, but this table doesn't exist in the new PS-database either?!?

What I did before:

I had to redo some canceled orders and noticed that checkout just stops on the last step without any error-message, neither in the front-end nor in the backend or even logs🤔 The shop had been running and even taking orders for about 4 weeks before! The error disappeared when I deactivated the PayPal-module, but that can only be a temporary solution.

Since I had errors anyway I decided to upgrade from PS 1.7.6.9 to 1.7.7