Article Manager

[pglock]

I'm attempting to setup a new store on a hosted server. The server is running PHP 4.0.6 (yes, it's very old, I know), the database server is mysql 5.0.17-standard.

I started with a clean install of RC2 then uploaded the update file, then configured the store. I have imported products and customer data from a 'live' store currently running oscommerce MS2 (plus various contributions) after working out a 'migration' sql script which I run on a locally host mysql server.

I'm currently working on the article manager. I've added a test article, but when I click on the link (/articles.php) to it I get the following error:

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'

From a little googling of other forums, this seems to be associated with the join statement differences between mysql5 and previous versions. Any ideas what I need to update/change?

[jpf]

Sound like a table is missing reload the table for Article Manager.

[pglock]

Tried reloading all tables from the stock osCMax.sql still got the same problem. Any other ideas?