PDA

View Full Version : Syntax error for specials page



amandabuild
11-13-2005, 08:13 AM
I am a novice. When I click on the specials, I get an error message(1064 for '-10,10' at line 1). Can someone help me, I'm flailing!

soupy
11-15-2005, 12:44 AM
I too am getting similar errors all over the place.

For example:

Customers Search:

Last Name First Name Account Created Action
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 '-10, 10' at line 1

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by c.customers_lastname, c.customers_firstname limit -10, 10

amandabuild
11-15-2005, 06:04 AM
Recent updates may have caused your error. My webman contacted me offline and told me this- "It was an old code bug that only shows up on new versions of SQL " Sounds like the answer is somewhere on the forum. Hope this helps!