database exception

[adibranch]

Hi all, i'm getting the following when checking the 'orders' in the admin panel when debug sql is on. 

 

[PrestaShopDatabaseException]

Unknown column 'payment_method' in 'field list'
 

SELECT `payment_method`, `payment_status`
FROM `ps_paypal_order`
WHERE `id_order` = 4029 LIMIT 1
at line 791 in file classes/db/Db.php

 

786. if ($webservice_call && $errno) {
787. $dbg = debug_backtrace();
788. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790. if ($sql) {
791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792. }
793.
794. throw new PrestaShopDatabaseException($this->getMsgError());
795. }
796. }

• DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 690 - classes/db/Db.php] - [1 Arguments]
• DbCore->getRow - [line 1410 - modules/paypal/paypal.php] - [1 Arguments]
• PayPal->_needValidation - [line 970 - modules/paypal/paypal.php] - [1 Arguments]
• PayPal->hookAdminOrder - [line 587 - classes/Hook.php] - [1 Arguments]
• HookCore::coreCallHook - [line 544 - classes/Hook.php] - [3 Arguments]
• HookCore::exec - [line 55 - override/classes/Hook.php] - [7 Arguments]
• Hook::exec - [line 207 - config/smarty.config.inc.php] - [3 Arguments]
• smartyHook - [line - ] - [2 Arguments]
• call_user_func_array - [line 270 - config/smarty.config.inc.php] - [2 Arguments]
• SmartyLazyRegister->__call - [line 1294 - tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code] - [2 Arguments]
• SmartyLazyRegister->smartyHook - [line 1294 - tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code] - [2 Arguments]
• content_58c2ba2b845143_02664319 - [line 188 - tools/smarty/sysplugins/smarty_internal_templatebase.php] - [1 Arguments]
• Smarty_Internal_TemplateBase->fetch - [line 317 - classes/SmartyCustom.php] - [7 Arguments]
• Smarty_Custom_Template->fetch - [line 113 - classes/helper/Helper.php]
• HelperCore->generate - [line 59 - classes/helper/HelperView.php]
• HelperViewCore->generateView - [line 2412 - classes/controller/AdminController.php]
• AdminControllerCore->renderView - [line 1789 - controllers/admin/AdminOrdersController.php]
• AdminOrdersControllerCore->renderView - [line 2037 - classes/controller/AdminController.php]
• AdminControllerCore->initContent - [line 189 - classes/controller/Controller.php]
• ControllerCore->run - [line 43 - override/classes/controller/Controller.php]
• Controller->run - [line 367 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 58 - admin/index.php]

Edited March 10, 2017 by adibranch (see edit history)

[rocky]

From the error, the ps_paypal_order table is missing the payment_method column. Maybe try reinstalling the module to see if that column is added? If not, you'll need to contact the module developer for support.

[adibranch]

Yep, the strange thing is i've checked other installations using paypal, and they dont have the column either. Guess it arose from a previous bad paypal release. The paypal system itself seems to work fine.

Edited March 13, 2017 by adibranch (see edit history)