My dot com is live!

Finally. Steven Kohlmeyer .com is live.  I now have a blog on there. I'll keep this blog active with new posts, but the majority of my posts will be at http://StevenKohlmeyer.com.

Kansas City Chiefs vs Denver Broncos

This is going to be a great game.  Me living in Kansas City and being a Denver Broncos fan.  I cannot lose this game.  Either way I win.  I can't wait until the game tomorrow.  Who else is gonna be there?

InMotionHosting

So far pretty easy to deal with customer service at In Motion Hosting.  I've talked to them on live chat, the only tricky thing is, pick out your words before you ask them on the initial question on their live chat request.

However, if you ask something too long, or what they probably would deem difficult, they'll forward your web browser to a static page explaining they're no longer online and asking you send your request to their support email.  So you just have to click back in your browser, retype your question or request (make it sound simpler) and send another live chat request.  

They are pretty quick with responses, once you get through the queue line or 3-8 people in front of you. They forwarded me to sending a support email asking them to do what I needed.  Not that it was a hard task.  Now I'm waiting for their support team that answers email to update my account and get me streaming.

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";