PDA

View Full Version : Not all forums imported


dkendall
Wed 8th Mar '06, 11:38am
Importing from a Phorum 3.4.8 database using Impex 1.32. Not all forums are imported.

I added some trace code to 005.php and it appears the problem is that my Phorum forum ids are not sequential (i.e., they're 1,2,3,5,6,7,8,10,11), and the last two forums are skipped.

I tweaked get_phorum3_forum_step in 000.php to use the code below (rather than using $currentforumloop as the id in the select statement).

$sql = "SELECT id, table_name FROM ".$tableprefix."forums ORDER BY id";

$query_id = $Db_object->query($sql);
if(!$Db_object->data_seek($currentforumloop,$query_id))
return false;

$details_list = $Db_object->fetch_array($query_id);
$Db_object->free_result($query_id);
$Db_object->lastquery = $sql;

This seems to have solved the problem.

David

dkendall
Wed 8th Mar '06, 12:00pm
if(!$Db_object->data_seek($currentforumloop,$query_id))
return false;
Whoops... typo! That should be:

if(!$Db_object->data_seek($currentforumloop-1,$query_id))
return false;

David

Jerry
Wed 8th Mar '06, 5:19pm
Is that a complete replace for the function contents ?

I've not had that many Phorum 3.x sources to test with, so haven't seen a non sequential forum id count.

dkendall
Wed 8th Mar '06, 5:38pm
Here's the complete function (attached).

David

Jerry
Wed 8th Mar '06, 5:44pm
Thanks, any objections to that being used by us ? i.e. going into ImpEx.

dkendall
Wed 8th Mar '06, 5:53pm
Thanks, any objections to that being used by us ? i.e. going into ImpEx.

Not at all. Be my guest! (Assuming it really is correct, of course!)

I wonder if a similar issue is affecting my message body import?

David

Jerry
Wed 8th Mar '06, 6:25pm
The bodys of the posts are missing ??

dkendall
Wed 8th Mar '06, 6:48pm
That's correct. I posted about it here:

http://www.vbulletin.com/forum/showthread.php?t=178118

David