Article manager - 1054: 'a.authors_id'

[fimilola]

Hi,

Just installed article manager 1.2b) with spanish translation and it works great admin side but the articles box displays this:

 

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

 

select a.articles_id 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 = '10' and td.language_id = '10' and a.articles_date_added > SUBDATE(now( ), INTERVAL

 

If I take out the a. then it displays ok but each article is multiplied by the number of authors and then i have this message:

 

 

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 = '10' and td.language_id = '10' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY)

 

 

Since i don't know anything about SQL , can someone help me on this?

 

Thanks