A comma, a comma, my kingdom for a comma!
Work on Quarto progresses. Having firmly re-saddled myself a day or two ago, I settled in and got some real work done today. Hence, the lack of entries (did you get lonely in the meantime?). Probably most cheerworthy is the stunning fact that there is now something to actually <em>test</em>—in addition to user authentication and logging functions, I now have full user editing capabilities set up.
These capabilities make it much easier to test out new functions; it's much nicer to be able to add in a test account from the web interface, instead of needing to do it from the devilishly-charming mySQL command-line interface.In the grandest of domesticat style, I spent the good portion of an evening puzzling over why the 'superuser-editing-another-user' page wasn't working right. Gareth counseled me to give it a rest until the next morning, but instead I spent until one a.m. poking and prodding the unresponsive code to try to figure out what the problem was.
Eventually, I gave up, and curled up with an Iain Banks book on the couch. Even rereading the deadly bleakness/seriousness of <u>Use of Weapons</u> was far preferable to [repeatedly] bashing my head into code that simply refused to work.
This morning, I unearthed the problem: a stray comma inside the second of my two db queries, which caused the second query to fail every time.
Having gained both calmness and introspection in the hours since I found the error, I'd like to say that my initial reaction was "No wonder only part of the user information updated itself!" In truth, it was more along these lines: "A comma? A single comma? A single, useless, stupid comma in a stupid* mySQL query caused all that?"
Of course, it's a lot more realistic if you start those sentences in a low, growly voice and then escalate the tone so that, by the end of the third sentence, the words are being uttered in a high-pitched wail.
The cats don't like such vocal theatrics. mySQL wasn't much impressed with them either.
But, hey, it's all better now. As said to Will this afternoon:
Amy: people creepy. code lovely.
Will: =) ahh. you HAVE become one of us!
* Editor's note: Everything is "stupid" when it gets in my way.