Sorry: can't figure out how to update (1054-error)

[jwitzsch]

Hi

 

I have not worked with OSCOMMERCE for a long time. Forgot almost everything about the configuration and installation and what changes I made to the files back then - the shop I created for a friend is partly modified (special terms/translations/checkout). Version is Preview Release 2.2 CVS (says so in the bottom line of the admin section)

Since a while, he is getting the following error (plus no display of individual products - categories are displayed)

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select p.products_id, pd.products_name, p.products_image, IFNULL(s.specials_new_products_price,p.products_price) as products_price from products p, products_description pd left join specials s on p.products_id = s.products_id where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' order by p.products_date_added DESC, pd.products_name limit 12

TEP STOP

 

I guess, this might be due to an upgrade of PhP or other server-software: Database: MySQL 5.0.27-standard

HTTP Server: Apache PHP Version: 4.4.4 (Zend: 1.3.0)

 

I searched the forum for the 1054 error and found some references, but I just don't understand, how I can make an update at all. Sorry for not getting it, but could someone please walk me through? Or point me to an easy to understand "how to"?

The problem is, that I do not want to loose any of the special changes I made in the shop nor do I want to loose any data in the database (shop).

 

Any help is much appreciated!

Thanks

Joerg