beatriz08 Posted March 1, 2008 Posted March 1, 2008 Can somebody please help me to solve this problem? 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 = '136' [TEP STOP] I realize that I must have changed something without noticing it. I know this must be very annoying for anybody who is fit in all this, but maybe I can be helped without making me feel like a total looser. Thank You!! Beatriz
Guest Posted March 1, 2008 Posted March 1, 2008 Can somebody please help me to solve this problem? 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 = '136' [TEP STOP] I realize that I must have changed something without noticing it. I know this must be very annoying for anybody who is fit in all this, but maybe I can be helped without making me feel like a total looser. Thank You!! Beatriz What addon did you install? What osc version are you using?
beatriz08 Posted March 1, 2008 Author Posted March 1, 2008 What addon did you install?What osc version are you using? Here we go, I have no idea. A friend set our site up a few years back. Where can I look what OSC I am using? THe site was working fine and now when we add our categories I can add categories and products and on the admin site it looks fine, but on the website above message comes up once you click into the product.
Guest Posted March 1, 2008 Posted March 1, 2008 Here we go, I have no idea. A friend set our site up a few years back. Where can I look what OSC I am using? THe site was working fine and now when we add our categories I can add categories and products and on the admin site it looks fine, but on the website above message comes up once you click into the product. As a guess, your osc has not been patched for php and mysql updates, and your webhost has updated something. You need to find out what osc version you are using. The simplest way is in admin tools server info, not 100%, but it is a start.
beatriz08 Posted March 1, 2008 Author Posted March 1, 2008 Linux 2.4.21-52.ELsmp Is that it? Btw, thank you very much indeed for your help!
beatriz08 Posted March 1, 2008 Author Posted March 1, 2008 or maybe this??? osCommerce 2.2-MS2 PHP Logo PHP Version 4.4.7
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.