1064 mysql error when managing characteristics

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.28
-- Browser(s) name and version -- : Mozilla Firefox 34.0
-- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS c_product_code, p.product_id, 1419965081, 1419965081, 0, 0, product_name, p' at line 1 SQL=INSERT IGNORE INTO eb35v_hikashop_product (product_code, product_parent_id, product_created, product_modified, product_hit, product_last_seen_date, product_name, product_description, product_quantity, product_published, product_sale_start, product_sale_end, product_delay_id, product_tax_id, product_type, product_vendor_id, product_manufacturer_id, product_url, product_weight, product_keywords, product_weight_unit, product_meta_description, product_dimension_unit, product_width, product_length, product_height, product_max_per_order, product_access, product_group_after_purchase, product_min_per_order, product_contact, product_display_quantity_field, product_sales, product_waitlist, product_layout, product_average_score, product_total_vote, product_page_title, product_alias, product_price_percentage, product_msrp, product_canonical, product_warehouse_id, product_quantity_layout, videolink) SELECT CONCAT(p.product_code, '_', ) AS c_product_code, p.product_id, 1419965081, 1419965081, 0, 0, product_name, product_description, product_quantity, product_published, product_sale_start, product_sale_end, product_delay_id, product_tax_id, product_type, product_vendor_id, product_manufacturer_id, product_url, product_weight, product_keywords, product_weight_unit, product_meta_description, product_dimension_unit, product_width, product_length, product_height, product_max_per_order, product_access, product_group_after_purchase, product_min_per_order, product_contact, product_display_quantity_field, product_sales, product_waitlist, product_layout, product_average_score, product_total_vote, product_page_title, product_alias, product_price_percentage, product_msrp, product_canonical, product_warehouse_id, product_quantity_layout, videolink FROM eb35v_hikashop_product AS p, WHERE p.product_id IN (19555,19556,19557,19554,19550,19551,19552,19553,19548,19549,19545,19546,19547,19543,19544,19540,19541,19542,19535,19536,19537,19538,19539,19533,19534) AND ()

Hi all,

When adding a characteristic to the product and try to save I get error message as described.

Please help.

Thanks,
Dushan

Hi Jerome,

Thank you for your help, I was adding some bogus characteristic just to see how this thing work.

I added the right one and everything works fine.

Thanks and I wish you a happy New year!

Dushan