tashkas Posted January 17, 2014 Share Posted January 17, 2014 i got this error in log file, whats wrong with it? *ERROR* 2014/01/12 - 00:06:29: 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 '1,12,19,30,35,37,40,42,43,44,45,47,48,49,50,51,53,55,57,58,63,65,66,68,69,73,82,' at line 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`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, MAX(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(NOW(), INTERVAL 20 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT 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` = 16 AND pl.id_shop = 1 LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 16) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 131 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_shop = 1 ) WHERE product_shop.`active` = 1 AND p.`visibility` != 'none' AND p.`id_product` IN (,1,12,19,30,35,37,40,42,43,44,45,47,48,49,50,51,53,55,57,58,63,65,66,68,69,73,82,88,89,90,91,92,102,125,127,131,134,139,142,143,163,164,168,169,170,173,174,201,207,211,213,217,218,220,221,225,228,229,231,235,243,250,254,260,263,265,271,272,274,275,279,281,282,283,284,285,286,287,288,289,294,295,300,301,302,303,304,307,308,309,310,312,313,314,315,316,317,318,319,320,321,323,324,325,326,327,329,332,333,334,335,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,361,362,364,365,366,367,368,369,371,372,373,375,377,378,379,380,381,382,383,384,385,386) GROUP BY product_shop.id_product ORDER BY `sales` DESC LIMIT 0, 10</pre> at line 613 in file classes/db/Db.php *ERROR* Link to comment Share on other sites More sharing options...
Sharak Posted January 17, 2014 Share Posted January 17, 2014 Probably an old error stored while you were fixing something on the shop. Did it happen again after 2014/01/12 - 00:06:29 ? Link to comment Share on other sites More sharing options...
tashkas Posted January 18, 2014 Author Share Posted January 18, 2014 (edited) there is no logs after that date Edited January 18, 2014 by tashkas (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted January 19, 2014 Share Posted January 19, 2014 it's because of missed number here,1,12,19,30,35,37,40,42,43,44,45,47,48,49,50,51,53,55,57,58,63,65,66,68,69,73,82,88,89,90,91,92,102,125,127,131,134,139,142,14 you've got this error all the time? Link to comment Share on other sites More sharing options...
Recommended Posts