Upgrade from V1.22

[Guest]

Hi. My sister's store was set up using osCommerce V1.22. The hosting site has recently upgraded to PHP 5.x and MySQL 5.x.

 

As a result of their upgrade errors are now showing up, such as "1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '24'" when a product category is selected.

 

It appears to me that we need up upgrade our osCommerce software to V2.3.1. Is that correct and does anyone have any ideas on any other fix?

 

Can I run the install programme with the old one still in place or is it recommended to delete the old one first?

 

Would an install with the old one still in place copy the settings that we already have or would we have to start from stratch?

 

Thanks in advance,

 

Brian

 

PS Please bear in mind that we are not to clever on this sort of thing!!

[Guest]

Brian,

 

 

There was NO osCommerce v1.22, however if the site is old and no longer compatible with updated server software, it may be time to update to v2.3.1 which has a stronger framework and enhanced security.

 

If you are going to install v2.3.1, you can put it into a sub-directory on your server and configure it before making it active with your domain name.

 

 

 

 

Chris

[Guest]

Hi Chris. Thanks for that. I will see what I can manage tomorrow. I expect that I will be back on this forum for more help ;-)

 

The copyright date seems to be 2003.

 

Brian

[Guest]

Brian,

 

 

For a definitive version, open /includes/application_top.php around line 36.

 

 

 

 

Chris