Error In Tax class and tax rates

[Guest]

When I first set up our store I deleted the default tax rates and tax classes in the admin area as we where not charging any additional taxes. I now need to charge tax on taxable items but I am unable to create new rates and classes. When I go to the tax rates and tax class pages 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 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

 

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 tax_class_id, tax_class_title, tax_class_description, last_modified, date_added from tax_class order by tax_class_title limit -20, 20

 

Does anyone know what this means and how I go about fixing it?

[Guest]

Look ath this thread

http://www.oscommerce.com/forums/index.php?showtopic=298578

[Guest]

I have made these changes but I am still getting the same error. Any ideas?

 

Cheers

 

Lee

 

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