chrispynic Posted March 22, 2007 Posted March 22, 2007 Our server was recently upgraded by our host. PHP went from 4.2.3 to 4.4.4, and now I am having trouble with some of the pages. Specifically all of categories pages in the catalog. Here is the error that I am receiving. Any ideas? 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 = '21' [TEP STOP]
tarheit Posted March 22, 2007 Posted March 22, 2007 The same thing just happend on the server I was on. Haven't tried it yet, but you may want to check out the bug (and fix) here: http://www.oscommerce.com/community/bugs,3259 -Tim
Guest Posted March 22, 2007 Posted March 22, 2007 use the manual instructions from the latest osc and upgrade your store, it's due to mysql5x http://www.oscommerce.com/solutions/downloads
chrispynic Posted March 26, 2007 Author Posted March 26, 2007 Thanks for the help! Using the information from the upgrade documentation I was able get the problem fixed. Don't know what us newbies would do without help from the experts....
Recommended Posts
Archived
This topic is now archived and is closed to further replies.