LindaAtl Posted April 18, 2005 Share Posted April 18, 2005 After installing Quantity Controller v5.0, patches and additional files - and after making the required changes to MySQL - products table structure and products attributes table structure, I now get the following error when entering the Customers section of Admin: 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 order by c.customers_lastname, c.customers_firstname limit -20, 20 [TEP STOP] All help is greatly appreciated! Linda Link to comment Share on other sites More sharing options...
Jan Zonjee Posted April 18, 2005 Share Posted April 18, 2005 It has nothing to do with the contribution you added and everything with the -20'. There is a bug report and a fix concerning it. Link to comment Share on other sites More sharing options...
LindaAtl Posted April 18, 2005 Author Share Posted April 18, 2005 I haven't run into that before. I'll make the repair. Thanks for your help! It has nothing to do with the contribution you added and everything with the -20'. There is a bug report and a fix concerning it. <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.