Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL 4/5 error


scanyman

Recommended Posts

Hi, I am getting this error when selecting categories,

 

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

 

[TEP STOP]

 

If I understang the postings I have read about this error it would appear to be a MySQL 5 thing that wasnt in version 4. I understand the need to ammend the code but cant find it.

 

I have looked in /catalog/index.php and some others.

 

Can someone point me in the right direction please.

 

Thanks.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...