Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

MySQL 4/5 error


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'




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.



Link to comment
Share on other sites


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

  • Create New...