TAX ZONES SQL Failure

[rgvsean]

HI, first of all hello to everybody and sorry if I should have found the answer somewhere obvious. o:)

 

I am trying to set up a OS shop and having a bit of a play.

 

I have set up 2 tax zones:

 

EC at 17.5%

And

REST OF WORLD at 0%

 

However when I clcik the DETAILS button for each of these I get the following message:

 

Tax Zones

 

Country Zone 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 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 = 2 order by association_id limit -20, 20

 

[TEP STOP]

 

I don't really know what the question I need to ask is so any advice appreciated!

 

cheers

Sean :thumbsup:

[Jan Zonjee]

I don't really know what the question I need to ask is so any advice appreciated!

For a description and a solution see this entry in Christian Lescuyer's blog.

[rgvsean]

Many Thanks