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.

Please use the vBulletin.com forums to discuss ImpEx: http://www.vbulletin.com/forum/forumdisplay.php?f=92