Centaure Posted August 17, 2019 Share Posted August 17, 2019 Bonjour, J'ai une erreur 500 uniquement sur les pages d'administration des Clients et des Produits ... Je n'ai rien installé de particulier, juste passé en 1.7.6.0 ... 🙄 J'ai supprimé les dossier var/cache/prod et var/cache/dev renommé le .htacces en mode debug j'ai ces messages : CRITICAL 14:51:30 php Uncaught Exception: An exception occurred while executing 'SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1' with params [1, 1, "customer", "index"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list' CRITICAL 14:51:30 request Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'SELECT t0.id AS id_1, t0.employee AS employee_2, t0.shop AS shop_3, t0.controller AS controller_4, t0.action AS action_5, t0.filter AS filter_6, t0.filter_id AS filter_id_7 FROM ps_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1' with params [1, 1, "customer", "index"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list'" at /home/MONSITE/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 dans le log de mon serveur j'ai ceci : [Sat Aug 17 14:43:20.774709 2019] [fcgid:warn] [pid 506] [client 80.13.173.191:53938] mod_fcgid: stderr: PHP Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/MONSITE/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php on line 2636, referer: https://www.MONSITE.info/adminMONSITE/index.php?controller=AdminDashboard&token=8ac903f275507d2a0eeee70814753b41 [Sat Aug 17 14:43:20.774731 2019] [fcgid:warn] [pid 506] [client 80.13.173.191:53938] mod_fcgid: stderr: PHP Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/MONSITE/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php on line 2665, referer: https://www.MONSITE.info/adminMONSITE/index.php?controller=AdminDashboard&token=8ac903f275507d2a0eeee70814753b41 Merci par avance pour votre aide Link to comment Share on other sites More sharing options...
Webmain Posted August 18, 2019 Share Posted August 18, 2019 Bonsoir, quel version de php? Link to comment Share on other sites More sharing options...
Dollergraphiques Posted August 19, 2019 Share Posted August 19, 2019 Bonjour, Nous avons exactement la même erreur suite à MAJ en passant 1.7.5.0 à 1.7.6.0. La version de notre PHP est 7.1 ( on a essayé de la passer en 7.2 mais ça ne fonctionne pas ) Merci pour votre aide Link to comment Share on other sites More sharing options...
Centaure Posted August 19, 2019 Author Share Posted August 19, 2019 J4ai essayé en php 7.0, 7.2, 7.3 et même 5.6 idem toujours cette erreur Link to comment Share on other sites More sharing options...
Webmain Posted August 19, 2019 Share Posted August 19, 2019 Bonjour, Essayer ceci : Allez dans la table admin_filter Ensuite dans l'onglet structure plus bas vous avez ceci : https://gyazo.com/b9d17e873cf680168a2b96760692f478 Ensuite vous cliquer sur editer admin_filter_search_idx et au lieu de unique vous mettez INDEX https://gyazo.com/5f655d7f4aa35b4e0ab7de10354bf241 Ensuite allez sur vos pages & actualisé ctrl+R Ceci est un semi patch une fois que la version 1.7.6.1 sortira faite la mise à jours puis remettez le index en Unique. Cordialement 1 Link to comment Share on other sites More sharing options...
Centaure Posted August 19, 2019 Author Share Posted August 19, 2019 (edited) Je viens de tester, cela ne change rien pour moi ... Par contre j'ai deux index ... Edited August 19, 2019 by Centaure Ajout screenshot (see edit history) Link to comment Share on other sites More sharing options...
Webmain Posted August 19, 2019 Share Posted August 19, 2019 Tu as vidé ton cache puis tester? Link to comment Share on other sites More sharing options...
Centaure Posted August 19, 2019 Author Share Posted August 19, 2019 oui oui même celui de prestashop Link to comment Share on other sites More sharing options...
Webmain Posted August 19, 2019 Share Posted August 19, 2019 Ok dans admin_filter vide toutes les données sauf les indexes. Link to comment Share on other sites More sharing options...
Centaure Posted August 19, 2019 Author Share Posted August 19, 2019 idem rien n'y fait Link to comment Share on other sites More sharing options...
Webmain Posted August 19, 2019 Share Posted August 19, 2019 (edited) Oupss, ajoute cette colonne : https://gyazo.com/59b0d1ab63147687bc733b00de51f5e6 Dans la table admin_filter Edited August 19, 2019 by Esh-Network (see edit history) 1 1 Link to comment Share on other sites More sharing options...
Centaure Posted August 19, 2019 Author Share Posted August 19, 2019 Impeccable ! 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