beemergrape Posted January 19, 2005 Posted January 19, 2005 I can insert a tax zone, however when I click on the tax zone I added I get this 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 Why is limit -20, 20 showing up like this? It should be limit 20, 20. And then the query would run just fine. Is this a bug? I am running the latest OsCommerce version and MySQL version 4.1.7 TIA Beemergrape
Rob123 Posted January 19, 2005 Posted January 19, 2005 This looks like your problem... http://www.oscommerce.com/community/bugs,1605 Robert
beemergrape Posted January 20, 2005 Author Posted January 20, 2005 THATS IT!!! PROBLEM FIXED. THANK YOU
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.