Syntax error for specials page

[amandabuild]

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]

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]

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!