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

[michael_s]

Hey what do I know. I have not been able to get that error no matter what I try, so I just assumed it was fixed in SVN.

If you post more detail as to how and where you get this error, maybe I can track it down. I just re-read this entire thread, and have no idea even where you get this error.

Is it in the admin panel? In the catalog? When you add an author? Add an article? What?

I don't think I get the error because I am testing on mysql 4.1 not 5x...

Note: I just tested on mysq 5.0.27 and I finally tracked down a place where I can get the error... It is only when I click the 'All articles' link in the articles infobox on the catalog side... Mindtwist, your fix is what is needed. The mod was coded on an older version of mysql and it is definitely a compatibility issue.

I also found another issue with the authors box in the SVN and JPF's package with the author's box (parse error).

[MindTwist]

This might be a stupid question, but what does SVN mean?

[michael_s]

SVN is short for Subversion Repository. It is where we keep all the development code so you can grab the latest files whenever you want.

Subversion is a version control system for tracking software changes and keeping everything organized. Our repository is here:

oscmax2 - Google Code

It makes it super easy to do upgrades, etc, as you just need to update your files with the new ones using an SVN client like TortoiseSVN.

[felisanator]

Ok -- so how do we fix this? I simply created a 'test" article and then activated the box using the infobox admin.

Once done, I changed the box to the left side of the store.

Then when I click the link to read the article, it says:

Tester heading title Using reusable cloth menstrual pads can save you time, money, your health and the EARTH!
1054 - Unknown column 'a.authors_id' in 'on clause'

select count(*) as total from articles a, articles_description ad left join authors au on a.authors_id = au.authors_id, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_status = '1' and a.articles_id = a2t.articles_id and ad.articles_id = a2t.articles_id and ad.language_id = '1' and td.language_id = '1' and a2t.topics_id = '1'

[TEP STOP]

and the bottom of the store is gone.

When I click on the "All articles" it happens.
When I click on the actual test article it happens.

I am working on a clean install of oscmax. on apache server

Server OS: FreeBSD 5.3-SECURITY Database: MySQL 5.0.45-log Server Date: 04/11/2008 21:09:01 Datebase Date: 04/11/2008 21:09:01 Server Up Time:
HTTP Server: Apache PHP Version: 5.2.5 (Zend: 2.2.0) osCMax v2.0 RC3

[michael_s]

Did you create an author and assign that author to the article? Try that and let me know...

[felisanator]

Hmm...

I created a new author.

However, there is nowhere on the article itself to assign an author??

Also, something really weird.

I went ahead and generated another articles as Test2 and it doesn't show up at all. I assigned it to the "top" -- nothing showed.
I assigned it to the "test" catagory -- nothing showed

And here is the error that is showing:

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

select count(*) as total from articles a, articles_description ad left join authors au on a.authors_id = au.authors_id, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_status = '1' and a.articles_id = a2t.articles_id and ad.articles_id = a2t.articles_id and ad.language_id = '1' and td.language_id = '1' and a2t.topics_id = '1'

[TEP STOP]

Thanks for trying to help...

[michael_s]

The issue is a mysql5 compatibility thing...

I think I have fixed it. Use the attached file to replace the articles.tpl.php file in the /templates/fallback/content/ directory

Note, there are a couple of other files that need to be fixed... I am zipping them now and will post in about an hour.

[felisanator]

Thanks, I'm going to try and do that now -- I appreciate you sharing your Friday night with me!
I'll post with results!

[felisanator]

Last edit on this file shows: 8/9/07

I uploaded it to the content directory you specified, but no changes were made. I guess I should take your advice and download that file comparison utility.

[michael_s]

Here is the full fix. I just tested it and it looks to be working great. The first file I posted, the All Articles link was still failing. This updated file should get it working 100%