thecustomshop Posted April 4, 2007 Posted April 4, 2007 When you select on a subcategory, you get the left menu bar, top menu bar, and then an 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] No right or bottom menu bars after that. You can view the current program running at http://www.fastpartsdepot.com/
kirikintha Posted April 4, 2007 Posted April 4, 2007 This may be because you have a compatibility issue with mysql5 oscommerce.com/ext/update-20051112.html#_Toc119473702 Nothing unreal exists
thecustomshop Posted April 4, 2007 Author Posted April 4, 2007 This may be because you have a compatibility issue with mysql5oscommerce.com/ext/update-20051112.html#_Toc119473702 I do not believe I am running a MySQL5 database, I believe its a 3 or 4. Does that matter for this error?
kirikintha Posted April 4, 2007 Posted April 4, 2007 I do not believe I am running a MySQL5 database, I believe its a 3 or 4. Does that matter for this error? MYSQL5 runs in a stricter mode, that's why it usually does not work - do a search on google for your error, there are other postings for this on other websites that are related to OSC Nothing unreal exists
thecustomshop Posted April 4, 2007 Author Posted April 4, 2007 This may be because you have a compatibility issue with mysql5oscommerce.com/ext/update-20051112.html#_Toc119473702 Well I tried it, and it worked!
kirikintha Posted April 4, 2007 Posted April 4, 2007 Well I tried it, and it worked! Awesome! I least I helped one person today! Nothing unreal exists
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.