Jump to content

Erreur 500 sur admin client et produits


Recommended Posts

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

Share this post


Link to post
Share on other sites

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

  • Like 1

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More