John Borwick’s blog

I’ve been fixing Lauren’s drupal site for the past couple o’ days. Her Fantastico upgrade wasn’t so fantastico, so it corrupted her junk.

Fixed via

1. MySQL dump of database (say, into “backup.mysql”)
2. Delete & re-install Drupal via Fantastico (proper syllabic emphasis required). At this point you have a fresh, clean Drupal site. So fresh! And so clean!
3. Figure out Drupal database credentials (e.g. “grep db_url ~/path/to/drupal/sites/default/settings.php”)
4. Drop Drupal database (e.g. “drop database user_drpl1″–caveat lector!)
5. Create Drupal database (e.g. “create database user_drpl1″)
6. Re-import old database via MySQL import: “mysql -u user_drpl1 -p user_drpl1 < backup.mysql”
7. Download Drupal and get the “update.php” file
8. Edit this file to change TRUE to FALSE and put it in your ~/path/to/drupal/
9. Call the file: http://www.example.com/path/to/drupal/update.php
10. Do its bidding
11. Delete upgrade.php
12. In Lauren’s case, fix themes via “cd ~/path/to/drupal/themes; ln -s bluemarine theme-she-used-but-doesnt-exist-anymore”)

That’s it!

I just re-enabled comments for every post that I’ve ever made.  With the old blog I turned off comments after two weeks, which pretty much killed all spam… and prevented much useful interaction.  Here’s to hoping the WordPress spam plug-ins I’ve added work!

This is a test post from my mobile phone via email.

I just turned on WordPress hashcash for comments. Basically your browser computes a Javascript hash and sends it to the comment-processor when you comment on the blog.

This means that you must use Javascript to post comments.

What is the world coming to when my website is no longer lynx-compliant?!

I’m testing my ability to post via e-mail!

Well, I just switched to WordPress. The conversion wasn’t as painful as I thought–although I just broke all my URLs, including the RSS feed. Oh well!

Now I’ve got to figure out how this thing works. I’ve already imported my old Movable Type information, and my Google Reader OPML (so I could have an accurate blogroll).