Prestashop internal error

[yboubker]

Hello everyone,

My prestashop website encounters internal technical problem now and then. here is what the error says:

 

 

[PrestaShopDatabaseException]

 

Table 'mrwcraftshop.pref_poshook' doesn't exist

 

 

SELECT *

FROM `pref_poshook` WHERE theme="pos_corau" AND id_shop=1

 

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

607. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

608. }

609. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))

610. {

611. if ($sql)

612. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

613. throw new PrestaShopDatabaseException($this->getMsgError());

614. }

615. }

616. 

617. /**

DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]

DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments]

DbCore->executeS - [line 400 - modules/posthemeoptions/posthemeoptions.php] - [1 Arguments]

posthemeoptions->hookHeader - [line 475 - classes/Hook.php] - [1 Arguments]

HookCore::exec - [line 428 - classes/controller/FrontController.php] - [1 Arguments]

FrontControllerCore->initContent - [line 100 - controllers/front/CategoryController.php] - [0 Argument]

CategoryControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]

ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]

DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]

 

 

Please help!

[vekia]

you use some non default module because pref_poshook is not default table

have you got any idea what module it can be? it looks like  modules/posthemeoptions/

[yboubker]

Hi Vekia,

 

Thank you very much for your response!

I haven't got any idea about the module which causes this. But, yes the module posthemeoptions is installed. I deactivated the module but the theme am using got messed up.

 

What do you think about that?

[vekia]

try to reinstall this module, it looks like it uses some non default tables in database (so i suppose that this addon creates them during installation process of this module)