Skip to main content

Sql error in menu for product listing

More
12 years 2 weeks ago #172137 by cms4biz
-- url of the page with the problem -- : www.raddtp.nl/anatomie/index.php?option=...t=listing&Itemid=184
-- HikaShop version -- : 2.3.2
-- Joomla version -- : 3.3.3
-- PHP version -- : 5.3.29
-- Browser(s) name and version -- : FF 31
-- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column 'b.lichaamssysteem' in 'field list' SQL=SELECT DISTINCT b.product_id,b.onderwerp, b.leeftijdsfase, b.lichaamssysteem, pprice.price_value FROM anat_hikashop_product_category AS a LEFT JOIN anat_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN anat_hikashop_price AS pprice ON b.product_id=pprice.price_product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (30) AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY a.ordering ASC

I have a many menuitem for a productlisting.
I have delete and add custom fields for products after the menuitems are created.
How can we solve this problem.

Please Log in or Create an account to join the conversation.

More
12 years 2 weeks ago #172141 by nicolas
Hi,

Create these columns in the hikashop_product table via your phpmyadmin and the error will disappear.

Please Log in or Create an account to join the conversation.

Time to create page: 0.133 seconds
Powered by Kunena Forum