Tax Zone Error

[will32]

Hi,

 

I have just installed os commerce and when i go to add or del a tax zone i get this error:

 

Tax Zones

 

Tax Zones 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 geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added from geo_zones order by geo_zone_name limit -20, 20

 

 

I have re-installed error still occurs.

Os Commerce version (2.2 MS2)

 

Any ideas.

[Guest]

I have the same problem, but this occured after I suggested to myself it would be a good idea to delete the "Florida Tax Zone". Not sure it does anything to the functionality though, but may shed light on this issue to some people with more insight into this php/mysql thingy.