tikidiboo Posted March 9, 2009 Share Posted March 9, 2009 i am gatting this error on some of my pages 1054 - Unknown column 'p.products_id' in 'on clause' select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id in (38,39,40,41,43,44,45,46,47,48,57,58,59,60,62,75,77,78,26) and p.products_status = '1' and f.status = '1' order by rand() DESC limit 6 [TEP STOP] if you go to Visit My Website the error is on the gardens , frame hardware and security pages :( Any ideas what could be causing this any help greatly appreciated. Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted March 9, 2009 Share Posted March 9, 2009 Andy Try http://addons.oscommerce.com/info/4654 and the link in my sig block 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 More sharing options...
tikidiboo Posted March 9, 2009 Author Share Posted March 9, 2009 Andy Try http://addons.oscommerce.com/info/4654 and the link in my sig block Cheers geoffrey. fastest reply in history. ta mate ;) Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted March 9, 2009 Share Posted March 9, 2009 No way, I just got a reply in 4 mins. G 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.