I've hit some snags and am working my way through this but would appreciate any tips from others that might be more familiar with the workings of forums and comments in Drupal 4.5.2
I'm migrating from an oldish version of Phorum and migrated a couple of thousand user accounts across without any trouble:
http://drupal.org/node/9806#comment-30028
I've tested migrating several thousand of 25k phorum posts across but I suspect I'm missing something somewhere. Rather than hacking the tables direct, maybe there are some Drupal functions I need to RTFM about that will help me here?
All the nodes and comments are across. Blocks for forum topics and recent comments display fine and I can view the topics and comments just fine (not properly threaded yet, but they're all attached to their parents!)
But MySQL virtually hangs and takes forever to display the forums page (if at all) as an anonymous user and when I visit as uid 1 the forums page comes up quicker but displays a negative number of new nodes???
It's Almost Working For Me (TM)
;-)
// foreach phorum post {
// check to see if author has a drupal.uid
$result=db_query("SELECT uid FROM {users} WHERE (mail='%s' OR name='%s')",$ph_email,$ph_author);
$uid=db_result($result);
// no uid found, assign anonymous drupal.uid
if ($uid='') {
$uid=0;
}
// replace newlines in body
$ph_body=ereg_replace("\n","