1064 SQL Syntax Error after saving a product

-- url of the page with the problem -- : 176.32.230.251/sewcharming.co.uk/
-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.28
-- Browser(s) name and version -- : Chrome 45.0.2454.85
-- 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 ')' at line 1 SQL=INSERT IGNORE INTO fpz1c_hikashop_product_category (category_id,product_id,ordering) VALUES (12,2,);

Hello, I have been trying to save a product but every time I do it creates this error:

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 ')' at line 1 SQL=INSERT IGNORE INTO fpz1c_hikashop_product_category (category_id,product_id,ordering) VALUES (12,2,);

I have only just installed Hikashop and I didn't get any errors upon installation. I created categories fine it was only when I began to create a product and save it the error displayed. I have tried a few times and still getting the same error.

Regards,
Karen

Thank you that worked. What would cause this issue from a fresh install. Or is it an error in the code that needs to be corrected?

I am suffering the same with HikaShop 2.6.1, also looked for the code and is already the replacing one as suggested in your solution.

this is the fool message:

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 '' at line 1 SQL=INSERT IGNORE INTO s3ni1_hikashop_product_category (category_id,product_id,ordering) VALUES ;

Thanks Nicolas, I will try this later in the day and also put the experimental site online so I can give you access if we should explore further.

Thanks for the clear explanations and the code suggestion.

regards

I tried this code tweak with not full success, just half.

I applied the changes to both sites the one exporting CSV and the one importing CSV,

Since then the problem is not reproducing if the exported data is of an already existing product in the Target Site.

But if I create a new product in Site A, then export, then import in site B this message persists.

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 '' at line 1 SQL=INSERT IGNORE INTO s3ni1_hikashop_product_category (category_id,product_id,ordering) VALUES ;

Big thank you Nicolas for attending this. I will test this early tomorrow and report to you.

but what it goes beyond my understanding is why my product don't have a defined type (product or variant'. Where and when should this happen.

If I create products from the HikaShop backend shouldn't they get the type assigned?

Hi Nicolas,

after your advise this is what i did:

Updated HikaShop to 2.6.1 latest version HikaShop Business 2.6.1 [1602031626] in both sites.

created a new product.
modified an existing product.

exported CSV. checked the CSV to make sure it contains the new product and the modified product. It does.

Imported with the mass action on my target site.

No error 1064 anymore. But no new product imported. modified product that was already existing in target site gets updated (changes were affecting product_name and product_code, so I understand the update has been made by matching the product_id).

Should some extra setting be defined to also accept new products?

Shouldn't the system update productsby matching product_code instead of product_id ? By now I am testing with cloned sites but in a real world I will update to sites where the same product only shares the product_code but not the product_id.


UPDATE:

Although probably not directly related later I installed the new massaction plugin released today by Xavier and replaced the classes/massaction.php file.

Tested with both modified products and new products again and the situation keeps exactly the same.

SECOND UPDATE:

I will be available most of the day for immediate testing any further code fix / improvement in the aim to make the import function add new products. I ignore if this situation is standard or specific to my sites. You have at your contact@ mailbox the access for both sites that was sent yesterday February 3rd at 8:44.

Thanks for the intensive implication you showed today in helping fixing these issues.

Hi Jerome,

the 1064 error was over after last Nicolas patch he asked me to install. But now the problem is that the import Mass action only updates products already existing by product_id, but is ignoring the import of new products.

According to a Mass Action filter they are all of the kind "main".