Jump to content

Recommended Posts

Bonjour

je viens de faire une mise a jour automatique  de Presta 1.7.5.2  vers 1.7.6.4 mais à la fin de la MAj  , j'ai un  message d'erreur  :

SQL 1.7.6.2 1136 in INSERT INTO `mdn_category_lang` SELECT `entity`.`id_category`, 1, `entity`.`id_lang`, `entity`.`name`, `entity`.`description`, `entity`.`link_rewrite`, `entity`.`meta_title`, `entity`.`meta_keywords`, `entity`.`meta_description` FROM `mdn_category_lang` entity LEFT JOIN `mdn_category_lang` entity2 ON `entity2`.`id_shop` = 1 AND `entity`.`id_category` = `entity2`.`id_category` WHERE `entity2`.`id_shop` IS NULL: Column count doesn't match value count at row 1

Mon Pretashop est bien maintenant en  1.7.6.4  mais quand je veux (dans l'admin)  aller dans Catalogue > catégories cela me génère une page blanche avec errreur 500

Oops! An Error Occurred

The server returned a "500 Internal Server Error".

Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused.

Je peux accéder à tous les menus et sous menu de l'admin mais j'ai cette errieur 500 uniquement quand je veux afficher les catégories dans l'admin .

 

Quelqu'un a eu idée pour resoudre ce problème ?

 

Share this post


Link to post
Share on other sites

en fait mon erreur 500 ne se  limite pas aux catégories (BO) mais  aussi

> produits

> marques & fournisseurs

> clients

> traffic & seo

> contact

> taxes

Le bebug me remonte a chaque fois ses erreurs

CRITICAL 18:51:14phpUncaught 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 mdn_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1' with params [1, 1, "tax", "index"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list'

CRITICAL 18:51:14requestUncaught 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 mdn_admin_filter t0 WHERE t0.employee = ? AND t0.shop = ? AND t0.controller = ? AND t0.action = ? LIMIT 1' with params [1, 1, "tax", "index"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.filter_id' in 'field list'" at /home/www/shop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71

Share this post


Link to post
Share on other sites
Posted (edited)

encore moi 🤪

 

J'ai trouvé une solution partielle ici https://github.com/PrestaShop/PrestaShop/issues/14617 en exécutant cette  slq 

ALTER TABLE `PREFIX_admin_filter` ADD `filter_id` VARCHAR (255) DEFAULT '' NOT NULL AFTER `shop`;

 mais tout ne re-fonctionne pas ...

> produits (erreur 500 )

> cétégorie (erreur 500 )

> marques & fournisseurs (erreur 500 )

> clients (ok)

> traffic & seo (ok)

> contact  (ok)

> taxes (ok)

 

reste donc encore 3 erreurs 500

Edited by webncie (see edit history)

Share this post


Link to post
Share on other sites

Bonjour,

Depuis la mise à jour vers la version 1.7.6.4 je retrouve le même problème sur la majorité de mes fiches produits. Je peux en ouvrir quelques unes mais c'est rare mais je ne peux plus créer de produits.

Bien cordialement

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.
Note: Your post will require moderator approval before it will be visible.

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