Announcement

Collapse
No announcement yet.

Upgrade from 4.2.0 to beta22 failed

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

  • Upgrade from 4.2.0 to beta22 failed

    Upgrade from vBulletin 4.2.0 Patch Level 3

    PHP Code:
    An error has occurred with your databasePlease contact vBulletin Support for assistance.

    Module500a1Step 1 Database Error:1005

    Can
    't create table 'anwarg8sinak.page' (errno: 121)

    Query:

                    CREATE TABLE page (
                      `pageid` int(10) unsigned NOT NULL AUTO_INCREMENT,
                      `parentid` int(10) unsigned NOT NULL,
                      `pagetemplateid` int(10) unsigned NOT NULL,
                      `title` varchar(200) NOT NULL,
                      `metakeywords` varchar(200) NOT NULL,
                      `metadescription` varchar(200) NOT NULL,
                      `urlprefix` varchar(200) NOT NULL,
                      `routeid` int(10) unsigned NOT NULL,
                      `moderatorid` int(10) unsigned NOT NULL,
                      `displayorder` int(11) NOT NULL,
                      `pagetype` enum('
    default','custom') NOT NULL DEFAULT 'custom',
                      PRIMARY KEY (`pageid`)
                    ) ENGINE = InnoDB 
    Last edited by anwar513; Fri 21 Dec '12, 4:37am. Reason: Upgrade from 4.1.2 to beta20 failed again

  • #2
    Errno 121 means a duplicate key error. Probably the table already exists in the InnoDB internal data dictionary. If you previously tried an upgrade then just restored the previous database back into the same database, this can happen.

    Try creating a new database, restore your backup to there and try again.
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...

    Comment


    • #3
      Thank you for your advice

      Comment


      • #4
        Upgrade process was very successful, but the following error
        1. signature not display
        2. Portion of the avatar does not show
        3. topics and posts display, but want to edit a topic and posts on empty
        4. All Attachments not displayed
        5. Admincp > Maintenance> General Update Tools and execute the "Rebuild Search Index" function The 500mb database becomes 900mb

        Comment


        • #5
          Wait three days my problem no one answered.

          Comment


          • #6
            The software is currently in beta, we do not recommend running vBulletin 5 on a live/production website, there are bound to be bugs.

            1. Does the little pen tip icon display in users posts?
            2. You'll have to be more specific or give us examples.
            3. This is a known bug at this time.
            4. As per 2, we'll need more info.
            5. This is normal.

            Comment


            • #7
              Thank you for your answer, I am also curious about the local test........
              1. yes users posts
              2.
              gif avatar does not show jpg avatar can be displayed
              3. Wait for the official release
              4. Attachments not displayed Such as Annex Address http://localhost/vb5sinak2/filedata/...7&d=1348734460
              5. Wait for the official release

              Comment

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