Categories Error

[Plastic]

I just moved my database files (OSmax-2) to a new server. I backed everything up first, then uploaded the database files. The congig.php file shows the correct information. The shopping cart is working fine on the new server except for one thing. When a user clicks on any of the "Category Items" an error comes up as follows:

 

"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 = '7'"

 

Does anyone know what that means and how I can fix it?

 

If you want to look at the actual page please go to:

http://www.cookbookcountry.com/catalog2/index.php?cPath=1

 

As a side note: All the other functions, images, order tracking, etc work fine. If a user clicks on any of the images for a product(such as in the sidebars) they are taken to the product listing and it looks just fine.

[satish]

This a bug due to Mysql version 5 and higher.

 

You need to look into oscommerce download section on what all queries needs to be changed.

 

 

Regards,

Satish

[Plastic]

This a bug due to Mysql version 5 and higher.

 

You need to look into oscommerce download section on what all queries needs to be changed.

Regards,

Satish

 

Satish, I appreciate your input. Yes, I am using MSQL 5 now and it was on a server with MYSQL 4. But, I can't seem to find the download area you are talking about. The only download I can find on this site is the new release download. Can you please point me to the right place?

[satish]

oscommerce-2.2ms2-051113 doanload this.

then in that You will find an update-20051113 that has some modification instruction.All db related instructions needs to eb followed.

 

Satish

[Plastic]

oscommerce-2.2ms2-051113 doanload this.

then in that You will find an update-20051113 that has some modification instruction.All db related instructions needs to eb followed.

 

Satish

 

Thank you. I was able to find the code to change for MYSQL 5. I appreciate your help.