Bugs in Impex-Module for Phorum5
Last weekend we converted a Phorum5 installation to vB.
Phorum version: 5.1.23
vBulletin & impex: newest versions from customer section
The impex module for phorum5 has the following bugs:
Wrong table name
The table names for Private Messages in Phorum5 have changed. This causes an Error during import: phorum_private_messages NOT found.
Fix: change the Import-Modul ../impex/systems/phorum5/000.php
Line 50: 'banlists', 'files', 'forum_group_xref', 'forums', 'groups', 'messages', 'pm_messages', 'settings', 'subscribers',
Lines 178 to 181: SELECT * FROM " .
$tableprefix."pm_messages
ORDER BY pm_message_id
LIMIT " .
Line 192: $return_array["$detail[pm_message_id]"] = $detail;
All threads and posts lost their author's user id
Thus, the Name of the Author was shown but there was no link to him. Also the post count was wrong.
Fix:
Run the following SQL-Queries
UPDATE vb3_user,vb3_thread SET vb3_thread.postuserid=vb3_user.userid WHERE vb3_thread.postusername=vb3_user.username;
UPDATE vb3_user,vb3_post SET vb3_post.userid=vb3_user.userid WHERE vb3_post.username=vb3_user.username
Now, all posts and threads were matched. Except those were the original author was deleted. But that's okay.
Old tree structure not converted
Phorum5 uses a tree-structure similar to the tree view in vB. During the conversion, the old tree structure was not imported. I'm not sure if this happened for all or only for some threads
Not fixed, because this is less important.
|