Saturday, July 26th, 2003

Blood And Bones

Computers perplex me. I am working on a site that I built over a year and a half ago, and it’s been chugging away fine. This morning I edit a database table ever-so-slightly, and all of a sudden I can no longer query this table, or that’s even named similarly. It doesn’t like the NAME of the table. I create an identical table with a totally random name and it works fine. I change it to the original name, and poof! it’s gone. I can run queries from my MySQL client no problem, as far as it’s concerned, everything is copacetic. What the hell. My eventual fix? Give the table I want an intentionally misspelled name and change every single reference to that table throughout my site. Blaaaah.

I went to see The Godfather Part II last night at the Bloor, they’ve been running ‘Classic Films of the 70s’ the last while. I had never seen this film, and only saw the first on a couple years ago… yes, yes, I know, it’s mandatory viewing for anyone with a Y-chromosone and all that. Anyway, I thought the first one was good, but I wasn’t awestruck, and I guess the same goes for this one. It was engrossing enough, even though the Bloor’s scratchy print made it difficult to hear the quieter dialogue at times. Robert DeNiro was uncanny as the young Vito Corleone, though – I could have sworn I was looking at a young Marlon Brando. Remarkable. You can read read the entire script of The Godfather Part II here, if you feel so inclined.

Continuing this week’s Pernice kick, I picked up the Scud Mountain Boys’ The Early Year compilation last night, which collects the first two Scuds albums, Pine Box and Dance All Night. Good stuff, and Pernice fans should check back tonight when I update the mp3 of the week, I have a bit of an exclusive treat for ya.

np – Lambchop / Is A Woman

By : Frank Yang at 11:03 am
Category: Uncategorized
Responses are currently closed, but you can trackback from your own site.
RSS Feed for this postNo Responses.
  1. Victor Ng says:

    You see Frank? MySQL is a scary weird p.o.s. Switch to Postgresql. You’ll be happier and weird stuff will stop happening.

    On the other hand, you<em>do</em> take regular backups of your data don’t you?

    My guess is that one of the internal system tables in your MySQL database is pooched. I’d strongly suggest doing a full backup and recreate your entire database instance.

  2. Frank says:

    I don’t personally do backups. The webhosting does. Postgres isn’t an option, the webhosting doesn’t provide it. And I went back yesterday and tried it again and the problem had sorted itself out, all queries to whatever tables worked again. Shrug.