Search not working for Hikaship

  • Posts: 147
  • Thank you received: 6
3 years 11 months ago #327406

-- url of the page with the problem -- : community.advancn.org/books
-- HikaShop version -- : 4.4.0
-- Joomla version -- : 3.9.23
-- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) GROUP BY (a.product_id) ORDER BY a.product_name DESC LIMIT 0, 50' at line 1

I am attempting to use the joomla search module for product and have received the following error:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) GROUP BY (a.product_id) ORDER BY a.product_name DESC LIMIT 0, 50' at line 1

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
3 years 11 months ago #327407

Hi,

Please:
- do the modification here: www.hikashop.com/support/forum/install-u...ror-1064.html#326783
- turn on the "error reporting" and "debug mode" settings of the Joomla configuration
- try again and provide a screenshot of all the information about the error on the page. You should get the full MySQL query creating the error and a call stack which will help us understand what is going on.

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

  • Posts: 147
  • Thank you received: 6
3 years 11 months ago #327425

I have set debug mode.
Images and video: vimeo.com/491199525

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
3 years 11 months ago #327428

Hi,

It seems that you didn't do the modification in the file as I proposed in my previous message.
Could you do the modification in www.hikashop.com/support/forum/install-u...ror-1064.html#326783 ?
That way, the error message will contain the full MySQL query, which will help understand what's going on.

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

  • Posts: 147
  • Thank you received: 6
3 years 11 months ago #327440

Thank you, its working fine now.

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

Time to create page: 0.050 seconds
Powered by Kunena Forum