product error Unknown column 'b.watch_size_screen'

  • Posts: 120
  • Thank you received: 2
9 years 4 months ago #240162

-- HikaShop version -- : 2.6.x
-- Joomla version -- : 3.5.1

Hi Dear
when I created new product I have this error

Unknown column 'b.watch_size_screen' in 'where clause' SQL=SELECT DISTINCT b.* FROM #__hikashop_product_category AS a LEFT JOIN #__hikashop_product AS b ON a.product_id=b.product_id WHERE a.category_id IN (12,13,14,16,17,45,46,67,66,26,75,29,68,56,55,47,54,60,50,51,52,53,57,58,61,62,64,71,72,76,77,78,80,82,83,84,85,112,116,117,125,2) AND (b.product_name LIKE '%avg test%' OR b.product_description LIKE '%avg test%' OR b.product_id LIKE '%avg test%' OR b.product_code LIKE '%avg test%' OR b.watch_size_screen LIKE '%avg test%' OR b.scaner_scanner_voltage LIKE '%avg test%' OR b.scaner_scanner_size_negative LIKE '%avg test%' OR b.scaner_scanner_scan_slides LIKE '%avg test%') AND b.product_type = 'main' ORDER BY a.ordering asc LIMIT 0, 20

how can fix this error?
thank you

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

  • Posts: 84312
  • Thank you received: 13701
  • MODERATOR
9 years 4 months ago #240166

Hi,

There is no such column in HikaShop. So I suppose that you must have added it as a custom field, but then migrated the website without using the tables from the original website or something like that, and thus there is a missing column for the custom field.
You can try to click on the "check database" button of the HikaShop configuration page to add missing custom field columns to your database.
You can also add it manually in the hikashop_product table via your PHPMyAdmin.

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

Time to create page: 0.054 seconds
Powered by Kunena Forum