Syntax error

[Aunt Clara]

I am getting the following error in the admin site when I try to enter the Specials page:

 

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, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20

[TEP STOP]

 

I would also like to know how I can edit the country list to only include those countries where I ship to.

 

Another thing is that I would like to ship to 3 zones: EU, US and Canada. Each will have its own flat rate. How do I go about it, the only zone available in the installation package is the United States.

[♥Vger]

In the old version of osCommerce there was a bug which meant that if you deleted all default 'Specials', Products or Categories then you got the 1064 error.

 

However the updated version was issued November 2005, and it is this version you need to download from www.oscommerce.com and use. It also contains other bug fixes and essential security updates.

 

Vger

[Aunt Clara]

How do I install the new version without affecting the design and content of my site? Sorry if that is an stupid question.