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.