todaytonight Posted June 22, 2012 Share Posted June 22, 2012 I have upgraded my shop from v1.3.2 to the latest version v1.4.8.2. It is weired, after upgrading, there are no products diplayed and the message says: "There are no products in this category". However, at the title, it shows "Sheer TightsThere are 12 products". Also at back office, I can see all products under the category. I have attached the screen-shot with this post. Could anyone help me with this issue please? Thank you so much. Link to comment Share on other sites More sharing options...
todaytonight Posted June 24, 2012 Author Share Posted June 24, 2012 Could someone kindly help please? It is very urgent. Thanks Link to comment Share on other sites More sharing options...
todaytonight Posted June 25, 2012 Author Share Posted June 25, 2012 could anyone help please? Link to comment Share on other sites More sharing options...
todaytonight Posted June 25, 2012 Author Share Posted June 25, 2012 I turned on the sql debug and I got this error: Unknown column 'a.reduction_from' in 'field list' SELECT SQL_CALC_FOUND_ROWS b.*, a.*, cp.`position`, i.`id_image`, (a.`price` * ((100 + (t.`rate`))/100) - IF((DATEDIFF(a.`reduction_from`, CURDATE()) <= 0 AND DATEDIFF(a.`reduction_to`, CURDATE()) >=0) OR a.`reduction_from` = a.`reduction_to`, IF(a.`reduction_price` > 0, a.`reduction_price`, (a.`price` * ((100 + (t.`rate`))/100) * a.`reduction_percent` / 100)),0)) AS price_final FROM `ps_product` a LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1) LEFT JOIN `ps_image` i ON (i.`id_product` = a.`id_product` AND i.`cover` = 1) LEFT JOIN `ps_category_product` cp ON (cp.`id_product` = a.`id_product`) LEFT JOIN `ps_tax` t ON (t.`id_tax` = a.`id_tax`) WHERE 1 AND cp.`id_category` = 8 ORDER BY `position` ASC LIMIT 0,50 Link to comment Share on other sites More sharing options...
Recommended Posts