Please Assist, Database Erors with the Tax Rate Table

[loghova]

Tax Rates  

Priority Tax Class Zone Tax Rate Action  
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

 

I first recieved this error when I deleted the existing row out of the Tax Rates in the admin panel leaving nothing in the database. Is this possibly the problem? If I run an insert query on this database and insert a row will this resolve this issue?

 

Any assistance would be appreciated.

[loghova]

Does anyone have any suggestions? This happens when I click Tax Rates in the admin panel.

[loghova]

Would someone please give me the values of one of their rows in the tax rates table.

 

tax_rates_id, tax_zone_id, tax_class_id, tax_priority, tax_description, last_modified, date_added datetime

 

This would help me out so much. Thanks.

 

Mike

[loghova]

Figured this out on my own.

[Dec]

Hello,

 

How did you fix this?

 

Thanks