Klemart3D Posted August 22, 2016 Share Posted August 22, 2016 (edited) Bonjour, Suite à un serveur plein (avec Prestashop 1.6.0.13), le module Bloc navigation à facettes a généré quelques erreurs allant jusqu'à corrompre certaines bases liées aux modules et affichant, par conséquent, des erreurs en front sur toutes les pages catégorie / produit. Messages d'erreur : Table 'database.ps_layered_friendly_url' doesn't exist Table 'database.ps_layered_product_attribute' doesn't exist [PrestaShopDatabaseException] Table 'database.ps_layered_friendly_url' doesn't exist SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = '1196b52362647d9d04cc81eb54e5d50b' LIMIT 1at line 646 in file classes/db/Db.php 641. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);642. }643. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))644. {645. if ($sql)646. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');647. throw new PrestaShopDatabaseException($this->getMsgError());648. }649. }650.651. /** DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 558 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 583 - classes/db/Db.php] - [2 Arguments] DbCore->getValue - [line 1721 - modules/blocklayered/blocklayered.php] - [1 Arguments] BlockLayered->getSelectedFilters - [line 687 - modules/blocklayered/blocklayered.php] BlockLayered->hookHeader - [line 512 - classes/Hook.php] - [1 Arguments] HookCore::exec - [line 456 - classes/controller/FrontController.php] - [1 Arguments] FrontControllerCore->initContent - [line 104 - controllers/front/CategoryController.php] CategoryControllerCore->initContent - [line 180 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Solution : 1. Se connecter à la base de données MySQL en SSH : mysql database-name -u root -p 2. Vérifier la présence des tables dans l'index MySQL : SHOW TABLES; … | ps_layered_friendly_url | ps_layered_product_attribute | … 3. Vérifier que les tables n'existent pas : select * from ps_layered_friendly_url; select * from ps_layered_product_attribute; > ERROR 1146 (42S02): Table 'database.ps_layered_friendly_url' doesn't exist > ERROR 1146 (42S02): Table 'database.ps_layered_product_attribute' doesn't exist 4. Créer un fichier SQL comportant les requêtes de création et de complétion des 2 tables manquantes à partir du dernier dump SQL (ou backup de base) 5. Insérer en base le fichier SQL créé : mysql database-name -u root -p < /tmp/fichier.sql 6. Dans le BO Prestashop, aller dans : MODULES > BLOCKLAYERED (Bloc navigation à facettes) > SETTINGS et indexer chacune des 4 tabs Si les 4 tabs sont réindexées sans erreur, c'est bon signe, le site devrait à nouveau fonctionner correctement ! Edited August 22, 2016 by Klemart3D (see edit history) Link to comment Share on other sites More sharing options...
doekia Posted August 22, 2016 Share Posted August 22, 2016 (edited) (deleted) Edited July 16, 2019 by doekia (see edit history) Link to comment Share on other sites More sharing options...
terbotanic Posted July 15, 2019 Share Posted July 15, 2019 (edited) Yo lo he resuelto buscando el modulo que corresponde con esa tabla y reinstalandolo Edited July 15, 2019 by terbotanic (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now