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:
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?Code: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'