Facing error when login vendor account and go to product listing page

-- url of the page with the problem -- : bookshop.school2u.my/booklist?limitstart...&filter_SetType_12=+
-- HikaShop version -- : 4.5.1
-- HikaMarket version -- : 4.1.0
-- Joomla version -- : 3.9.21
-- PHP version -- : 7.4
-- Error-message(debug-mod must be tuned on) -- : 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 ((hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published =' at line 1

When login certain vendor account

visiting product list page as per mentioned

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 ((hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published =' at line 1

will hit above error?

any clue which source code to check or optmized for this issue?

only happen on certain vendor account, suspect naming or setting of vendor causing this

Hello,

Please enable temporally the "debug mode" in the Joomla Global configuration in order to have more details regarding the error (mostly the details of the "call stack" to know in which file the issue is)

Regards,

PS : Please note that you're using HikaMarket 4.1.0 and the latest version (4.1.1) might contain the corresponding fix.

Thanks for following up the issue

attached the debug we found that causing the error

there is an empty part in the query?

could you advise this query script location/path? or advise the method to fix this query

upgrade cant be done as there is lot of layout and customization changes conducted

Hello,

Regarding the SQL query and how HikaMarket interact with HikaShop during that trigger, there is nothing which indicates a bug in HikaMarket.
And since the error is coming from a query after a HikaShop plugin trigger, the callstack won't give you any useful information ; the plugins have been already called and the $filters variable contains an empty entry.

I understand that I think that HikaMarket is the cause of the issue ; but if you do unpublish the "hikashop / market" plugin, the issue should still be there.

Regards,