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

  • Posts: 567
  • Thank you received: 11
  • Hikashop Business
3 months 3 weeks ago #362441

-- 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

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

  • Posts: 26156
  • Thank you received: 4028
  • MODERATOR
3 months 3 weeks ago #362453

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.

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: 3 months 3 weeks ago by Jerome.

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

  • Posts: 567
  • Thank you received: 11
  • Hikashop Business
3 months 2 weeks ago #362459

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

Attachments:

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

  • Posts: 26156
  • Thank you received: 4028
  • MODERATOR
3 months 2 weeks ago #362468

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,

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.

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

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