combyavm Posted March 6, 2017 Share Posted March 6, 2017 Bonjour, Je rencontre une page blanche sur mon site qui provient d'une erreur code 500 dû à une requête dans la base de données qui ne semble pas correcte. Est ce que quelqu'un peut m’éclairer sur ces erreurs ? merci d'avance Notice: unserialize(): Error at offset 1467 of 2921 bytes in /home/alaplanc/www/ventedeplancha-boutique/modules/leoblog/classes/config.php on line 35 [PrestaShopDatabaseException] Column 'id_product' in order clause is ambiguous SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, 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`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2017-03-02 00:00:00", INTERVAL 30 DAY)) > 0 AS new FROM `alaplanc_product_sale` ps LEFT JOIN `alaplanc_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN alaplanc_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `alaplanc_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 `alaplanc_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `alaplanc_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 `alaplanc_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `alaplanc_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `alaplanc_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 8 AND tr.`id_state` = 0 LEFT JOIN `alaplanc_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN alaplanc_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 p.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `alaplanc_category_product` cp JOIN `alaplanc_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `id_product` ASC LIMIT 0, 16 at line 765 in file classes/db/Db.php 760. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 761. } 762. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 763. { 764. if ($sql) 765. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 766. 767. throw new PrestaShopDatabaseException($this->getMsgError()); 768. } 769. } 770. DbCore->displayError - [line 418 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 620 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 133 - classes/ProductSale.php] - [1 Arguments] ProductSaleCore::getBestSales - [line 251 - modules/leotempcp/classes/widget/producttabs.php] - [5 Arguments] LeoWidgetProducttabs->renderContent - [line 240 - modules/leotempcp/classes/widget.php] - [2 Arguments] LeoTempcpWidget->getWidgetContent - [line 254 - modules/leotempcp/classes/widget.php] - [2 Arguments] LeoTempcpWidget->renderContent - [line 1203 - modules/leomanagewidgets/leomanagewidgets.php] - [1 Arguments] LeoManagewidgets->_setGroupData - [line 1290 - modules/leomanagewidgets/leomanagewidgets.php] - [2 Arguments] LeoManagewidgets->_processHook - [line 1579 - modules/leomanagewidgets/leomanagewidgets.php] - [1 Arguments] LeoManagewidgets->hookDisplayHome - [line 569 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 524 - classes/Hook.php] - [3 Arguments] HookCore::exec - [line 40 - controllers/front/IndexController.php] - [1 Arguments] IndexControllerCore->initContent - [line 180 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Link to comment Share on other sites More sharing options...
J. Danse Posted March 6, 2017 Share Posted March 6, 2017 Bonjour, Votre requête comporte ceci: ORDER BY `id_product` ASC Le soucis, c'est que id_product se retrouve dans plusieurs tables et le gestionnaire SQL ne sait laquelle reprendre. Vous pouvez par exemple modifier cela par ORDER BY p.`id_product` ASC Link to comment Share on other sites More sharing options...
combyavm Posted March 6, 2017 Author Share Posted March 6, 2017 Merci beaucoup pour votre réponse, je vais me penser dessus pour voir comment modifier cela. 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