Guest Posted July 11, 2005 Share Posted July 11, 2005 Hello. Installed osCommerce the other day. Was a breeze using FTP access to my webserver. Started the configuration process and when I tried to change the zone and rate of Ohio (USA) - got this error: Tax Rates Priority Tax Class Zone Tax Rate 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 r.tax_rates_id, z.geo_zone_id, z.geo_zone_name, tc.tax_class_title, tc.tax_class_id, r.tax_priority, r.tax_rate, r.tax_description, r.date_added, r.last_modified from tax_class tc, tax_rates r left join geo_zones z on r.tax_zone_id = z.geo_zone_id where r.tax_class_id = tc.tax_class_id limit -20, 20 [TEP STOP] Any ideas on how to fix. Thanks. Link to comment Share on other sites More sharing options...
Guest Posted July 11, 2005 Share Posted July 11, 2005 Actually ... found the problem and the fix - Should have searched abit first. Answer is here: http://www.oscommerce.com/community/bugs,1605 Beware that the two files are different and need to scroll down to get the second fix. And a tip, make sure you upload (ftp) ASCII. I forgot the first time around and got a bunch of jibberish :) -Michael. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.