bug page d'accueil

[c.imane]

Bonjour

mon site ne s'affiche plus et me donne l erreur suivante plz help.

 

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND product_shop.`visibility` IN ("both", "catalog") ORDER BY p.id_product LIM' at line 31SELECT DISTINCT p.`id_product`, p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 20 DAY)) > 0 AS new, (product_shop.`price` * IF(t.`rate`,((100 + (t.`rate`))/100),1)) AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` 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_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 5 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 5 AND pl.id_shop = 1 ) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 5) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = 152 AND tr.`id_state` = 0 AND tr.`zipcode_from` = 0) LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `ps_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 5) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND ((product_attribute_shop.id_product_attribute IS NOT NULL OR pa.id_product_attribute IS NULL) OR (product_attribute_shop.id_product_attribute IS NULL AND pa.default_on=1)) AND product_shop.`active` = 1 AND p.id_product IN () AND product_shop.`visibility` IN ("both", "catalog") ORDER BY p.id_product LIMIT 0,6

at line 605 in file classes/db/Db.php

 

 

599. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

600. }

601. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))

602. {

603. if ($sql)

604. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

605. throw new PrestaShopDatabaseException($this->getMsgError());

606. }

607. }

608.

609. /**

• [b]DbCore->displayError[/b] - [line 307 - classes/db/Db.php] - [1 Arguments]
  
• [b]DbCore->query[/b] - [line 482 - classes/db/Db.php] - [1 Arguments]
  
• [b]DbCore->executeS[/b] - [line 729 - modules/lofnewproduct/libs/groups/product/product.php] - [1 Arguments]
  
• [b]LofNewProductDataSource::getProductsV15[/b] - [line 112 - modules/lofnewproduct/libs/groups/product/product.php] - [4 Arguments]
  
• [b]LofNewProductDataSource->getListFeatured[/b] - [line 414 - modules/lofnewproduct/lofnewproduct.php] - [1 Arguments]
  
• [b]lofnewproduct->processHook[/b] - [line 187 - modules/lofnewproduct/lofnewproduct.php] - [2 Arguments]
  
• [b]lofnewproduct->hookHome[/b] - [line 419 - classes/Hook.php] - [1 Arguments]
  
• [b]HookCore::exec[/b] - [line 39 - controllers/front/IndexController.php] - [1 Arguments]
  
• [b]IndexControllerCore->initContent[/b] - [line 167 - classes/controller/Controller.php] - [size=3][0 Argument][/size]
  
• [b]ControllerCore->run[/b] - [line 348 - classes/Dispatcher.php] - [size=3][0 Argument][/size]
  
• [b]DispatcherCore->dispatch[/b] - [line 28 - index.php] - [size=3][0 Argument][/size]
  

[Gregory Roussac]

Hello,

 

ce module est la cause de tes soucis.

 

lofnewproduct

 

DbCore->executeS - [line 729 - modules/lofnewproduct/libs/groups/product/product.php] - [1 Arguments]