Utterly Boring dot com

I'm A Dork

I just spent an hour trying to troubleshoot a problem with a PHP script I have for my work site. It's a simple script that takes the contents of a CSV file and dumps it into a MySQL database. Before I left on Friday, the thing worked fine. I get back here today, suddenly the thing doesn't work.

So I'm sitting there, racking my brain on why the file wasn't working. It appeared OK, but something still wasn't working. Then I started blaming our crappy DOS-based reservation system for screwing with the file, I started screaming and cussing out the scripts it uses, etc... .

Then I actually opened up the CSV file in Pico from a Unix command line and noticed a lot of funny characters. Then I realized what had happened: My FTP program was putting the thing on the server in binary format instead of ASCII. So I just wasted an hour on something stupid that took about three seconds to fix.

/me is stupid. Hopefully the rest of the day won't be filled with as much boneheadedness.

Posted by Jake on 01/17/05 @ 01:16 PM
Posted in Jake | 2 Comments | Permalink
Submit to digg, del.icio.us, reddit, or stumbleupon

2 Comments

jontz01 said on 01/18/05 @ 04:05 PM:
shit happens, time at work is usually spent confused, looking over and over at something that should be so easy. It usually is something dumb.... Don't worry, shit happens.

Peter said on 01/30/05 @ 02:42 PM:
Same happend to me. I didn't realize
that my FTP programm was using the
binary format. I spent hours and hours
for a problem which should be easy
to solve.
m&a


Post a comment












HTML Allowed: a href, b, br, p, strong, em, ul, li, blockquote




Note that comments on older entries are moderated automatically on this site to help fight comment spam. If you don't see your comment after submitting, it will appear on the site after it has been approved.

What are you doing down here? Don't you have something better to do? Like Go Back To The Top of the page, or even see who created this site? This site is © 2001 - 2008 by the Utterly Boring folks at UtterlyBoring.com. Steal my content, as I probably did, too, just link to my site or the original site. Batteries not included. One size fits all. Not for off-road use. Not for internal use. Do not taunt Happy Fun Ball. Technorati Profile.