xtreme-mobile Posted May 1, 2008 Posted May 1, 2008 hey guys ive been having problems with going through the catelog menus and then getting the products page. It always shows the following error: 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 = '4' [TEP STOP] even on a fresh install with no mods it does this,any ideas? Visit my website in my profile for prices on woodburning stoves
xtreme-mobile Posted May 2, 2008 Author Posted May 2, 2008 anyone? Visit my website in my profile for prices on woodburning stoves
♥geoffreywalton Posted May 2, 2008 Posted May 2, 2008 Are you running on version 5 of mySQL. The link below for solutions to loads of problems has the patches for mysql5. 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 ======>>>>>.
xtreme-mobile Posted May 3, 2008 Author Posted May 3, 2008 Are you running on version 5 of mySQL. The link below for solutions to loads of problems has the patches for mysql5. hi just checked and got mysql version = 5.0.45-community-log ill check out patch cheers for that Visit my website in my profile for prices on woodburning stoves
Recommended Posts
Archived
This topic is now archived and is closed to further replies.