Jump to content
Sign in to follow this  
wizzie

1064 - You have an error in your SQL syntax

Recommended Posts

Hi guys

Just installed and went well until I went into it to test and all I get is this

 

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 '-20, 20' at line 1

 

select * from customer_testimonials order by testimonials_id limit -20, 20

 

[TEP STOP]

 

Any ideas?

 

Many Thanks

Share this post


Link to post
Share on other sites
Just installed and went well until I went into it to test and all I get is this

 

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 '-20, 20' at line 1

Apparently, you didn't install the/updated to November 13 update of osCommerce MS 2. That (MySQL) issue has been dealt with in that update (offset should not be negative, so it should be limit 0, 20).

Share this post


Link to post
Share on other sites
Apparently, you didn't install the/updated to November 13 update of osCommerce MS 2. That (MySQL) issue has been dealt with in that update (offset should not be negative, so it should be limit 0, 20).

 

 

Hi Im getting the same database error when trying to run customer_testimonials is there a way to go around that?? My store is havely costomised I cant reupload every file Please help If you know of any solution. to fix the syntx problem....

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×