Guest Posted June 27, 2007 Share Posted June 27, 2007 Hi, I'm trying to set up different tax zones. I have defined a tax zone called "European Union" in the "Locations/taxes - Tax Zones", but when I want to insert a zone in my "European Union"-tax zone I push the "details" button and get this message: 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 = 5 order by association_id limit -20, 20 [TEP STOP] The weird thing is that the default Florida-tax zone is working smoothly. Can anyone please help me! / Rune Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.