OS Property support center

1064 SQL ERROR

  • Maria L
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
11 years 5 months ago #43558 by Maria L
1064 SQL ERROR was created by Maria L
Hi,

I installed the new slideshow module on my new template and I get the following error. Can any one help please? I just changed my template so could this be the problem?

1064 - 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 c.state > 0 ORDER BY c.title ASC LIMIT 0, 5' at line 3 SQL=SELECT c.id FROM h1xym_content AS c WHERE c.catid IN() AND c.state > 0 ORDER BY c.title ASC LIMIT 0, 5

Thank you
M

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

More
11 years 5 months ago #43564 by Dang Thuc Dam
Replied by Dang Thuc Dam on topic 1064 SQL ERROR
Hi,
What's the slideshow that you installed? On OSPT3 template? do you need us to configure the template for you?
Thanks
Dam

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

  • Maria L
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
11 years 5 months ago #43573 by Maria L
Replied by Maria L on topic 1064 SQL ERROR
Hi Dam,

Yes it the new one on OSPT3, it worked to start with but when I was configuring it i got the error.

Can you please configure it for me, I dont want to install sample data as it is a live testing site.

Thank you
M

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

More
11 years 5 months ago #43575 by Dang Thuc Dam
Replied by Dang Thuc Dam on topic 1064 SQL ERROR
Hi,
On tomorrow, my guy will help you to configure the template.
Thanks
Dam
The following user(s) said Thank You: Maria L

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

Moderators: Dang Thuc DamNguyen Phu Quan