1054 Unknown column

[abacususer]

Hi, I transfered hosting from a windows based platform to a linux. I don't know if that helps. I get this error on the articles link and products. Any help... Thanks

1054 - Unknown column 'a.authors_id' in 'on clause'

select count(*) as total from articles a, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id left join authors au on a.authors_id = au.authors_id, articles_description ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '1' and td.language_id = '1'

[TEP STOP]
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_retail_prices 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 = '2'

[red_fraggle]

Windows and linix has no b earing on the issue. Your old host was running Mysql 4 and your new host is running Mysql 5.

Search these forums for a.authors_id

[red_fraggle]

I have found out that this was evidently fixed in osCMax-2.0RC2-update051112 Patch, however, i have not been able to find the file to download it from this site!

Michael made a nice post, about how this was the fix, then closded the article, without giving a link to this patch in his reply. So i am unable to even ask in that post where to get it. I have added a new post myself, and will hopefully get a response with a file download location soon.

sincerely,

[michael_s]

The link to the download is posted in the article...

osCMax 2.0RC2 Security Patch/Update 051112