Customer search SQL error

[Guest]

Hi-

Our site was working fine so I don't know what happened. I am having a problem on the admin side of the site. When I try to search for a customer and they are not in our system I get this error:

 

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 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 where c.customers_lastname like '%snoddle%' or c.customers_firstname like '%snoddle%' or c.customers_email_address like '%snoddle%' order by c.customers_lastname, c.customers_firstname limit -20, 20

 

or when I find the name of the person and click on thier "orders" info I get this error:

 

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 o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.customers_id = '698' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -20, 20

 

 

Is there some update I missed or has somebody else had this problem and can hopefully help me out. I am still able to find orders by the order ID search, but I'd like this function to be working as well.

 

Thanks

Brian

[Guest]

I've got it figured out,

 

Decided to search for 1064 and found a thread with a patch by VGER and it worked!!! Thanks VGER