Drupal 6 upgrade fixes

Published in

Well, I've fixed a couple of things. I installed the Help module for Views, and understood it a little bit more, enough to re-create the Knotty Geeks views module. Unfortunately it would work in Gallery Live Preview mode, but gave a 404 error when I clicked the link. I had to end up changing the link from jeremyreimer.com/views/knottygeeks to jeremyreimer.com/audio/knottygeeks, and then magically it worked again. Maybe it just needed a /views/ subdirectory to work, because I had an /audio/ subdirectory already.

Then I fixed my Book problems, where my entire book hierarchy had gone missing. This is a known issue, and the solution is actually not that hard:

1.) drop table book in D6 (if there are no diffs to your backup of D5)
2.) reimport table book from D5
3.) run update_6000 for the book module (2nd page of update, Select Version, choose 6000 in the drop-down-box for book)
4.) check your book hierarchy

I took my original full database backup and restored it to new database called 'backup'

CREATE backup;
USE backup;
SOURCE dbcontent.sql;

Then I exported just the "book" table:

$ mysqldump backup book > book.sql

Then dropped the table from the Drupal 6 database

USE mydbname;
DROP table book;

Then just re-imported it from the book.sql file

$ mysql mydbname < book.sql

And then ran update.php from my site, and selected "6000" from the "book" table, and voila!

Now that everything is working, I'm going to stop fiddling with things.