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"; 


[TylerD]

Hello,

i'm new here. I'm also experiencing the same problem. Except that you can see it on whatever page you're on. I' ve also downloaded your articles file. Thing is that it doesn't change anything. Btw i'm not using the fallback template. Can anybody help me any further?..

[michael_s]

Did you also do the above code edit?

It doesn't matter if you are not using the fallback template. All templates use the fallback/content templates unless there is one present in the active content directory. If your template has its own content files, make sure you replace yours with the new ones...