Upgrade from 4.2.0 to beta22 failed

[anwar513]

Upgrade from vBulletin 4.2.0 Patch Level 3

An error has occurred with your database. Please contact vBulletin Support for assistance.

Module: 500a1, Step 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 

[Trevor Hannant]

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.

[anwar513]

Thank you for your advice

[anwar513]

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

[anwar513]

Wait three days my problem no one answered.

[Zachery]

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.

[anwar513]

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