Error on New Vendor - HikaMarket - Duplicate prd

Start
Prev
1
Next
End

acayer@colegal.ca
Topic Author
Offline

Posts: 12
Thank you received: 0

9 years 1 month ago #192896

-- HikaShop version -- : 2.3.5
-- HikaMarket version -- : 1.6.0
-- Joomla version -- : 3.3
-- Error-message(debug-mod must be tuned on) -- : An error has occurred.
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 '13)' at line 1 SQL=SELECT pc.product_id FROM hb5v2_hikashop_product_category AS pc INNER JOIN hb5v2_hikashop_product AS p ON pc.product_id = p.product_id WHERE p.product_vendor_id = 0 AND pc.category_id IN 13)

Hi Guys,

Just posted the error message. Apparently there is an error in the SQL.

Please Log in or Create an account to join the conversation.

Jerome
Away
HikaShop core developer

Posts: 26008
Thank you received: 4004
MODERATOR

9 years 1 month ago #192922

Hi,

Thanks for the report.
Please edit the file "plugins/hikamarket/duplicateproduct/duplicateproduct.php" and replace

$query = 'SELECT pc.product_id FROM ' . hikamarket::table('shop.product_category') . ' AS pc '.
	' INNER JOIN ' . hikamarket::table('shop.product') . ' AS p ON pc.product_id = p.product_id '.
	' WHERE p.product_vendor_id = 0 AND pc.category_id IN '. implode(',', $categories_id).')';

$query = 'SELECT pc.product_id FROM ' . hikamarket::table('shop.product_category') . ' AS pc '.
	' INNER JOIN ' . hikamarket::table('shop.product') . ' AS p ON pc.product_id = p.product_id '.
	' WHERE p.product_vendor_id = 0 AND pc.category_id IN ('. implode(',', $categories_id).')';

It will fix the SQL issue.
We will integrate this patch in the next release.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Last edit: 9 years 1 month ago by Jerome.

Please Log in or Create an account to join the conversation.