Help with importing from WBB3.1
-
Hello,
after exactly 10 years and over 500.000 posts with our board deppheads.com running with Woltlab Burning Board (right now version 3.1.8), social networks have sort of won – instead of 150 new posts the day we have now maximum 5 posts. WBB4 will be coming out soon, so this is the right time to sell my WBB license and move it all to my site johnny-depp.org, powered by WordPress. This is where I seek help.
I already deleted inactive members, so that we now have “just” over 300, but I don’t want to delete all the written things like movie reviews and serious discussion, as this is still the home of many. So there are 500.000 posts and nearly 10.000 topics to be imported.
I edited the example.php and so far it worked with importing members and forums (just on a test WordPress installation for now).
However, there are some problems/questions I’ve come up with and I’m almost sure, there will be more following.
1. there is, equally to phpBB, the problem, that there are topics and posts, and the first post of the topic has to become “topic content” of WBB.
Here I used
// Topic content.
// Note: We join the posts table because topics do not have content.
$this->field_map[] = array(
'from_tablename' => 'wbb1_1_post',
'from_fieldname' => 'message',
'join_tablename' => 'topics',
'join_type' => 'INNER',
'join_expression' => 'USING (threadID) WHERE wbb1_1_post.postID = wbb1_1_thread.firstPostID',
'to_type' => 'topic',
'to_fieldname' => 'post_content',
'callback_method' => 'callback_html'
);Unfortunately, I get the error, that wbb1_1_post.message does not exist:
WordPress database error: [Unknown column 'wbb1_1_post.message' in 'field list'] SELECT convert(wbb1_1_thread.threadID USING "utf8") AS threadID,convert(wbb1_1_thread.replies USING "utf8") AS replies,convert(wbb1_1_thread.boardID USING "utf8") AS boardID,convert(wbb1_1_thread.userID USING "utf8") AS userID,convert(wbb1_1_post.message USING "utf8") AS message,convert(wbb1_1_thread.topic USING "utf8") AS topic,convert(wbb1_1_thread.time USING "utf8") AS time,convert(wbb1_1_thread.lastPostTime USING "utf8") AS lastPostTime FROM wbb1_1_thread AS wbb1_1_thread LIMIT 0, 100
But it does!
I attached both, my wbb3.php import script and the database structure of the most important tables, here you go:
http://deppheads.com/uploads/wbb.txt
http://deppheads.com/uploads/database_structure.txt2. I hope/guess, this is also the reason that all topics (once I remove that passage that produces an error) are started either by Anonymous or by ME (although I haven’t done it)?
3. some users are twice now (like myself..who have been admins of wordpress and users of the forum). Can I simply merge them with
UPDATE wp_posts SET post_author = ‘1’ WHERE post_author = ‘2’; and it will count for the forum, too?4. the passwords – in WBB they are hashed by this:
$passwort = sha1($row->salt.sha1($row->salt.sha1($_POST[‘passwort’])));
so what do I write at the end of wbb3.php
public function authenticate_pass( $password, $serialized_pass ) {
$pass_array = unserialize( $serialized_pass );
return ( $pass_array[‘hash’] == md5( md5( $password ). $pass_array[‘salt’] ) );
}
or is this impossible and the users have to get the new password by mail?5. the imported users have no “Forum Role”. Is is “normal”? Is there any chance to automatically give them the forum role “Participant”?
6. do I have to keep the wbb3.php “forever” because of the passwords or can I delete it one day, even if not all members have com back yet?
7. until now we have everything like private messages, profiles, friends and especially user groups (Moderators, crew members) with hidden forums. Do I see correct, that I can install both, import bbpress and afterwards attach for example our “Mods Only” to the group “Moderators” as group forum?
8. I see that every user gets a new User ID – old IDs are saved in table _bbp_converter_translator – will that table be kept? Maybe by this I have a chance to later import – somehow – private messages for buddy press!?
Alone if my first point is solved, I’d be thankful.
Kind regards, inspirationally.
- You must be logged in to reply to this topic.