I have two coding projects going, and both are for the moment stalled. Maybe you can help.
The more recent of the two is WP-Gatekeeper, which is almost ready to go from RC1 to RC2 except for one tiny little problem: I upgraded my local copy of MySQL, and it blew away my WordPress database. So I mysqldumped the database from meyerweb.com, copied it down to my hard drive, and tried to mysqlimport it. And tried, and tried, and tried, until eventually my eyes started bleeding. No dice. Therefore, no possible chance of my testing the update script, which is necessary because it actually deletes tables from the 1.0b1 version of Gatekeeper. I don’t want to put it out into the wild without making sure that it deletes the right tables, and no others.
Obviously, without a successful import of the dump file, I can’t test the script. I’ve read the MySQL documentation, and done everything it says to do. It fails. I tried logical variants, in case there was something the documentation was leaving out. No dice. Then I tried illogical variants, including some SQL statements that included words I wouldn’t ordinarily type, let alone say out loud. The error message is basically always the same, and it never helps. It goes something like this:
~/mw > mysqlimport -u root meyerweb meyerweb20050309.sql.dump mysqlimport: Error: Table 'meyerweb.meyerweb20050309' doesn't exist, when using table: meyerweb20050309
Well, no kidding, geniuses; there is no table called that, because it’s the name of the dump file, not anything in the database. And yes, when I dumped the DB from meyerweb, I did it so that it contained the
USE directives at the top of the dump file. They don’t seem to make any difference at all.
Plus all that was after I reinstalled MySQL about seventeen times because it refused to start up even though the installation was supposed to be point-and-click. Eventually I switched to a different, third-party install package, and it went like a charm. Serves me right, I suppose, for assuming that the MySQL.com folks could put together an install package that actually works. At this point, as far as I’m concerned, MySQL is the rotted corpses of the maggots that once infested the corn inside a pile of moose droppings.
Not that I’m bitter that this wasted four hours of my life or anything.
The other project is, of course, S5. It’s currently stuck at 1.1b5, because there’s this problem in Firefox for Windows that I simply cannot figure out. I commented on it a little over a month ago; the basic problem is that when viewing the testbed slide show in Firefox for Windows, it seems to “jiggle”, apparently from constant re-scaling of the fonts. I can’t figure out how to stop it.
So any ideas, anyone? At this stage, that’s pretty much the last major problem before going final. Safari still blocks use of Page Up and Page Down when in the outline view, but that’s something I can live with. The nervous-twitch display in Firefox for Windows isn’t acceptable in a non-beta version.
I’ll still be using S5 1.1b5 for my SXSW presentations, but that’s okay because I’ll be using Firefox for Macintosh, which doesn’t appear to suffer from the same problem. If it does start having problems, I’ll just switch to Safari. No big deal.
Anyway, that’s where things stand on those two projects. Hopefully I’ll get over the roadblocks soon, and be able to get them moving again.