Category Archives: OsCommerce

Moving OS Commerce from php4 to php5

I’m not sure if this fix is due to os commerce mods or just cause it’s needed when migrating a site from php 4 to php 5. After I switched the os commerce site to a new host i had many problems. A few hours and all can be fixed. This is just one of my problems. After moving the site the article link was bring up an error message:

Unknown column ‘a.authors_id’ in ‘on clause’

After google searching I found this fix which seems to work.

If anyone else finds this useful please post here and let me know.

Find the following variable in articles.php and change the query inside from:

$articles_all_query_raw = “select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from ” . TABLE_ARTICLES . ” a, ” . TABLE_ARTICLES_TO_TOPICS . ” a2t left join ” . TABLE_TOPICS_DESCRIPTION . ” td on a2t.topics_id = td.topics_id left join ” . TABLE_AUTHORS . ” au on a.authors_id = au.authors_id, ” . TABLE_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 = ‘” . (int)$languages_id . “‘ and td.language_id = ‘” . (int)$languages_id . “‘ order by a.articles_date_added desc, ad.articles_name”;

TO:

$articles_all_query_raw = “select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from ((” . TABLE_ARTICLES . ” a), ” . TABLE_ARTICLES_TO_TOPICS . ” a2t) left join ” . TABLE_TOPICS_DESCRIPTION . ” td on a2t.topics_id = td.topics_id left join ” . TABLE_AUTHORS . ” au on a.authors_id = au.authors_id, ” . TABLE_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 = ‘” . (int)$languages_id . “‘ and td.language_id = ‘” . (int)$languages_id . “‘ order by a.articles_date_added desc, ad.articles_name”;