Successfully impex'ed, but more counts than expected

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • briansol
    Senior Member
    • Apr 2006
    • 674
    • 3.6.x

    Successfully impex'ed, but more counts than expected

    MY board is up and running, and all is well, but I have ALMOST double posts and threads. I'm short about 20,000 or so to make it double, so it's not like I ran it twice.

    I shut my ipb board down with 667.xxx posts, and now i have 1,0xx,xxx posts showing in the footer.

    I ran the rebuild count tools on every option in the ACP.

    Any ideas?
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Honestly it sounds like you double-imported. Impex does not arbitrarily double your post count. I suggest you clear out the data and redo the import.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • briansol
      Senior Member
      • Apr 2006
      • 674
      • 3.6.x

      #3
      I would agree with you, but I don't SEE them anywhere in the forum display.

      If I imported twice, I SHOULD be seeing double threads and double posts, no?

      Everything looks normal, save for the counts.

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        Okay, but this still means the import was not done correctly, particularly if you followed all the instructions as you said.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • briansol
          Senior Member
          • Apr 2006
          • 674
          • 3.6.x

          #5
          edit, I just found some. It appears to show ALL in order, then the repeats (not by date as i would have expected).

          Can i just redo the topics and posts step?

          Comment

          • briansol
            Senior Member
            • Apr 2006
            • 674
            • 3.6.x

            #6
            to reply to my own question, i guess it can't be done.

            Starting over. 8 hours wasted damn big boards. lol

            Comment

            • briansol
              Senior Member
              • Apr 2006
              • 674
              • 3.6.x

              #7
              Well, i started from scratch, re-did the whole thing, manually checked the database, tables were truncated.

              And I got the exact same results.

              It's not me, something is wrong with the impex system.

              Comment

              • briansol
                Senior Member
                • Apr 2006
                • 674
                • 3.6.x

                #8
                iv'e narrowed it down.

                Posts that were moved on IPB with the option of "leave moved link in this thread" show up as double posts. if they were moved twice, it shows up 3 times.

                Comment

                • briansol
                  Senior Member
                  • Apr 2006
                  • 674
                  • 3.6.x

                  #9
                  And why did it create a new forum:

                  Order the forums found here.
                  This is a default category for forums that need ordering
                  Last edited by briansol; Fri 13 Jun '08, 8:38am.

                  Comment

                  • briansol
                    Senior Member
                    • Apr 2006
                    • 674
                    • 3.6.x

                    #10
                    ok, tons of threads with no first post id.

                    SELECT threadid
                    FROM `thread`
                    WHERE firstpostid = ""

                    36,971 results.

                    I'm going to manually delete those, and it should kill my dupe topics.

                    Deleted rows: 36971 (Query took 10.4355 sec)

                    voila, dupe threads are gone.
                    the posts still exist, at least in counts of the posts table, but i don't care. its just space, and that's cheap. but no dupes are showing, and that's important.

                    so, please look into this. Moved threads that leave the moved-to link, come in as real topics and create dupes.

                    Comment

                    • briansol
                      Senior Member
                      • Apr 2006
                      • 674
                      • 3.6.x

                      #11
                      SQL query: SELECT count( * )
                      FROM `post`
                      WHERE parentid =0

                      Results: 66202


                      what does the parentid field do? i can't find any documentation on it...

                      Comment

                      • Steve Machol
                        Former Customer Support Manager
                        • Jul 2000
                        • 154488

                        #12
                        Given all this, please report this in the 3.5 Bug Tracker here:

                        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                        Change CKEditor Colors to Match Style (for 4.1.4 and above)

                        Steve Machol Photography


                        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                        Comment

                        • briansol
                          Senior Member
                          • Apr 2006
                          • 674
                          • 3.6.x

                          #13
                          bug submitted.

                          any info on my last question about the parentid?

                          Comment

                          • Steve Machol
                            Former Customer Support Manager
                            • Jul 2000
                            • 154488

                            #14
                            No sorry, I don't know what the parentid is for nor do I know where that query came from.
                            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                            Change CKEditor Colors to Match Style (for 4.1.4 and above)

                            Steve Machol Photography


                            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                            Comment

                            • briansol
                              Senior Member
                              • Apr 2006
                              • 674
                              • 3.6.x

                              #15
                              That query came from me, trying to figure out how to get rid of these dupe posts. I think i've come up with somethign better though...

                              Code:
                              SELECT postid
                              FROM `post` 
                              where userid IN (select userid from user where username like 'imported_%')
                              (requires mysql 4.1+)

                              count: 85,751

                              still seems rather short... i was hoping for 450,000 ish...

                              I guess all the duplicate posts are NOT only from an imported_xxxxx username.

                              Comment

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