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!
This is a discussion on Syntax error for specials page within the osCMax v2 Features Discussion forums, part of the osCmax v2.0 Forums category; I am a novice. When I click on the specials, I get an error message(1064 for '-10,10' at line 1). ...
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!
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
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!
Bookmarks