saad elalfy 1 Posted May 3, 2018 please i get there error how can i fix it Unknown column 'r.id_shop' in 'field list' SELECT r.`id_info`, r.`id_shop`, rl.`text` FROM `ps_info` r LEFT JOIN `ps_info_lang` rl ON (r.`id_info` = rl.`id_info`) WHERE `id_lang` = 2 AND `id_shop` = 1 LIMIT 1 at line 746 in file classes/db/Db.php 741. if ($webservice_call && $errno) { 742. $dbg = debug_backtrace(); 743. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 744. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 745. if ($sql) { 746. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 747. } 748. 749. throw new PrestaShopDatabaseException($this->getMsgError()); 750. } 751. } Share this post Link to post Share on other sites
NemoPS 1,879 Posted May 3, 2018 Can you copy the whole stack? Share this post Link to post Share on other sites
shacker 1,050 Posted May 6, 2018 try to change WHERE `id_lang` = 2 AND `id_shop` = 1 LIMIT 1 to WHERE rl.`id_lang` = 2 AND r.`id_shop` = 1 LIMIT 1 but before check if in the table ps_info the id_shop field exists Share this post Link to post Share on other sites
saad elalfy 1 Posted May 14, 2018 thank you very much the module working fine now Share this post Link to post Share on other sites
ionut71 1 Posted May 15, 2018 Hi, I have the same problem / error, but I don't understand how you solve it... Please explain. [PrestaShopDatabaseException] Unknown column 'r.id_shop' in 'field list' SELECT r.`id_info`, r.`id_shop`, rl.`text` FROM `prstshp_info` r LEFT JOIN `prstshp_info_lang` rl ON (r.`id_info` = rl.`id_info`) WHERE rl.`id_lang` = 1 AND `id_shop` = 1 LIMIT 1 at line 746 in file classes/db/Db.php 741. if ($webservice_call && $errno) { 742. $dbg = debug_backtrace(); 743. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 744. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 745. if ($sql) { 746. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 747. } 748. 749. throw new PrestaShopDatabaseException($this->getMsgError()); 750. } 751. } DbCore->displayError - [line 378 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 645 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 256 - modules/ps_customtext/ps_customtext.php] - [1 Arguments] Ps_Customtext->getWidgetVariables - [line 243 - modules/ps_customtext/ps_customtext.php] - [2 Arguments] Ps_Customtext->renderWidget - [line 929 - classes/Hook.php] - [2 Arguments] HookCore::coreRenderWidget - [line 881 - classes/Hook.php] - [3 Arguments] HookCore::exec - [line 39 - controllers/front/IndexController.php] - [1 Arguments] IndexControllerCore->initContent - [line 253 - classes/controller/Controller.php] ControllerCore->run - [line 428 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Share this post Link to post Share on other sites
saad elalfy 1 Posted May 15, 2018 save all text you modifie it and , reset custum text module from module list and you will back to the default with out errors 1 Share this post Link to post Share on other sites
saad elalfy 1 Posted July 1, 2018 thank you very much solved Share this post Link to post Share on other sites
MR M 0 Posted May 23, 2019 Hello all, I got the some as above problem but its bit different please anyone can help me to solve it if possible explain step by step so i can do it thanks and regards [PrestaShopDatabaseException] Unknown column 'id_paypal_order' in 'field list' SELECT id_paypal_order FROM `ps_paypal_order` WHERE (id_order = 9) LIMIT 1 at line 746 in file classes/db/Db.php 741. if ($webservice_call && $errno) { 742. $dbg = debug_backtrace(); 743. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 744. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 745. if ($sql) { 746. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 747. } 748. 749. throw new PrestaShopDatabaseException($this->getMsgError()); 750. } 751. } DbCore->displayError - [line 378 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 645 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 678 - classes/db/Db.php] - [2 Arguments] DbCore->getValue - [line 140 - modules/paypal/classes/PaypalOrder.php] - [1 Arguments] PaypalOrder::loadByOrderId - [line 1331 - modules/paypal/paypal.php] - [1 Arguments] PayPal->hookDisplayAdminOrder - [line 924 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 328 - classes/Hook.php] - [3 Arguments] HookCore::callHookOn - [line 860 - classes/Hook.php] - [3 Arguments] HookCore::exec - [line 165 - config/smarty.config.inc.php] - [3 Arguments] smartyHook - [line 83 - classes/Smarty/SmartyLazyRegister.php] - [2 Arguments] SmartyLazyRegister->__call - [line 1334 - var/cache/dev/smarty/compile/79/c3/f4/79c3f4a635031d25f5509e459f0602613d1b8726_0.file.view.tpl.php] - [2 Arguments] Block_7921671195ce468e9379654_15855508->callBlock - [line 247 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [1 Arguments] Smarty_Internal_Runtime_Inheritance->callBlock - [line 183 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [2 Arguments] Smarty_Internal_Runtime_Inheritance->process - [line 185 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [3 Arguments] Smarty_Internal_Runtime_Inheritance->process - [line 157 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [2 Arguments] Smarty_Internal_Runtime_Inheritance->instanceBlock - [line 34 - var/cache/dev/smarty/compile/bd/cc/4d/bdcc4dd6c40c04c020fed8c8e9402fb0b6793b84_0.file.view.tpl.php] - [3 Arguments] content_5ce294ef35ef41_34226729 - [line 123 - vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php] - [1 Arguments] Smarty_Template_Resource_Base->getRenderedTemplateCode - [line 114 - vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php] - [1 Arguments] Smarty_Template_Compiled->render - [line 206 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php] - [1 Arguments] Smarty_Internal_Template->render - [line 365 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php] Smarty_Internal_Template->_subTemplateRender - [line 127 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [10 Arguments] Smarty_Internal_Runtime_Inheritance->endChild - [line 40 - var/cache/dev/smarty/compile/79/c3/f4/79c3f4a635031d25f5509e459f0602613d1b8726_0.file.view.tpl.php] - [2 Arguments] content_5ce468e954b849_67733849 - [line 123 - vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php] - [1 Arguments] Smarty_Template_Resource_Base->getRenderedTemplateCode - [line 114 - vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php] - [1 Arguments] Smarty_Template_Compiled->render - [line 206 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php] - [1 Arguments] Smarty_Internal_Template->render - [line 232 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php] - [2 Arguments] Smarty_Internal_TemplateBase->_execute - [line 116 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php] - [5 Arguments] Smarty_Internal_TemplateBase->fetch - [line 113 - classes/helper/Helper.php] HelperCore->generate - [line 59 - classes/helper/HelperView.php] HelperViewCore->generateView - [line 2425 - classes/controller/AdminController.php] AdminControllerCore->renderView - [line 1910 - controllers/admin/AdminOrdersController.php] AdminOrdersControllerCore->renderView - [line 2073 - classes/controller/AdminController.php] AdminControllerCore->initContent - [line 255 - classes/controller/Controller.php] ControllerCore->run - [line 428 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 99 - admin/index.php] Share this post Link to post Share on other sites
shana0780 6 Posted December 26, 2019 (edited) On 5/23/2019 at 10:24 PM, MR M said: Hello all, I got the some as above problem but its bit different please anyone can help me to solve it if possible explain step by step so i can do it thanks and regards [PrestaShopDatabaseException] Unknown column 'id_paypal_order' in 'field list' SELECT id_paypal_order FROM `ps_paypal_order` WHERE (id_order = 9) LIMIT 1 at line 746 in file classes/db/Db.php 741. if ($webservice_call && $errno) { 742. $dbg = debug_backtrace(); 743. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 744. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 745. if ($sql) { 746. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 747. } 748. 749. throw new PrestaShopDatabaseException($this->getMsgError()); 750. } 751. } DbCore->displayError - [line 378 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 645 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 678 - classes/db/Db.php] - [2 Arguments] DbCore->getValue - [line 140 - modules/paypal/classes/PaypalOrder.php] - [1 Arguments] PaypalOrder::loadByOrderId - [line 1331 - modules/paypal/paypal.php] - [1 Arguments] PayPal->hookDisplayAdminOrder - [line 924 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 328 - classes/Hook.php] - [3 Arguments] HookCore::callHookOn - [line 860 - classes/Hook.php] - [3 Arguments] HookCore::exec - [line 165 - config/smarty.config.inc.php] - [3 Arguments] smartyHook - [line 83 - classes/Smarty/SmartyLazyRegister.php] - [2 Arguments] SmartyLazyRegister->__call - [line 1334 - var/cache/dev/smarty/compile/79/c3/f4/79c3f4a635031d25f5509e459f0602613d1b8726_0.file.view.tpl.php] - [2 Arguments] Block_7921671195ce468e9379654_15855508->callBlock - [line 247 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [1 Arguments] Smarty_Internal_Runtime_Inheritance->callBlock - [line 183 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [2 Arguments] Smarty_Internal_Runtime_Inheritance->process - [line 185 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [3 Arguments] Smarty_Internal_Runtime_Inheritance->process - [line 157 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [2 Arguments] Smarty_Internal_Runtime_Inheritance->instanceBlock - [line 34 - var/cache/dev/smarty/compile/bd/cc/4d/bdcc4dd6c40c04c020fed8c8e9402fb0b6793b84_0.file.view.tpl.php] - [3 Arguments] content_5ce294ef35ef41_34226729 - [line 123 - vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php] - [1 Arguments] Smarty_Template_Resource_Base->getRenderedTemplateCode - [line 114 - vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php] - [1 Arguments] Smarty_Template_Compiled->render - [line 206 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php] - [1 Arguments] Smarty_Internal_Template->render - [line 365 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php] Smarty_Internal_Template->_subTemplateRender - [line 127 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [10 Arguments] Smarty_Internal_Runtime_Inheritance->endChild - [line 40 - var/cache/dev/smarty/compile/79/c3/f4/79c3f4a635031d25f5509e459f0602613d1b8726_0.file.view.tpl.php] - [2 Arguments] content_5ce468e954b849_67733849 - [line 123 - vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php] - [1 Arguments] Smarty_Template_Resource_Base->getRenderedTemplateCode - [line 114 - vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php] - [1 Arguments] Smarty_Template_Compiled->render - [line 206 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php] - [1 Arguments] Smarty_Internal_Template->render - [line 232 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php] - [2 Arguments] Smarty_Internal_TemplateBase->_execute - [line 116 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php] - [5 Arguments] Smarty_Internal_TemplateBase->fetch - [line 113 - classes/helper/Helper.php] HelperCore->generate - [line 59 - classes/helper/HelperView.php] HelperViewCore->generateView - [line 2425 - classes/controller/AdminController.php] AdminControllerCore->renderView - [line 1910 - controllers/admin/AdminOrdersController.php] AdminOrdersControllerCore->renderView - [line 2073 - classes/controller/AdminController.php] AdminControllerCore->initContent - [line 255 - classes/controller/Controller.php] ControllerCore->run - [line 428 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 99 - admin/index.php] Hello, I have the same error after an upgrade from 1.6.1.8 to 1.7.6.2., can you solve it and how ? For information, the table exist and the ID order also. Thanks Edited December 26, 2019 by shana0780 (see edit history) Share this post Link to post Share on other sites
shana0780 6 Posted December 26, 2019 4 hours ago, shana0780 said: Hello, I have the same error after an upgrade from 1.6.1.8 to 1.7.6.2., can you solve it and how ? For information, the table exist and the ID order also. Thanks Resolved for me, I have only downloaded another version of Paypal. Share this post Link to post Share on other sites