Sql error in menu for product listing

  • Posts: 14
  • Thank you received: 0
11 years 3 days ago #172137

-- 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.

  • Posts: 84318
  • Thank you received: 13706
  • MODERATOR
11 years 3 days ago #172141

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.059 seconds
Powered by Kunena Forum