Not all forums imported

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dkendall
    New Member
    • Mar 2006
    • 17
    • 3.5.x

    Not all forums imported

    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
    New Member
    • Mar 2006
    • 17
    • 3.5.x

    #2
    Originally posted by dkendall
    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

    Comment

    • Jerry
      Senior Member
      • Dec 2002
      • 9137
      • 1.1.x

      #3
      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.
      I wrote ImpEx.

      Blog | Me

      Comment

      • dkendall
        New Member
        • Mar 2006
        • 17
        • 3.5.x

        #4
        Here's the complete function (attached).

        David
        Attached Files

        Comment

        • Jerry
          Senior Member
          • Dec 2002
          • 9137
          • 1.1.x

          #5
          Thanks, any objections to that being used by us ? i.e. going into ImpEx.
          I wrote ImpEx.

          Blog | Me

          Comment

          • dkendall
            New Member
            • Mar 2006
            • 17
            • 3.5.x

            #6
            Originally posted by Jerry
            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

            Comment

            • Jerry
              Senior Member
              • Dec 2002
              • 9137
              • 1.1.x

              #7
              The bodys of the posts are missing ??
              I wrote ImpEx.

              Blog | Me

              Comment

              • dkendall
                New Member
                • Mar 2006
                • 17
                • 3.5.x

                #8
                That's correct. I posted about it here:



                David

                Comment

                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                Working...