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

[dragonkeeper1973]

When I enabled the articles, authors, cross sells, I get the following error:

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]

Is there any way to fix this problem?

Server info:
Linux
Apache Version 1.3.37 (Unix)
PHP version 5.1.6
MySQL client version: 4.1.21
MySQL details as provided by host:

• Server version: 5.0.27-standard-log
• Protocol version: 10
• Server: Localhost via UNIX socket

The page that the error happens on is when I click the all articles and on the article it's self. I also had created article topic categories under the admin section.

Thanks for any info.

Dallas

[Keilup]

I don't know the answer, but maybe can give you a lead. This looks like it might be a MySQL version 5 issue with joins. See this thread for more information and some good links to other info:

I know you show MySQL 4.x in your post, but make sure you verify in your account (or contact your host) which version you are using. Many hosts have been upgrading to MySQL 5 recently.

[heatherk]

I found this fix that worked for me - I think php 5 is the problem, but this solved it:

Article Manager v1.0 - osCommerce Community Support Forums