Tax Zone & Reportdatabase problem

[Jayson Wonder]

I deleted the demo tax zone in order to create a new one and when I went back to add it I get this error:

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 geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added from geo_zones order by geo_zone_name limit -20, 20

 

When go to reports / best products purchased I get this error also:

No. Products Purchased

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 p.products_id, p.products_ordered, pd.products_name from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '1' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name limit -20, 20

 

I think it is becasue the database feilds are empty but I am not sure. Can anyone give any advice , I am not so good with mysql. How can this be fixed?

 

Thanks

[Guest]

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

fix at the end of the page.

[Jayson Wonder]

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

fix at the end of the page.

 

Thanks