No bike shops in Kirksville? What's that all about? I had that very same thing happen to me a couple of weekends ago. Fortunately Red Wheel Bike Shop was halfway on the Jeff City Greenway. And then it was mostly downhill to it. Luck was with me. (I will never, ever forget my chain tool again!) They even put the new chain on for me. I was due for one... Highly recommend Red Wheel.

Which shop did you use in Columbia? I bought my mountain bike from Cycle Extreme. Love them. I have had nothing but friendly excellent service there.