Not able to add Zones or Tax Zones - SQL Error Please Help

[newbie30]

Hi,

 

I am getting the following error when I try to access the following through the osCommerce Adminisitration (Location/Taxes - Zones and Tax Zones):

 

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 '-8, 8' at line 1

 

select z.zone_id, c.countries_id, c.countries_name, z.zone_name, z.zone_code, z.zone_country_id from zones z, countries c where z.zone_country_id = c.countries_id order by c.countries_name, z.zone_name limit -8, 8

 

[TEP STOP]

 

Please help.

 

Thank you.

 

Mel :) (PS> I am very new to this, please explain in detail, many thanks )

[Guest]

looks like you have an older version of the osc. Try to upgrade your store.

http://www.oscommerce.com/solutions/downloads

it includes the particular fix. The manual instructions explain the code changes.

 

Backup your files and database before modifying anything.