SB Lite Posted December 4, 2013 Share Posted December 4, 2013 Getting the following error when saving. It seems to still save the product and the product is still on the website, however, the product then doesn't show up in a search..... Unknown column 'id_shop' in 'where clause'DELETE FROM `ps_layered_price_index` WHERE `id_product` = 33 AND `id_shop` = 1 Link to comment Share on other sites More sharing options...
SB Lite Posted December 4, 2013 Author Share Posted December 4, 2013 Also, categories are not working on the main page... http://www.sblite.co.uk/102-consumables Link to comment Share on other sites More sharing options...
vekia Posted December 4, 2013 Share Posted December 4, 2013 this problem started to appear without any reason? maybe you updated module? ps? Link to comment Share on other sites More sharing options...
tuk66 Posted December 5, 2013 Share Posted December 5, 2013 The ps_layered_price_index table comes with the "Layered navigation block" module. Probably you have an old version which doesn't support multi-shop. Link to comment Share on other sites More sharing options...
Recommended Posts