Jump to content
Centaure

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,

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

Share this post


Link to post
Share on other sites

J4ai essayé en php 7.0, 7.2, 7.3 et même 5.6

idem

toujours cette erreur

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
Posted (edited)

Je viens de tester, cela ne change rien pour moi ...

Par contre j'ai deux index ...

image.png.f58950b7916a1324ef7f597327f35230.png

 

Edited by Centaure
Ajout screenshot (see edit history)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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