Big Issue .... Unknown column 'id_shop' in 'where clause'

[Repsej]

Hi All,

I have a major problem.

Last hand on a shop to - but the shop suddenly doesnt show the products. I think its because some Categories has been deleted.

Can you help - i can´t solve this. Any ideas??

I have asked my ISP for at back up from the 18.11 as a last resort - as i dont want to loose the work that has been done since the 18.11 til now.

Thanks in advance

 

[PrestaShopDatabaseException]

Unknown column 'id_shop' in 'where clause'
 

Select id_category_default From ps_product Where id_shop = '1' AND id_product = 134 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 723 - classes/db/Db.php] - [2 Arguments]
• DbCore->getValue - [line 2163 - modules/simplecategory/simplecategory.php] - [1 Arguments]
• SimpleCategory->frontBuildModuleContent - [line 2125 - modules/simplecategory/simplecategory.php] - [2 Arguments]
• SimpleCategory->hooks - [line 2074 - modules/simplecategory/simplecategory.php] - [2 Arguments]
• SimpleCategory->hookdisplayHomeTopContent - [line 1061 - modules/oviclayoutcontrol/oviclayoutcontrol.php] - [1 Arguments]
• OvicLayoutControl->ModuleHookExec - [line 957 - modules/oviclayoutcontrol/oviclayoutcontrol.php] - [2 Arguments]
• OvicLayoutControl->generalHook - [line 1301 - modules/oviclayoutcontrol/oviclayoutcontrol.php] - [1 Arguments]
• OvicLayoutControl->hookdisplayHomeTopContent - [line 587 - classes/Hook.php] - [1 Arguments]
• HookCore::coreCallHook - [line 542 - classes/Hook.php] - [3 Arguments]
• HookCore::exec - [line 1261 - modules/oviclayoutcontrol/oviclayoutcontrol.php] - [1 Arguments]
• OvicLayoutControl->hookDisplayHeader - [line 587 - classes/Hook.php] - [1 Arguments]
• HookCore::coreCallHook - [line 542 - classes/Hook.php] - [3 Arguments]
• HookCore::exec - [line 579 - classes/controller/FrontController.php] - [1 Arguments]
• FrontControllerCore->initContent - [line 172 - controllers/front/ProductController.php]
• ProductControllerCore->initContent - [line 189 - classes/controller/Controller.php]
• ControllerCore->run - [line 367 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

Edited November 25, 2016 by Repsej (see edit history)

[bellini13]

the module you are using is defective.  you should contact the author