boutique inaccessible [PrestaShopDatabaseException]

[[email protected]]

Bonjour à tous,

Voilà mon problème. Suite à une tentative de restauration à une version antérieur des fichier et la bdd (sauvegarde faite avec le module "1-Click Upgrade")

Tout s'est apriori bien passé mais lorsque j'ai voulu accédé au site ja'i le message suivant;

[PrestaShopDatabaseException]
Table 'hhyyxjsfevierdor.pre9722_guest' doesn't exist<br /><br /><pre>INSERT INTO `pre9722_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('7', '11', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')</pre>
at line 769 in file classes/db/Db.php

764.         if ($webservice_call && $errno) {
765.             $dbg = debug_backtrace();
766.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $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 740 - classes/db/Db.php] - [1 Arguments]
DbCore->q - [line 476 - classes/db/Db.php] - [2 Arguments]
DbCore->insert - [line 559 - classes/ObjectModel.php] - [3 Arguments]
ObjectModelCore->add - [line 516 - classes/ObjectModel.php] - [2 Arguments]
ObjectModelCore->save - [line 239 - classes/Guest.php]
GuestCore::setNewGuest - [line 83 - modules/statsdata/statsdata.php] - [1 Arguments]
statsdata->getScriptPlugins - [line 74 - modules/statsdata/statsdata.php] - [1 Arguments]
statsdata->hookDisplayBeforeBodyClosingTag - [line 970 - classes/Hook.php] - [1 Arguments]
HookCore::coreCallHook - [line 355 - classes/Hook.php] - [3 Arguments]
HookCore::callHookOn - [line 907 - classes/Hook.php] - [3 Arguments]
HookCore::exec - [line 167 - config/smarty.config.inc.php] - [3 Arguments]
smartyHook - [line 83 - classes/Smarty/SmartyLazyRegister.php] - [2 Arguments]
SmartyLazyRegister->__call - [line 369 - var/cache/dev/smarty/compile/layouts_layout_full_width_tpl/f1/a9/4a/f1a94a9dcf138297ece578f1387aea70ef62be17_2.file.layout-both-columns.tpl.php] - [2 Arguments]
Block_8938930285fb532b75aabe5_11208070->callBlock - [line 248 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [1 Arguments]
Smarty_Internal_Runtime_Inheritance->callBlock - [line 184 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [2 Arguments]
Smarty_Internal_Runtime_Inheritance->process - [line 156 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [2 Arguments]
Smarty_Internal_Runtime_Inheritance->instanceBlock - [line 115 - var/cache/dev/smarty/compile/layouts_layout_full_width_tpl/f1/a9/4a/f1a94a9dcf138297ece578f1387aea70ef62be17_2.file.layout-both-columns.tpl.php] - [3 Arguments]
content_5fb532b75ab873_86971641 - [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 385 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php]
Smarty_Internal_Template->_subTemplateRender - [line 125 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [10 Arguments]
Smarty_Internal_Runtime_Inheritance->endChild - [line 42 - var/cache/dev/smarty/compile/layouts_layout_full_width_tpl/47/0a/fb/470afb767656c8004476c9277ca5c925cf9c8bf7_2.file.layout-full-width.tpl.php] - [2 Arguments]
content_5fb532b7535513_73148768 - [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 385 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php]
Smarty_Internal_Template->_subTemplateRender - [line 125 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [10 Arguments]
Smarty_Internal_Runtime_Inheritance->endChild - [line 33 - var/cache/dev/smarty/compile/layouts_layout_full_width_tpl/d5/1a/fd/d51afdecd4df2ace99cc82a73bf0929708445720_2.file.page.tpl.php] - [2 Arguments]
content_5fb532b74ae771_06076188 - [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 385 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php]
Smarty_Internal_Template->_subTemplateRender - [line 125 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [10 Arguments]
Smarty_Internal_Runtime_Inheritance->endChild - [line 33 - var/cache/dev/smarty/compile/layouts_layout_full_width_tpl/7f/c4/69/7fc4698da3342df04b4c28349f754d49a0d3d0e8_2.file.index.tpl.php] - [2 Arguments]
content_5fb532b74953b2_69681666 - [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 40 - classes/Smarty/SmartyDev.php] - [7 Arguments]
SmartyDev->fetch - [line 683 - classes/controller/FrontController.php] - [3 Arguments]
FrontControllerCore->smartyOutputContent - [line 40 - override/classes/controller/FrontController.php] - [1 Arguments]
FrontController->smartyOutputContent - [line 667 - classes/controller/FrontController.php] - [1 Arguments]
FrontControllerCore->display - [line 312 - classes/controller/Controller.php]
ControllerCore->run - [line 515 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]

Si j'ai bien compris il manque la table "pre9722_guest" n'existe pas. Mais après vérification sur PhpMyadmin, elle existe bien, aussi que les champs avec leurs valeurs correspondantes.

Et le back office est quand à lui toujours accessible...

Quelqu'in a-t-il déjà été confronté à ce message et saurait m'aiguiller s'il vous plait ?

 

Edited November 18, 2020 by [email protected] (see edit history)

[HeineFR]

La table demandée est censée se trouver dans la BASE "hhyyxjsfevierdor", est-ce bien le cas?

[doekia]

Elle ne peut pas exister compte tenu de l'erreur mysql. Vous n'êtes surment pas connecté sur la bonne base de données lorsque vous vérifiez

[[email protected]]

4 hours ago, HeineFR said:

La table demandée est censée se trouver dans la BASE "hhyyxjsfevierdor", est-ce bien le cas?

Merci pour votre réponse. 

Autant pour moi, j'ai regardé dans la mauvaise bdd. 

Après verification dans la bonne base "hhyyxfevierdor' - la table "pre9722_guest" n'existant pas, je l'ai recréé et réinséré les valeurs.

Cependant j'ai maintenant un nouveau message d'erreur :

[PrestaShopDatabaseException]
Table 'hhyyxjsfevierdor.pre9722_connections' doesn't exist<br /><br /><pre>SELECT SQL_NO_CACHE `id_guest` FROM `pre9722_connections` WHERE `id_guest` = 0 AND `date_add` > '2020-11-18 23:59:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1</pre>
at line 769 in file classes/db/Db.php

764.         if ($webservice_call && $errno) {
765.             $dbg = debug_backtrace();
766.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $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]
380.                 $this->result = $this->_query($sql);
381.             }
382.         }
383. 
384.         if (_PS_DEBUG_SQL_) {
385.             $this->displayError($sql);
386.         }
387. 
388.         return $this->result;
389.     }
390. 
DbCore->query - [line 663 - classes/db/Db.php] - [1 Arguments]
658. 
659.                 return $result;
660.             }
661.         }
662. 
663.         $this->result = $this->query($sql);
664.         if (!$this->result) {
665.             $result = false;
666.         } else {
667.             $result = $this->nextRow($this->result);
668.         }
DbCore->getRow - [line 163 - classes/Connection.php] - [2 Arguments]
158. 				FROM `' . _DB_PREFIX_ . 'connections`
159. 				WHERE `id_guest` = ' . (int) $cookie->id_guest . '
160. 					AND `date_add` > \'' . pSQL(date('Y-m-d H:i:00', time() - 1800)) . '\'
161. 					' . Shop::addSqlRestriction(Shop::SHARE_CUSTOMER) . '
162. 				ORDER BY `date_add` DESC';
163.         $result = Db::getInstance()->getRow($sql, false);
164.         if (!$result['id_guest'] && (int) $cookie->id_guest) {
165.             // The old connections details are removed from the database in order to spare some memory
166.             Connection::cleanConnectionsPages();
167. 
168.             $referer = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '';
ConnectionCore::setNewConnection - [line 97 - classes/Connection.php] - [1 Arguments]
ConnectionCore::setPageConnection - [line 117 - modules/statsdata/statsdata.php] - [1 Arguments]
statsdata->getScriptCustomerPagesViews - [line 75 - modules/statsdata/statsdata.php] - [1 Arguments]
statsdata->hookDisplayBeforeBodyClosingTag - [line 970 - classes/Hook.php] - [1 Arguments]
HookCore::coreCallHook - [line 355 - classes/Hook.php] - [3 Arguments]
HookCore::callHookOn - [line 907 - classes/Hook.php] - [3 Arguments]
HookCore::exec - [line 167 - config/smarty.config.inc.php] - [3 Arguments]
smartyHook - [line 83 - classes/Smarty/SmartyLazyRegister.php] - [2 Arguments]
SmartyLazyRegister->__call - [line 369 - var/cache/dev/smarty/compile/layouts_layout_full_width_tpl/f1/a9/4a/f1a94a9dcf138297ece578f1387aea70ef62be17_2.file.layout-both-columns.tpl.php] - [2 Arguments]
Block_6060138875fb59f18d5a134_38416261->callBlock - [line 248 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [1 Arguments]
Smarty_Internal_Runtime_Inheritance->callBlock - [line 184 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [2 Arguments]
Smarty_Internal_Runtime_Inheritance->process - [line 156 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [2 Arguments]
Smarty_Internal_Runtime_Inheritance->instanceBlock - [line 115 - var/cache/dev/smarty/compile/layouts_layout_full_width_tpl/f1/a9/4a/f1a94a9dcf138297ece578f1387aea70ef62be17_2.file.layout-both-columns.tpl.php] - [3 Arguments]
content_5fb59f18d5b974_30014611 - [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 385 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php]
Smarty_Internal_Template->_subTemplateRender - [line 125 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [10 Arguments]
Smarty_Internal_Runtime_Inheritance->endChild - [line 42 - var/cache/dev/smarty/compile/layouts_layout_full_width_tpl/47/0a/fb/470afb767656c8004476c9277ca5c925cf9c8bf7_2.file.layout-full-width.tpl.php] - [2 Arguments]
content_5fb59f18d26ae6_23648813 - [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 385 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php]
Smarty_Internal_Template->_subTemplateRender - [line 125 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [10 Arguments]
Smarty_Internal_Runtime_Inheritance->endChild - [line 33 - var/cache/dev/smarty/compile/layouts_layout_full_width_tpl/d5/1a/fd/d51afdecd4df2ace99cc82a73bf0929708445720_2.file.page.tpl.php] - [2 Arguments]
content_5fb59f18cd86c9_07107322 - [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 385 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php]
Smarty_Internal_Template->_subTemplateRender - [line 125 - vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php] - [10 Arguments]
Smarty_Internal_Runtime_Inheritance->endChild - [line 33 - var/cache/dev/smarty/compile/layouts_layout_full_width_tpl/7f/c4/69/7fc4698da3342df04b4c28349f754d49a0d3d0e8_2.file.index.tpl.php] - [2 Arguments]
content_5fb59f18c90528_65962884 - [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 40 - classes/Smarty/SmartyDev.php] - [7 Arguments]
SmartyDev->fetch - [line 683 - classes/controller/FrontController.php] - [3 Arguments]
FrontControllerCore->smartyOutputContent - [line 667 - classes/controller/FrontController.php] - [1 Arguments]
FrontControllerCore->display - [line 312 - classes/controller/Controller.php]
ControllerCore->run - [line 515 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]

Donc pour debugger, ma solution serait de recréer les tables manquantes comme 'pre9722_connections' ?

 

 

[[email protected]]

13 hours ago, doekia said:

Elle ne peut pas exister compte tenu de l'erreur mysql. Vous n'êtes surment pas connecté sur la bonne base de données lorsque vous vérifiez

Excusez-moi je ne suis trompé de bdd. 

Voir c-dessus. 

Merci pour ta réponse

Edited November 19, 2020 by [email protected] (see edit history)

[HeineFR]

Lis la nouvelle erreur à la deuxième ligne :

Table 'hhyyxjsfevierdor.pre9722_connections' doesn't exist

 

[[email protected]]

6 hours ago, HeineFR said:

Lis la nouvelle erreur à la deuxième ligne :

Table 'hhyyxjsfevierdor.pre9722_connections' doesn't exist

 

Tout est rentré dans l'ordre - j'ai restauré la bonne bdd (erreur d'inattention).

Merci pour vos réponses