Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database problems


Guest

Recommended Posts

Posted

Hi, hope someone can help me with thisproblem.

 

When a user clicks on a category within my cart, or tries to search for something the following error is displayed:

 

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

 

[TEP STOP]

Any ideas?, is it an osc problem or my hosting

 

Thanks

Kevin

Posted
Hi, hope someone can help me with thisproblem.

 

When a user clicks on a category within my cart, or tries to search for something the following error is displayed:

 

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

 

[TEP STOP]

Any ideas?, is it an osc problem or my hosting

 

Thanks

Kevin

 

 

Ok what is your Web Address?

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Posted
its probably the mysql 5x issue with the older osc code. You could get the latest upgrade

http://www.oscommerce.com/solutions/downloads

and modify the sql queries. It should fix the problem.

 

 

Thanks for your advice, but.........

How do I modify the queries and which queries do I modify?

Posted

you mean you just d/l the latest update and it doesn't say anything in the instructions?

Posted
Thanks for your advice, but.........

How do I modify the queries and which queries do I modify?

 

No not d/l yet, just pre-empting any problems!!!!!

Posted

well they're a bunch of changes, it's not a simple one. But it states what files to change and how to locate the code in each file.

Archived

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

×
×
  • Create New...