SQL problem when Installation

[shawn6688]

Hi Everyone,

 

I have an old version osCommerce 2003 and old MySQL. When I copied the file to the new website.

 

In the first page it gave me following error: 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)

 

 

It works perfectly on the old server but not work in the new environment.

 

 

Shawn