osCMax 2_RC3 - Table 'max23.configuration' doesn't exist

**fuzzyphil** · 08-06-2006, 02:15 AM

Something is not right. Having created two articles, set myself up as an author and switched on the Articles link in info manager I get:

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

select a.articles_id 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]

Is this because I am using PHP 4?

Also there is no mention of the Article Manager in the main front menu to Admin.

**fuzzyphil** · 08-06-2006, 02:41 AM

Having just wiped and reinstalled again - this time using a PHP5 configuration - everything appears to work correctly, Articles included. Therefore I can only assume that the Issues relate solely to PHP4. This means that I cannot use this new osCMax2_RC3 on my live host as they are geared up for PHP4.
Drat!

**michael_s** · 08-06-2006, 09:34 AM

We do all our development testing on both php4 and php5 servers and have not seen that error. I will attempt to reproduce it to see if I can pin it down...

**michael_s** · 08-06-2006, 10:48 AM

posted too soon... still working on this...

**Cisco** · 08-06-2006, 11:03 AM

I tried to download the sql file but ai get an error screen with a bunch of garbage text. Even tried to save file and I get an HTML. I think it is an windows thing. Have you placed this in the download section?

**michael_s** · 08-06-2006, 04:43 PM

Cisco: the full download has the original sql file in it since yesterday. Just grab the full download. regarding your screen garbage, it is because you have your IE browser set up wrong. It is using http 1.1. Disable this. Search http 1.1 here for details.

Regarding the SQL error, this is due to MySQL 5, not PHP5. You will need to edit the articles mod queries to be Mysql 5 compatible. MySQL 5 is much more strict on syntax, especially on JOIN behavior.

It is just a matter of editing the queries to the proper syntax. I am attaching 3 files that should fix all the issues.

The 3 files are

1. articles.php which needs to replace /catalog/includes/boxes/articles.php
2. articles.tpl.php which needs to replace /catalog/templates/fallback/content/articles.tpl.php
3. articles_new.tpl.php which needs to replace /catalog//templates/fallback/content/articles_new.tpl.php