You have an error in your SQL syntax

[hostyork]

Have got 2 issues with errors when in admin on OSC.

I'm running an old version and not the ms2.2.

 

First one is on the special 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

 

I just get this at the top of the admin page and cannot enter any fields for

special offers.

 

The second one is very similar and is on the Products Expected.

 

Any ideas? I've done a search on the forums but to no avail.

 

Talking of upgrading? How easy is it to just take all my data and plonk it in a new installation. Or would I need to manually hack around to do an update?

 

Cheers and many thanks in advance!

 

Andrew