fabio.muniz01 Posted August 21, 2015 Share Posted August 21, 2015 In the back end i have set 11 products in home page and I can see them in BO but in the "MENS" category page in the front end the products are not displayed. Some one can help me with it? Link to comment Share on other sites More sharing options...
NemoPS Posted August 22, 2015 Share Posted August 22, 2015 Looks like there is some error, try enabling dev mode as my signature reads Link to comment Share on other sites More sharing options...
fabio.muniz01 Posted August 25, 2015 Author Share Posted August 25, 2015 Looks like there is some error, try enabling dev mode as my signature reads Hi nemo, I set PS_MODE_DEV to true, and i got this error. [PrestaShopDatabaseException]Unknown column 'product_attribute_shop.id_product' in 'on clause' 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, product_shop.`date_add` > "2012-11-27" 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` = 6 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` = 6 LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` JOIN ps_category_product cp ON (cp.id_product = p.id_product) JOIN ps_category_group cg ON (cg.id_category = cp.id_category) 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` > "2012-11-27") AND (cg.`id_group` = 1) GROUP BY product_shop.id_product ORDER BY p.`date_add` DESC LIMIT 8 How can i solve this problem? Link to comment Share on other sites More sharing options...
NemoPS Posted August 31, 2015 Share Posted August 31, 2015 Can you printscreen it? The broken file should be mentioned in the call stack below the error Link to comment Share on other sites More sharing options...
Recommended Posts