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,

What kind of characteristic (and value) are you trying to add ?
The query error means that you're adding invalid data because the characteristic you add should be listed in the "CONCAT", just after the coma.

Regards,

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

Hi,

Thanks for your feedback.
I'll see to improve the class with more checks on the content ; so we will avoid the SQL errors and display a simple message instead.

Happy new year too !

Regards,