Tax Rates

[mypsgift]

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 '-4, 4' 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 -4, 4

 

Anyone Know how to solve this problem?

Thanks for helping!

I am newbie to os system.

[Guest]

you should upgrade your store with latest osc version from the downloads section. The particular bug/solution is also explained here

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

[mypsgift]

I think it is different from what the problem i encounter:

 

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 '-4, 4' 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 -4, 4

 

 

 

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

 

in admin/stats_customers and product_expected

 

 

 

 

(OS: FreeBSD 4.9-STABLE; MySQL 4.1.1-alpha; Apache/1.3.29 (Unix) mod_perl/1.28 PHP/4.3.4)

[Guest]

I think it is different from what the problem i encounter:

 

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 '-4, 4' 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 -4, 4

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

 

in admin/stats_customers and product_expected

(OS: FreeBSD 4.9-STABLE; MySQL 4.1.1-alpha; Apache/1.3.29 (Unix) mod_perl/1.28 PHP/4.3.4)

So just to confirm.... you've implemented the fix from the bug report and you still see the problem right?

 

or you haven't done anything.