Error 1064 after saving a characteristic

-- 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, 1422022486, 1422022486, 0, 0, product_name, p' at line 1 SQL=INSERT IGNORE INTO rwos3_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, screensize, os, bluetooth, ram, public, genre) SELECT CONCAT(p.product_code, '_', ) AS c_product_code, p.product_id, 1422022486, 1422022486, 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, screensize, os, bluetooth, ram, public, genre FROM rwos3_hikashop_product AS p, WHERE p.product_id IN (383,388,382,389,390,391) AND ()

Hi,

Hope you can assist.
I've been adding characteristics to my Hikashop products with no problem however after adding and saving a new characteristic I received the above error message (1064).

Now on the front end product page I have a rogue "Select an Option" box in my characteristics field (Currently under the SSD option). Would you be able to assist me with removing this? This is only resident on this particular product page that i've noticed, maybe a bug? is there a way to remove?

Let me k now if you need any further info.
Many thanks in advance,
Jason

I get the same error when I made a new custom field, open an existing product, enter a value and save the product. I use version 2.4.0 business edition (downloaded yesterday).

This is the error upon save: '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 'WHERE p.product_id IN (8,9,10,11)' at line 1 SQL=INSERT IGNORE INTO rdjla_hikashop_product '

When I open the product again, enter a value and save it again, the error is gone.

I uploaded the product.php file you provided here as a download, but now the backend of the custom fields is messed up. Please help.

I reinstalled the business edition, so the backend is o.k. again. But the error comes back every time I save a product.

Configuration details: Hikashop Business 2.4.0, Joomla 3.3.1, PHP 5.3.28, MySQL 5.5.39
I've set error reporting on maximum.
Tried to recreate the problem by adding a new custom field and use it in an existing product, and now the product saves correctly.
Bizarre ????