Article Manager MySQL 5 issue

[Fredrik.r]

Hi! Since the hosting company I'm using updated to MySQL 5 a few days ago there is an error in articles.php;

 

----------------------------

 

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 = '4' and td.language_id = '4'

 

[TEP STOP]

 

----------------------------

 

How can this be solved? Someone told me to add "as total,* from..." but there are several querys in that file and I am not sure which to correct or how to correct them.

 

Very thankful for help with this!

[radders]

Some of the fixes are in this thread.

[Fredrik.r]

Thank you. It seems that Article Manager 1.5 isn't compatible with MySQL 5. The queries in the thread you mentioned isn't the same as in Article Manager 1.5. Neither before or after the suggested changes.

Edited February 27, 2007 by Fredrik.r

[♥bruyndoncx]

Try with this code instead. Note in the tips & tricks forum I posted the general explanation and how to fix things.

select count(*) as total from articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id, articles a 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 = '4' and td.language_id = '4'

[oscomuser]

Can you please refer me to that thread in Tips and Tricks ?