Announcement

Collapse
No announcement yet.

Problems importing IPB 2.0

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problems importing IPB 2.0

    I am getting the following mysql error on 005 Import Forum:

    The mysql db is about 10.5megs. I have backed up and restored from the server it was on to ours after trying a server to server import where I got the error at the same place. Any input would be greatly appreciated.

    Database error in vBulletin:ImpEx Target 3.0.7:

    Invalid SQL:
    INSERT INTO forum
    (
    styleid, title, description,
    options, daysprune, displayorder,
    parentid, importforumid, importcategoryid
    )
    VALUES
    (
    '',
    'California',
    '',
    '89795',
    '30',
    '7',
    '-1',
    '0',
    '15'
    )

    mysql error: Duplicate entry '65535' for key 1

    mysql error number: 1062

    Date: Wednesday 27th of July 2005 12:40:55 PM
    Script: http://forums.naes.cc/impex/index.php
    Referer: http://forums.naes.cc/impex/index.php
    Username: administrator
    IP Address: 69.41.132.242

  • #2
    This is caused by the index running out of room.

    What was the state of your board before the import or do you have over 65535 forums ?
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      I am not very familiar with buliten boards in general, looking at the SQL Toolbox on IPB, it shows 414 next to forums, so I am assuming there are 414 forums on this IPB install.

      Under System overview it shows,
      Total Unique Topics: 1280
      Total Replies to Topics: 1753
      Total Members: 809

      Comment


      • #4
        Don't know if this will cause issues or not but the IPB is installed on a server with Mysql 4.1.8-Standard and vBulletin is installed on a server with cPanel and Mysql 4.0.24-standard. When i did the mysql dump from the server running 4.1.8 I used the mysqldump --opt -Q -u --compatible=mysql40 xxxx_xxxx -p xxxx_xxxx > /home/xxxx/xxxx/xxxx.sql hoping that that would work. But as I said in the previous post, its giving me the same error wether I try to import from the backup on my server or a import from a server to server transfer.

        Comment


        • #5
          I can see an issue with the size of the board or your mysqldump.

          Are you importing into a fresh vBulletin install ?
          I wrote ImpEx.

          Blog | Me

          Comment


          • #6
            Yes, just installed.

            Comment


            • #7
              Can you check your forum table in the vBulletin database and see how many entries there are ?
              I wrote ImpEx.

              Blog | Me

              Comment


              • #8
                Three entries

                Forumid 1, 2 and 65535

                Comment


                • #9
                  Then there must be an issue with the auto_inc column as the next forumid should of been 3.

                  What happens if you delete all the entries in that table and run the module ?
                  I wrote ImpEx.

                  Blog | Me

                  Comment


                  • #10
                    Okay, that worked for a little bit now I am getting this error:

                    Looks like 65478 entries: Showing rows 0 - 29 (65478 total

                    Database error in vBulletin:ImpEx Target 3.0.7:

                    Invalid SQL:
                    INSERT INTO forum
                    (
                    styleid, title, options,
                    displayorder, parentid, importforumid,
                    importcategoryid, description, replycount,
                    lastpost, lastposter, lastthread,
                    lastthreadid, lasticonid, threadcount,
                    daysprune, newpostemail, newthreademail,
                    parentlist, password, link, childlist
                    )
                    VALUES
                    (
                    '',
                    'Interrogatories',
                    '89799',
                    '64',
                    '65383',
                    '200',
                    '306',
                    '',
                    '',
                    '',
                    '',
                    '',
                    '',
                    '',
                    '',
                    '',
                    '',
                    '',
                    '',
                    '',
                    '',
                    ''
                    )

                    mysql error: Duplicate entry '65535' for key 1

                    mysql error number: 1062

                    Date: Wednesday 27th of July 2005 03:06:45 PM
                    Script: http://forums.naes.cc/impex/index.php
                    Referer: http://forums.naes.cc/impex/index.php
                    Username: administrator
                    IP Address: 69.41.132.242

                    Comment


                    • #11
                      Ok, then your forum table is full for some reason, when you are importing is it just constantly refreshing on the import forum page with the same forums untill it crashes ?
                      I wrote ImpEx.

                      Blog | Me

                      Comment


                      • #12
                        Yes, thats what it was doing, then it crashed.

                        Comment


                        • #13
                          Ok, clean out the database, start again.

                          When it asks for how many forums per page put in 500, so it dose them all in one page and see what happens ?
                          I wrote ImpEx.

                          Blog | Me

                          Comment


                          • #14
                            New Error:


                            Database error in vBulletin:ImpEx Target 3.0.7:

                            Invalid SQL: UPDATE forum SET parentid= WHERE forumid =732
                            mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE forumid =732' at line 1

                            mysql error number: 1064

                            Date: Wednesday 27th of July 2005 03:48:37 PM
                            Script: http://forums.naes.cc/impex/index.php
                            Referer: http://forums.naes.cc/impex/index.php
                            Username: administrator
                            IP Address: 69.41.132.242

                            Comment


                            • #15
                              What exact version are you importing from and what hacks do you have ?
                              I wrote ImpEx.

                              Blog | Me

                              Comment

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