By r0g on

Hi there,

Firstly, please don't reply just to tell me I shouldn't be trying to do this, I _am_ trying to do this and I have my reasons so that type of answer A) will not change my mind and B) will only make it look like my post has been answered, therefore making it less likely to be answered by someone who can help, thanks ;)

I want to manually port the users and forums/comments of an old Drupal 4.7 site to the latest Drupal 6.
I have installed the 4.7 site locally and have updated it to the latest in the 6 series. This looks to have worked fine so far.

The users table copied over with no problem (all users seem able to log in fine) but then, to port the forum over, I copied over the following tables...

node WHERE type = 'forum'
node_revisions
comments
node_comment_statistics
term_node
forum

The forum posts appear under Administer/Content Management/Content and they are associated with the correct users :)
Likewise the comments show in the Administer/Content Management/Comments :)
Clicking on the links in either takes me to the correct node/thread :)

Sadly though...

Those nodes/threads aren't showing in the forum (which I have setup/activated) at http://example.com/forum/1, which is where they were before. (actually previous site didn't use clean URLs, one of the many reasons I want to start afresh!)

http://example.com/forum/0 shows the forum exists but has 0 Topics and 0 Posts. I can create new forum topics and comments and they show up fine in the forum view.

I'm ditching the old (ugly) taxonomy entirely but the forums seem to have the same taxonomy id of 1 anyway so I don't know how that can be an issue.

So I'm a bit stuck...

I have diffed database dumps before and after posting new topics to see if any other tables are involved but couldn't see any that had been changed other than the ones above. Looking at the tables in PHPMyAdmin it is clear the old records are in the same format as the new ones. I must have missed something, I thought it must be the sequences table for a while but that doesn't seem to exist in 6.1x

Anyone any ideas?

Cheers,

Roger.

Edited by: VM; Thread moved

⋅ Categories: Drupal 6.x

Comments

vm’s picture

vm commented

duplicate post deleted. In future edit your posts and move them if necessary. Posts can be bumped by commenting on them

http://drupal.org/forum-posting

reviewing some similar posts, albeit, not doing the same things I've seen this

vocabulary_node_types values (1, 'forum');

As a method used to fix issues with users who were using the UIEforum and wanted to move back to core forum module and when they did forum threads weren't showing. Not sure if it's related or even applies to D6.

r0g’s picture

r0g commented

I had a look and sadly this is the case for both the source installation (where they are showing) and the destination installation (where they aren't).

As the destination is a fresh install the only vid (vocabulary id?) defined in either vocabulary table is 1:forum in 'vocabulary_node_types' and 1:Forum in 'vocabulary'.

Thanks anyway,

Roger.

r0g’s picture

r0g commented

Bump!

silverwing’s picture

silverwing commented

24 hours is the usual minimum time you should bump your post - not 10 hours. People who help here do have jobs and family and have to sleep. (We're all volunteers, remember.)

~silverwing

r0g’s picture

r0g commented

I've been doing nothing else for days (neglecting my own loved ones in the process) and I finally got some sleep so it felt like the next day to me. Sorry.

silverwing’s picture

silverwing commented

I was having issues this morning.

I'd make sure the 4.7 to 5.last works as expected. If 5.x works, that should help narrow down some problems.

And make sure you give everyone you've been neglecting a hug! :)

~silverwing

vm’s picture

vm commented

have you considered, upgrading the 4.7 site to 5.x then to 6.x and then exporting the tables you require and manually editing the taxonomy term after import into your D6 production site.? The upgrade should be fairly painless especially if you disable everything that don't matter since all you care about is the forum nodes.

other than that, I'm out of ideas.

r0g’s picture

r0g commented

Hi VM,

Thanks for the response. I updated from 4.7 to 5.0 to 5.14 to 6.0 to 6.15 although now I realize 5.14 isn't the most recent of the 5 series anymore so I'll try slipping that into the mix. Fingers crossed!

Thanks for the help.

vm’s picture

vm commented

you should only have to go to the last version of 4.7 which I think was 4.7.6, then upgrade to the last version of 5.x then the last version of 6.x no need for the .0 steps from what I can tell.