Skip to main content

Error on New Vendor - HikaMarket - Duplicate prd

More
11 years 6 months ago #192896 by acayer@colegal.ca
Error on New Vendor - HikaMarket - Duplicate prd was created by acayer@colegal.ca
-- 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.

More
11 years 6 months ago - 11 years 6 months ago #192922 by Jerome
Replied by Jerome on topic Error on New Vendor - HikaMarket - Duplicate prd
Hi,

Thanks for the report.
Please edit the file "plugins/hikamarket/duplicateproduct/duplicateproduct.php" and replace
Code:
$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).')';
By
Code:
$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: 11 years 6 months ago by Jerome.

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

More
11 years 6 months ago #193044 by acayer@colegal.ca
Replied by acayer@colegal.ca on topic Error on New Vendor - HikaMarket - Duplicate prd
Pas de problème, je vais faire pas mal de test prochainement, je vous ferai signe si je trouve autre chose

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

Moderators: Obsidev
Time to create page: 0.152 seconds
Powered by Kunena Forum