Upgrading Question

[daybeauty]

Hi,

Out of curiosity, I've just try to restore sql database (from previous ver.) to newly installed Oscommerce (most current version). I'm hoping to upgrade to current version due to great new features. Database was restored without any problem but when I visited the site, it showed following error message:

1064 - You have an error in your SQL syntax near 'MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX' at line 1

select distinct op.products_id from orders o, orders_products op, products p where o.customers_id = '2' and o.orders_id = op.orders_id and op.products_id = p.products_id and p.products_status = '1' group by products_id order by o.date_purchased desc limit MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX

[TEP STOP]

Can anyone tell what above error message mean? Any advice would be really appreciated. Thank you.

[michael_s]

Most likely if this is from an older version, the database is not compatible with the new version. Run the upgrade option on the install script and it should update your database for you.

If after this it still gives you an error, time to look at syntax, mysql version and what you have to change in the data to make it work.

[daybeauty]

Thank you so much for the advice msasek
Could you tell me where&how to run the upgrade option on the install script? Thanks again.

[miko]

Navigate here:

http://localhost/catalog/install/install.php

And it is the 3rd option

Miko