oscomuser Posted July 5, 2007 Share Posted July 5, 2007 Hello, I have recently moved my database from MySQL 4.x server to 5.x and now i am getting a number of errors 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' and a.articles_date_added > SUBDATE(now( ), INTERVAL '365' DAY) Can anyone please advice how can i fix it and make my database 5.x compatible ? Link to comment Share on other sites More sharing options...
crash3903 Posted July 5, 2007 Share Posted July 5, 2007 same post? Regards Mark A Reynolds Link to comment Share on other sites More sharing options...
oscomuser Posted July 5, 2007 Author Share Posted July 5, 2007 That topic was open for two weeks with no reply. Yes, now thats the same topic as this one. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.