opc_ship_to_pay does not exist

[saxtouri]

Hi there, I have the exact same problem after I performed a mass update on the Base prices of all my products.

I tried to update the prices by importing a CSV file of this form:

ID; Base Price
1; 100.0
2; 210.0

The prices are updated fine, but when I try to test the checkout, I get nothing! My clients cannot check out. So I had to turn the debug mode on:

I run a prestashop 1.7.2.4
My URL is https:polymerclay.gr
I will now revert to an older version of my eshop in order to allow clients to buy with the old prices, but if you have any idea about the error, I would apreciate it.

This is the error message (on debug mode) :

 

[PrestaShopDatabaseException]

Table 'eshop.eshop_opc_ship_to_pay' doesn't exist
 

SELECT * FROM eshop_opc_ship_to_pay

at line 744 in file classes/db/Db.php

 

739.         if ($webservice_call && $errno) {
740.             $dbg = debug_backtrace();
741.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
742.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
743.             if ($sql) {
744.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
745.             }
746. 
747.             throw new PrestaShopDatabaseException($this->getMsgError());
748.         }
749.     }

• DbCore->displayError - [line 378 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 596 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 5207 - modules/onepagecheckoutps/onepagecheckoutps.php] - [1 Arguments]
• OnePageCheckoutPS->getTemplateVarsOPC - [line 473 - override/controllers/front/OrderController.php] - [2 Arguments]
• OrderController->initContent - [line 205 - classes/controller/Controller.php]
• ControllerCore->run - [line 379 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]