Error 1064 on products load

  • David Makovac
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
7 months 6 days 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
7 months 4 days 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.

  • Giang Dinh Truong
  • Giang Dinh Truong's Avatar
  • Offline
  • Administrator
  • Administrator
More
6 months 4 weeks ago #130357 by Giang Dinh Truong
Replied by Giang Dinh Truong on topic Error 1064 on products load
Deear David,

It's fine that you found the problem by yourself.

If you need any other helps, don't hesitate to let me know.

Sincerely, Giang

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

Moderators: Giang Dinh Truong