majestique Posted March 10, 2006 Posted March 10, 2006 Here's what I see when I created any arbitrary category and click on the category link: 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 = '26' [TEP STOP] Does anyone know what's wrong? Thanks!
Guest Posted March 11, 2006 Posted March 11, 2006 it has to do with mysql version you're using. Have a look on the osc downloads page, get the latest version and either upgrade or do manual mods to the pages with the documented sql queries.
majestique Posted March 16, 2006 Author Posted March 16, 2006 thanks for your reply Mark! but my osc is quite modified.. now i gotta probably look for categories.php and figure out what's the problem? i have multiple sites on one host, and have the same shopping cart.. the categories work fine on one site.. but not on the other.. so it can't be the mysql version or the query? the scripts are exactly identical... hmm what else could it be?
Guest Posted March 20, 2006 Posted March 20, 2006 the updated documents are with the latest osc version. http://www.oscommerce.com/solutions/downloads extract it and read the notes.
Seagoofy Posted March 21, 2006 Posted March 21, 2006 Might try the brackets cure B) Change 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 = '26' to 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 = '26' Seagoofy
Recommended Posts
Archived
This topic is now archived and is closed to further replies.