PrestaShopDatabaseException after restore from backup

[gregbg]

Hello,

I have a problem after restore from backup I am receiving Back Order error 500. When I  enable define.incs.php to show the errors, I see the following error.

It is no mather what backup I restore, even 5 days ago, I have the same error. Do you have and idea how to fix this? 

Please help!

[PrestaShopDatabaseException]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5

 

SELECT o.id_order
        FROM ps_orders o
        LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
        WHERE o.valid = 1
        AND od.product_id IN ()

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

764.         if ($webservice_call && $errno) {
765.             $dbg = debug_backtrace();
766.             WebserviceRequest::getInstance()->setError(500, '

 ' . $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 154 - modules/iqitcrossselling/iqitcrossselling.php] - [1 Arguments]
• IqitCrossselling->getOrderProducts - [line 103 - modules/iqitcrossselling/iqitcrossselling.php] - [1 Arguments]
• IqitCrossselling->getWidgetVariables - [line 134 - modules/iqitcrossselling/iqitcrossselling.php] - [2 Arguments]
• IqitCrossselling->renderWidget - [line 62 - override/classes/Hook.php] - [2 Arguments]
• Hook::coreRenderWidget - [line 923 - 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 517 - var/cache/dev/smarty/compile/1a/7b/59/1a7b5933f9b1fc22fa3590f790e7435e25b06d1f_0.file.header.tpl.php] - [2 Arguments]
• content_5ce523242e48e4_14978479 - [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 216 - 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 1845 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->display - [line 301 - classes/controller/Controller.php]
• ControllerCore->run - [line 387 - override/classes/Dispatcher.php]
• Dispatcher->dispatch - [line 99 - admin/index.php]

[gregbg]

Any help?

Please!

[JBW]

This is caused in module IqitCrossselling.

The module tries to read product database, but the given list of related articles is empty.

Try to reset/reinstall the module. If it doesn't help, deactivate the module as ask the developer to fix it