Tax Zone Setup

[dkeogh]

Hi I am just setting up my first install of oscommerce and am following the doc on setting up a new tax zone but when i click the "details" button i get the following error:

 

Tax Zones

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 a.association_id, a.zone_country_id, c.countries_name, a.zone_id, a.geo_zone_id, a.last_modified, a.date_added, z.zone_name from zones_to_geo_zones a left join countries c on a.zone_country_id = c.countries_id left join zones z on a.zone_id = z.zone_id where a.geo_zone_id = 4 order by association_id limit -20, 20

 

[TEP STOP]

 

 

This does not occur when i click on "details" for the default florida tax zone which was already setup.

 

Thanks for your time.

[Guest]

I've encountered this error before, the solution for you is at: http://www.oscommerce.com/community/bugs,1...2B%28General%29