Error 1064 - Tax Rates

[Guest]

I am getting Error 1064 in Tax rates because I deleted that state Florida because I couldn't seem to get rid of it no matter how many times I selected a new State. I even reloaded the 2 tax pages to overwrite the goof.

 

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

 

I found many 1064 Errors in the Bug section but, none for taxes Rates.

 

Where do I go to find this information.

 

Thanks again.

[Ausgirl]

Update should fix it.

 

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

 

Solution:

 

Line 67 in catalog/includes/classes/split_page_results.php

 

must be changed from:

 

$this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page;

 

to:

 

$this->sql_query .= " limit " .

max($offset, 0) . ", " . $this->number_of_rows_per_page;

 

Line 38 in catalog/admin/includes/classes/split_page_results.php

 

must be changed from:

 

$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

 

to:

 

$sql_query .= " limit " . max($offset, 0) . ", " .

$max_rows_per_page;

[Guest]

Hi and thanks for the reply.

 

Upon trying out my site with a few products I found another error we (the Forum) had solved yesterday and it occured in the Manufactures category.

 

This Bug solution took care of the Tax Rate issue and the Manufacturer issue as well today.

 

http://www.oscommerce.com/community/bugs,3...ror+1064/page,2

 

So many different Error 1064.

 

Best thing to do is not delete all the items and Tax Rates, etc, just change them or else you will get these parsed errors.

 

G'day!