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

[felisanator]

run that one by me again? I just downloaded it again and the same zip file with the same size and date (only one file articles.tpl.php 8/9/07) ...with no changes to the server after upload.

[michael_s]

Sorry about that, I have several installs of osCMax (6) and I zipped the wrong file twice...

I fixed it. The new zip contains the fixed file dated 4-11-08 It is 2 posts up in my previous post.

[felisanator]

Thanks for that! The store isn't broken anymore. but when I assign the articles to the top category (as I don't want to categorize any of the articles at this time).
It says that there are no articles

All Articles
Current Articles There are currently no articles listed.

So...I found that I can disable the link to "all articles" That way the articles still show under the "articles" heading.

[michael_s]

Yes, that is a limitation of the mod. Articles must be put in a category.

[MindTwist]

heh I am almost afraid to touch anything over here now since my articles are working ok...

[Microtekblue]

Hello,

I had the exact problem and I downloaded your patch, and that fixed everything wonderfully,

EXCEPT for when I click the New Articles link I get the 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' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY)

[TEP STOP]

New Articles



Please advise a fix to that part.

I think another code fix is needed for the articles_new.tpl.php

All help is greatly appreciated.

Thank you.

[cikez]

I am also having the same problem after the fix above. Everything seems to work fine except for articles_new.php.

Originally Posted by Microtekblue

Hello,

I had the exact problem and I downloaded your patch, and that fixed everything wonderfully,

EXCEPT for when I click the New Articles link I get the 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' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY)

[TEP STOP]

New Articles



Please advise a fix to that part.

I think another code fix is needed for the articles_new.tpl.php

All help is greatly appreciated.

Thank you.

[michael_s]

To fix the new articles issue, edit articles_new.tpl.php in the fallback/content directory and change line 17 from this :

PHP Code:

  $articles_new_query_raw = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_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 = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' and a.articles_date_added > SUBDATE(now( ), INTERVAL '" . NEW_ARTICLES_DAYS_DISPLAY . "' DAY) order by a.articles_date_added desc, ad.articles_name"; 


to this:

PHP Code:

  $articles_new_query_raw = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from ((" . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t) left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id) left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_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 = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' and a.articles_date_added > SUBDATE(now( ), INTERVAL '" . NEW_ARTICLES_DAYS_DISPLAY . "' DAY) order by a.articles_date_added desc, ad.articles_name";