September 11, 2007

Urgh, file case.

I’m still fiddling with Gallery to get images displaying — I have a feeling that the problem is to do with file casing, although I can’t be sure since I can’t see the PHP logs to see invalid fgets.

I just spent two hours fixing database references; I didn’t realise that MySQL creates tables in lowercase in a Windows environment. For a while I thought I was going crazy, with identical tables and code refusing to act the same. In the end I exported the lowercase db to SQL and used regex to fix the casing, with an export of the properly-cased table names as reference.

As for the images, I’m ready to blame a variety of software. I’ll dig in with error_log tomorrow.

Honestly, who thinks filename casing is a good idea? The only benefit I can think of is performance (and depending on the implementation, storage size.) It’s just a pain in the arse.

posted by Andrew

September 10, 2007


Wow, that sure was a long 12 hours!

xhva.net is now provided by Dreamhost. I borrowed a user account from my course teacher Michael Nelson to try hosting a PHP app I’m developing, and ended up getting my own account. Probably the most surprising thing is just how many features you get for a reasonable cost. My previous hosting company set my expectations far too low, it seems.

posted by Andrew