sql error 1064

[davegug]

Hi all. I recently installed osCommerce 2.2 on my powweb site with success but am getting an sql 1064 error when clicking on the link to edit the tax zones and tax rates off of the admin console. Error reads as the following

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 r.tax_rates_id, z.geo_zone_id, z.geo_zone_name, tc.tax_class_title, tc.tax_class_id, r.tax_priority, r.tax_rate, r.tax_description, r.date_added, r.last_modified from tax_class tc, tax_rates r left join geo_zones z on r.tax_zone_id = z.geo_zone_id where r.tax_class_id = tc.tax_class_id limit -20, 20

:confused:

Anyone with any insight on how to fix this would be much appreciated.

[mitchind]

You'll find the solution for this in the osCommerce forum.

You'll have to modify some php code to change the -20,20 to 0,20

If I remember right it's in more than one place too..

Do a search on the oSCommerce forum using "limit" as a keyword