1064 You have an error in your SQL syntax;

-- HikaShop version -- : 2.5.0
-- HikaMarket version -- : 1.6.5
-- Joomla version -- : 3.4.3
-- PHP version -- : 5.6.2
-- 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 ') AND characteristic_vendor_id = 2' at line 1 SQL=SELECT * FROM vcdsq_hikashop_characteristic WHERE characteristic_parent_id = 56 AND characteristic_id IN () AND characteristic_vendor_id = 2

Hi,

I get an error when I want to save the main characteristic of variants (please see attachment). By adding a new main or add more variants I have no problems and it works. For last I use the save button which displays when I select the button "+add variant".

Can you help me?

THX

Hi,

I solved the problem on this part, but now I have the problem when I want to save a product which have variants. Please see attachment for error report

Sorry. one more information. I have this problem only in the front-end

Hi,

I make some screenshoots. On 1 you see the listing.php from the vendor dashboard. The product have some variants. When I would save the product (with and without editing something) I get the error you can see on attachment 3. Further the products with variants can´t be add to the cart in the shop. Here I get the Message that the product from the vendor can´t add to the cart (see attachment 4).
I have both problems only by products with variants.

I hope you can work with this...

thanks for your help

Hi Jerome,

now the issue by saving a product is solved.. Thanks for that. But the issue when I try to add to the cart is still there.

Can you take a look again?

THX