{"id":28,"date":"2007-09-11T03:38:48","date_gmt":"2007-09-10T16:38:48","guid":{"rendered":"http:\/\/xhva.net\/log\/?p=28"},"modified":"2008-03-21T08:33:48","modified_gmt":"2008-03-20T21:33:48","slug":"urgh-file-case","status":"publish","type":"post","link":"https:\/\/xhva.net\/log\/2007\/09\/urgh-file-case\/","title":{"rendered":"Urgh, file&nbsp;case."},"content":{"rendered":"<p>I\u2019m still fid\u00addling with Gallery to get images dis\u00adplay\u00ading \u2014 I have a feel\u00ading that the prob\u00adlem is to do with file cas\u00ading, although I can\u2019t be sure since I can\u2019t see the PHP logs to see invalid fgets.<\/p>\n<p>I just spent two hours fix\u00ading data\u00adbase ref\u00ader\u00adences; I did\u00adn\u2019t realise that MySQL cre\u00adates tables in low\u00ader\u00adcase in a Win\u00addows envi\u00adron\u00adment. For a while I thought I was going crazy, with iden\u00adti\u00adcal tables and code refus\u00ading to act the same. In the end I export\u00aded the low\u00ader\u00adcase db to SQL and used regex to fix the cas\u00ading, with an export of the prop\u00ader\u00adly-cased table names as reference.<\/p>\n<p>As for the images, I\u2019m ready to blame a vari\u00adety of soft\u00adware. I\u2019ll dig in with error_log tomorrow.<\/p>\n<p>Hon\u00adest\u00adly, who thinks file\u00adname cas\u00ading is a good idea? The only ben\u00ade\u00adfit I can think of is per\u00adfor\u00admance (and depend\u00ading on the imple\u00admen\u00adta\u00adtion, stor\u00adage size.) It\u2019s just a pain in the&nbsp;arse.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I\u2019m still fid\u00addling with Gallery to get images dis\u00adplay\u00ading \u2014 I have a feel\u00ading that the prob\u00adlem is to do with file cas\u00ading, although I can\u2019t be sure since I can\u2019t see the PHP logs to see invalid fgets. I just spent two hours fix\u00ading data\u00adbase ref\u00ader\u00adences; I did\u00adn\u2019t realise that MySQL cre\u00adates tables in&nbsp;[\u2026]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"wp_typography_post_enhancements_disabled":false,"ngg_post_thumbnail":0},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/posts\/28"}],"collection":[{"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/comments?post=28"}],"version-history":[{"count":0,"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/posts\/28\/revisions"}],"wp:attachment":[{"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/media?parent=28"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/categories?post=28"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/tags?post=28"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}