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.
Comments
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.
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