Getting 1064 - Sql Syntax Error

[sinryder]

hey guys when i try to delete customers account from admin .. i get this error below.

 

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

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_telephone, c.customers_dob, ci.customers_info_date_of_last_logon as last_logon, ci.customers_info_number_of_logons as num_logons, ci.customers_info_date_account_created as date_account_created, a.entry_city as city, a.entry_state as state_alt, z.zone_name as state, ctry.countries_iso_code_2 as country,c.customers_newsletter, 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 left join customers_info ci on c.customers_id = ci.customers_info_id left join countries ctry on a.entry_country_id = ctry.countries_id left join zones z on a.entry_zone_id = z.zone_id where c.customers_lastname like '%[email protected]%' or c.customers_firstname like '%[email protected]%' or c.customers_email_address like '%[email protected]%' order by c.customers_lastname ASC, c.customers_firstname ASC limit -30, 30

[PD_Steve]

Is it just this customer that is not deletable? or many. If its this customer, go into his/her account and try changing the email address to something like [email protected] and then try deleting. Let me know if that solves it

[Guest]

hey guys when i try to delete customers account from admin .. i get this error below.

 

the right syntax to use near '-30, 30' at line 1

 

upgrade your store to the latest osc version

http://www.oscommerce.com/solutions/downloads