September 11, 2007

Urgh, file case.

I’m still fid­dling with Gallery to get images dis­play­ing — I have a feel­ing that the prob­lem is to do with file cas­ing, although I can’t be sure since I can’t see the PHP logs to see invalid fgets.

I just spent two hours fix­ing data­base ref­er­ences; I did­n’t realise that MySQL cre­ates tables in low­er­case in a Win­dows envi­ron­ment. For a while I thought I was going crazy, with iden­ti­cal tables and code refus­ing to act the same. In the end I export­ed the low­er­case db to SQL and used regex to fix the cas­ing, with an export of the prop­er­ly-cased table names as reference.

As for the images, I’m ready to blame a vari­ety of soft­ware. I’ll dig in with error_log tomorrow.

Hon­est­ly, who thinks file­name cas­ing is a good idea? The only ben­e­fit I can think of is per­for­mance (and depend­ing on the imple­men­ta­tion, stor­age 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 pro­vid­ed by Dreamhost. I bor­rowed a user account from my course teacher Michael Nel­son to try host­ing a PHP app I’m devel­op­ing, and end­ed up get­ting my own account. Prob­a­bly the most sur­pris­ing thing is just how many fea­tures you get for a rea­son­able cost. My pre­vi­ous host­ing com­pa­ny set my expec­ta­tions far too low, it seems.

posted by Andrew