article error

[ecommboy]

Hi,

I have installed the latest osc2.2 max155 and I am having problems with the article info box.
I can create an article without problem in the Admin but the pages on the site can not display the latest or new articles.
When I click on an article, the follow error appears:


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]


I have not edited any code.
How do I fix this?

Michael.

[michael_s]

You may want to make sure all the tables are there in your database. It looks like something may be missing, like the articles tables. You should be able look at the sql file in the install directory and create the tables needed using the queries in there.

On another note, V 1.5.5 is a really old version of osCMax. I recommend using 1.7 or 2.0.

[ecommboy]

Hi Admin,

Thank you for the reply.
I didnt realise you had a latest version. I'll download this now.

I have been told there are also LEFT JOIN issues with MySQL with some of the code from v4.0.0 to v.5.0.0. Are these fixed on the latest download?

Thanks.

[michael_s]

Yes, there are a few issues with the 2.0RC2 download. There is a patch for it, that incorporates fixes for the mysql issues also in the downloads section of osCDox. It is called



osCMax-2.0RC2-update051112 patch



Just follow the instructions or, if you are doing a fresh install of osCMax, you should be able to just upload the patch files over your clean install.

There will be an RC3 release coming out soon. It fixes about 98% of all issues found in RC2. No official release date has been posted, but it should be within the next few weeks...