Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

problem viewing products


Recommended Posts

a friend asked me to look at their site and there is an error message when trying to view products in the store

the admin panel is flaky too, i can log in and see all the menus but it times out when i try to go to one.

this is the error message:


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





any help is much appreciated

Link to comment
Share on other sites

Looks like the erro message you get when running a site that uses mysql 4 syntax on a site using a server with mysql5 installed on it.


Seee the link in my sig block for all the mysql5 patches.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile


Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.


For links mentioned in old answers that are no longer here follow this link Useful Threads.


If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites


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

  • Create New...