Find content
Not Telling
Hi,
I have just installed an existing website on a local server which I used to run a few years ago.
I am receiving the following error when trying to access any one of the "specials", "manufacturers", "reviews" or "products expected" in the admin area.The only thing which I can think of that has changed is the MySQL and PHP versions but after applying some fixes everything other than these pages seems to work.
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 '-6, 6' 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 -6, 6
[TEP STOP]
Unfortunately it has been 5 years since I last used osCommerce and am stuck with how to proceed.
Any tips would be genuinely appreciated.
Peter.
Latest News: (loading..)
