Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Categories Error


Plastic

Recommended Posts

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.

Link to comment
Share on other sites

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

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...