jobine Posted October 3, 2020 Share Posted October 3, 2020 Bonjour, J'ai fait une mise à jour de 1.6.24 à 1.7.6.8. Je rencontre différent problème de base de données. Le back office fonctionne plus ou moins bien. Je rencontre des erreur 500 lorsque je change certaine configuration. J'ai activer l'affichage des erreurs et j'ai ceci: [PrestaShopDatabaseException] Unknown column 'a.weight' in 'field list'<br /><br /><pre>SELECT a.`id_ps_advice`, a.`selector`, a.`location`, al.`html`, a.`weight` FROM `advice` a LEFT JOIN `advice_lang` al ON al.`id_advice` = a.`id_advice` LEFT JOIN `tab_advice` at ON at.`id_advice` = a.`id_advice` WHERE ( a.`validated` = 1 AND a.`hide` = 0 AND al.`id_lang` = 2 AND at.`id_tab` = 333 AND ((a.`start_day` = 0 AND a.`stop_day` = 0) OR (03 >= a.`start_day` AND 03 <= a.`stop_day`))) </pre> 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 99 - modules/gamification/classes/Advice.php] - [1 Arguments] Advice::getValidatedByIdTab - [line 189 - modules/gamification/gamification.php] - [2 Arguments] gamification->hookDisplayBackOfficeHeader - [line 970 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 355 - classes/Hook.php] - [3 Arguments] Dans ma base, la table advise est vide et ne semble pas avoir les même éléments. Avez vous une idée du problème? Merci Link to comment Share on other sites More sharing options...
doekia Posted October 3, 2020 Share Posted October 3, 2020 ce module (gamification) n'ayant que pour seul but de gaspiller les performances pour flatter votre ego en vous donnant des images comme à la maternelle, le mieux est de désinstaller ce module Link to comment Share on other sites More sharing options...
jobine Posted October 3, 2020 Author Share Posted October 3, 2020 Est ce que c'est bien Expertise PrestaShop. Il me donne une erreur lorsque je veux le désinstaller à partir du BO. Comment le désinstaller manuellement? Merci de ton aide. Link to comment Share on other sites More sharing options...
doekia Posted October 3, 2020 Share Posted October 3, 2020 supprimer le répertoire en ftp Link to comment Share on other sites More sharing options...
jobine Posted October 3, 2020 Author Share Posted October 3, 2020 Ok, il n'y a rien à faire côté BDD? Link to comment Share on other sites More sharing options...
doekia Posted October 3, 2020 Share Posted October 3, 2020 Supprimer les tables du modules mais c'est pas très important 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