Tuesday, December 8, 2009

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.

Saturday, December 5, 2009

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?

Friday, December 4, 2009

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.

Thursday, December 3, 2009

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




Monday, November 23, 2009

Virtual Private Server Hosting

So I'm looking at current hosting plans for a new Virtual Private Server (VPS). I've found 3 websites with comparable hosting packages.

http://www.hostican.com/hosting/cpanel-vps.php

I'm liking the ixwebhosting.com's packages. Fair price and the best quality of servers and system resources.

Information I could find about IXWebhosting.com

Domain created: Feb 15, 2003
Domain Expires: Feb 15, 2017

Company is based out of Columbus, Ohio. Owned by Ecommerce.com.

Reviews of this host are not great, atleast 3 people have posted "Avoid them like the plague" and hundreds of customers are infuriated with the way they handle security, spam, backups, downtime, support tickets and customer service.

Next host on the list: Inmotionhosting.com
So far out of about 100 reviews i've read, I've only found about 3 or 4 negative reviews. They seem to be the more secure solution to my hosting needs. I read further into the reviews...
A couple hundred reviews in and I'm satisfied, inmotionhosting will be the one.

~Fastmover

Sunday, November 22, 2009

Making My Way

Today I realized i really needed a blog account. So Here I am on blog spot. I see so many links to this site and so many searches result in blogs I might as well contribute. I'm managing my way into website SEO ( Search Engine Optimization ) as well as freelance webdesign and PHP ( PHP: Hypertext Preprocessor ).

From my readings on SEO it's clear to me now i need more content as well as more sites. I currently have a gaming website for personal use and manage a few others. My gaming website is: http://www.IBAClan.com and is currently being redesigned. I'm a big Counter-Strike fan and a fan of First Person Shooter (FPS) games. I've had this website since I turned 18, and my love for the game has never faded. I ran a Counter-Strike Server from 2001 until 2004. The I*B*A Clan is still alive, just taken a long vacation.

I've tweak and helped put online, an excellent sports cards website. http://MillerCards.net was custom designed and built by Derek Miller. His love of Football Cards, Baseball Cards, and Basketball Cards has definitely sparked a creative side of Mr Miller. Miller Cards has some very cool features, to those who love the hobby, check his site out. You'll find monthly if not weekly and sometimes daily updates. For all those who love sports and sports cards, check out Miller Cards.

I'm currently updating http://www.CarlsonRoofingDoneRight.com with a few tweaks to the website and new content. If you need roof repair, a roof inspection, or just want a new roof, Carlson Roofing Done Right is the company for you. Roofers that give you Free Estimates and a quality job done right. Serving the Greater Kansas City Area and based out of Independence, Mo.

Well it's very late and I do have to work in the morning. Until my next blog.

~Fastmover