Hi,

I'm having an old osCMAX 2.0.1 installation that was exploited (osCMax v2.0 : Welcome to Healthy Bird Online Shopping) and it come to the point where I had to upgrade this script to it's last stable version, however the direct upgrade to 2.0.25 is not working. Is there someone that can provide some assistance on upgrading to the last stable release?

I'm also having a problem (seems to be caused by the theme) as you can see in the right area, where due a recent upgrade to MySQL 5.X the following error is displayed:

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]

I tried all the possible solutions from osCommerce but neither one of them helped in my situation. Is there someone here that can share some light into this please?