Error 1064 on products load

  • David Makovac
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
5 days 19 hours ago #130107 by David Makovac
Error 1064 on products load was created by David Makovac
Hi!
Whenever the model tries to load some products from the DB (Front Page, by category etc.), I get the following error.

Oops ! 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 ')) WHERE a.published = 1 AND b.language='hr-HR' AND ((a.product_customergroups =' at line 4

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

  • David Makovac
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
3 days 15 hours ago #130203 by David Makovac
Replied by David Makovac on topic Error 1064 on products load
I found the solution.

I set the sorting methods on Bestsellers, even if I did not have any order yet.

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

Moderators: Giang Dinh Truong