Tax Zone Error

[joe069]

Hi, our store is based in Canada and we now need to start charging GST. So I have gone back to take a look at the Tax Zones that I had setup and am getting the following error when I click on the folder icon for the tax zones that I already have setup.

 

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]

 

 

Let me know if you need more info or if you want me to post some code.

 

Joe

[joe069]

anyone?

[joe069]

nevermind, i figured it out

 

I found this file and it had the answer in it under

limit -20, 20

http://www.oscommerce.com/community/bugs,1605

 

 

http://www.oscommerce.com/ext/update-20060817.txt

 

Joe