nedrahaj Posted May 22, 2023 Share Posted May 22, 2023 (edited) Bonjour à tous , mon site fonctionne correctement , mais pour des raisons de référencement, j'active le mode debug , les pages de produits sont affichés mais quand j'accède aux autres pages l'errure suivante s'affiche Prestashop version : 1.7.8.7 Merci de m'aider [PrestaShopDatabaseException] Incorrect DATETIME value: '-3453-07-29'<br /><br /><pre>SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2023-05-22 00:00:00", INTERVAL 2000000 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (product_shop.`date_add` > "-3453-07-29") ORDER BY product_shop.`date_add` DESC LIMIT 4</pre> at line 769 in file classes/db/Db.php Edited June 13, 2023 by nedrahaj pour clarifier que le sujet est résolu (see edit history) Link to comment Share on other sites More sharing options...
Eolia Posted May 22, 2023 Share Posted May 22, 2023 Non mais Lol... "Considérer le produit comme nouveau" vous avez mis 2000000 ? Sérieusement. Effectivement Prestashop fait le calcul et arrive à une date de l'an -3453... Link to comment Share on other sites More sharing options...
nedrahaj Posted May 23, 2023 Author Share Posted May 23, 2023 Comment résoudre le problème svp, j'ai pas compris bien 🙂 Link to comment Share on other sites More sharing options...
Mediacom87 Posted May 23, 2023 Share Posted May 23, 2023 il y a une heure, nedrahaj a dit : Comment résoudre le problème svp, j'ai pas compris bien 🙂 Configurez convenablement le nombre de jours pendant lequel les produits sont considérés comme nouveaux. Link to comment Share on other sites More sharing options...
nedrahaj Posted May 23, 2023 Author Share Posted May 23, 2023 Résolu, Merci beaucoup Mediacom87 pour ceux qui veulent la réponse au cas ou mème problème , voir la capture Link to comment Share on other sites More sharing options...
Mediacom87 Posted May 23, 2023 Share Posted May 23, 2023 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