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