Massive newspaper migration project

Hi everyone!

I've spent over a year working on a massive tech reboot for the student paper I've worked at for the last five years (Last project I do for them, really) and was seriously about ten minutes away from completing it with the Ruby (Sinatra, actually) -based HotInk (HotInk.net) before a number of things complicated this. While waiting for a response from the developer to connect the two separately-functioning server components (Eep!), I started searching for alternatives, overcame my Drupalphobia and started playing with ProsePoint...

That was about two days ago. I'm now quite close to finishing this project – short of what will be a hair-raising series of database imports (~14,000 stories, ~900 sources, ~9,000 images, craploads of comments). I just wanted to say thanks for such awesome code, as well as ask a few questions about importing:

1. I'm using Table Wizard and Migrate and having some issues. When I try to create a relationship, the view doesn't update and I'm left with the same view as before. I might just be failing to miss something obvious about using these two modules, or it might be something PP specific, I'm not sure. Thoughts?

2. Anyone have any experiences migrating a size this big and willing to share experiences?

Thanks!

UPDATE: I figured there was something wrong with the Views module, so I updated it to the latest version (x.10). Now I get the following error message when I try to access a view:

Fatal error: Cannot redeclare _views_theme_functions() (previously declared in /home/gauntlet/webapps/prosepoint/sites/all/modules/views/theme/theme.inc:21) in /home/gauntlet/webapps/prosepoint/profiles/prosepoint/modules/views/theme/theme.inc on line 36

Replacing the existing version gives me a ton of errors.

Also, if it helps, I keep getting this error on various pages:

View dbStory does not exist - either (re)create this view, or remove the migrate content set using it.

(This is a view I created with Table Wizard.)

I'm going to try playing with the Import module and see if I can get any further. Wish me luck!

Edit2: I was just using the Views UI wrong. I needed to add the fields to the view in the Views UI after creating the relationship in Table Wizard. Yet I'm now getting the following error when trying to import:

user warning: SELECT command denied to user 'gauntlet_a_2'@'localhost' for table 'migrate_map_stories' query: SELECT dbStory.SID AS SID, dbBodytext.SID AS dbBodytext_SID, dbStory.Date AS dbStory_Date, dbStory.Section AS dbStory_Section, dbStory.Headline AS dbStory_Headline, dbStory.Deck AS dbStory_Deck, dbStory.Tab AS dbStory_Tab, dbStory.HideOnIndexes AS dbStory_HideOnIndexes, dbStory.Special AS dbStory_Special, dbStory.Locked AS dbStory_Locked, dbBodytext.StoryText AS dbBodytext_StoryText, migrate_map_stories.destid AS destid FROM dbStory dbStory LEFT JOIN dbBodytext dbBodytext ON dbStory.SID = dbBodytext.SID LEFT JOIN gauntlet_drupal.migrate_map_stories migrate_map_stories ON dbStory.SID = migrate_map_stories.sourceid LEFT JOIN gauntlet_drupal.migrate_msgs_stories migrate_msgs_stories ON dbStory.SID = migrate_msgs_stories.sourceid WHERE (migrate_map_stories.sourceid IS NULL OR migrate_map_stories.needs_update = 1) AND (migrate_msgs_stories.sourceid IS NULL) in /home/gauntlet/webapps/prosepoint/sites/all/modules/migrate/migrate.module on line 719.

Is this a MySQL permissions granting thing? I'll try changing those and post after.