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,

Can you please provide a screenshot of your data just before saving it ?

Regards,

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,

Same as previous ; please provide the context to help us to understand what you are doing exactly and to be able to reproduce it.

Regards,

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,

I am not able to reproduce the issue in my local website or in the demo website.
So we will need an admin access to your website in order to perform some tests, check your HikaShop/HikaMarket configuration and activate temporally the debug mode while reproducing the issue in your website.
For such private information the best is to use our "contact us" form, with a link to that forum thread (so the support team will assign me the ticket).

Regards,

Hi,

Thanks for the accesses.
I installed you the latest package of HikaMarket which solved the issue.

Regards,

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

Hi,

I changed temporally the setting "Limit vendors in cart" from "One vendor" into "One extra vendor" in order to avoid the issue.
I'll perform more tests on my local website in order to reproduce the issue and create the appropriate fix.

Regards,