[Suite] Upgrade Error: 3.8.4 pl2 to 4.0.1 Suite - mysql error

[Rik Brown]

I'm getting the following mysql error when attempting to upgrade from vb 3.8.4 pl2 to 4.0.1 suite. I might add that we have already upgraded one installment for another site on this same server. [Edit: However, the first upgrade was 4.0.0 (new) to 4.0.1, so not really a factor here except that the basic server requirements were already met].

Database error in vBulletin 3.8.4:

Invalid SQL:
CREATE TABLE contenttype (
            contenttypeid INT UNSIGNED NOT NULL AUTO_INCREMENT,
            class VARBINARY(50) NOT NULL,
            packageid INT UNSIGNED NOT NULL,
            canplace ENUM('0','1') DEFAULT  '0',
            cansearch ENUM('0','1') DEFAULT '0',
            cantag ENUM('0','1') DEFAULT '0',
            canattach ENUM('0','1') DEFAULT '0',
            isaggregator ENUM('0','1') NOT NULL DEFAULT '0',
            PRIMARY KEY (contenttypeid),
            UNIQUE KEY package (packageid, class)
        ) ENGINE=InnoDB;

MySQL Error   : Can't create table './forum/contenttype.frm' (errno: 121)
Error Number  : 1005
Request Date  : Wednesday, January 13th 2010 @ 03:01:01 PM
Error Date    : Wednesday, January 13th 2010 @ 03:01:04 PM
Script        : http://[domain].com/install/upgrade_400a1.php?step=2
Referrer      : http://[domain].com/install/upgrade_400a1.php?step=1
IP Address    : [removed]
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.22

This is my 2nd attempt starting from scratch (a restored db and cloned forum) stopping at the same point in the upgrade. I've tried flushing tables.

Any ideas what might be the problem?

Thanks. -- Rik

[RedFoxy]

same here: http://www.vbulletin.com/forum/showt...vB-Suite-4-0-1

[Rik Brown]

same here: http://www.vbulletin.com/forum/showt...vB-Suite-4-0-1

Like your thread, we are trying to upgrade a fairly large site with 800,000+ posts. -- Rik

[Rik Brown]

1) I got mysql errors (can't create table) at Step 2 (2/3) for the following tables:

tag
contenttype
tagcontent
searchcore
searchgroup
searchlog

I have another 4.0.1 installation on the same server and so I copied the "structure" (without the data) of those tables and the upgrade script could then move forward.

2) The next problem is at Step 12 where it adds post and thread table indexes. It runs for about 20 minutes and stops (I see via the unix top command almost nil mysql activity so I assume its either completed or hung). I move onto Step 13 and the process continues.

3) However, when I get to the completion of the script and am promted to login to the admincp for 4.0.1, I get a browser error indicating that there is a problem with the database and the admincp does not load.

I tried the following suggestions in the other thread referenced to above (message #2) dealing with this same problem:

- create a new database and restore a backup to that database
- restore your 3.8.4 files
- edit config.php to point to the new database
- user the Repair/Optimise tools within AdminCP > Maintenance
- ensure all plugins/products are uninstalled
- upload 4.0 files
- re-run upgrade

No differences. Always the same problems.

Any ideas what else I can do to get a flawless install?

Thanks. -- Rik

[Trevor Hannant]

Can you post the actual database errors please

[Rik Brown]

Can you post the actual database errors please

Trevor: Thank you for your reply. Below is the very first error that occurs (step 2):

Database error in vBulletin 3.8.4:

Invalid SQL:
ALTER TABLE tag ENGINE=InnoDB;

MySQL Error   : Error on rename of './forum4x/#sql-5fe3_173a6' to './forum4x/tag' (errno: 121)
Error Number  : 1025
Request Date  : Friday, January 15th 2010 @ 02:04:27 PM
Error Date    : Friday, January 15th 2010 @ 02:04:34 PM
Script        : http://[removed].com/install/upgrade_400a1.php?step=2
Referrer      : 
IP Address    : [removed]
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.22

Any ideas?

Thanks. -- Rik

[Trevor Hannant]

Can you raise a bug for that specific error please Rik, don't know why that should appear...

[Rik Brown]

Trevor: Submitted a bug report on this. Thanks. -- Rik

[clubplanet]

Any update on this bug, Rik? I have the same thing.

Thanks.

[Rik Brown]

I didn't make any further progress. I'm waiting for the next release which, as you know, has been delayed several times now and am hoping that will help.

If it doesn't fix the problems, I'm planning to go through the database creation steps defined in the script and do them manually to see if that will work. Another possibility is that I'll create a separate clean install without any data and then use the database tables created in that install for my upgrade databases (may have to load data manually into those tables).

It may help if you also confirm this bug (EDIT: click on the link in message #12 below by Trevor to confirm your instance of the bug).

I'll report here if I have any success working with the next release. Hope you will too.

Thanks. -- Rik

[mustang02]

I too am getting a similar error.

Database error in vBulletin 3.8.3:

Invalid SQL:
ALTER TABLE tag ENGINE=InnoDB;

MySQL Error : Error on rename of './forum/#sql-30ac_421e53' to './forum/tag' (errno: -1)
Error Number : 1025
Request Date : Friday, February 12th 2010 @ 07:38:12 AM
Error Date : Friday, February 12th 2010 @ 07:38:12 AM
Script : http://www.mywebsite.com/vb/install/...0a1.php?step=2
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 4.1.22-standard

It's corrupted my whole site so I can't do anything at all. Any ideas other than restoring to a previous database backup which will cost me money since my local copy is corrupted?

-Kirk

[Trevor Hannant]

Can you mark this bug as reproducable please:

http://www.vbulletin.com/forum/project.php?issueid=35406

[Rik Brown]

The bad news is that the 4.0.2 release did not fix any of the problems we had with the installation as defined above. We hit exactly the same err messages throughout. The good news is that we got the installation completed and the website is working as expected. Here is what we did:

1) tags table - We renamed this one table (as a backup) and copied a blank 4.0.2 version from our other site (you could just as well take the same table as part of a 4.0.2 test site). We lost our tags but will likely use a vb 4.x tagging mod we are already using from vbulletin.org rather than trying to re-import them.

2) We also took blank tables from our other 4.0.2 site for the the following tables for which we had the same type of errors on installation:

contenttype
tagcontent
searchcore
searchgroup
searchlog

That's basically it. We reran the problematic part of the installation process each time we encountered a problem with each of the files above until the process was fully completed without error.

After the site was working, we have been using several of the admincp/maintenance/update counters scripts to rebuild/renew the data to make sure everything is fine (which is a good step anyway with this large of an update).

Remember, we had no problem whatsoever with a brand new installation. The only problems we had were in upgrading from vb 3.8.4. I hope that the above helps anyone else with these same installment problems.

-- Rik

ps: Of course, we backed up all mysql/vb files before attempting the above. You should too!

[mustang02]

Rik, I also noticed that those tables were type InnoDB and not MyISAM. I did basically what you did. In PhpMyAdmin, I used the export table function,copying the create statement changing the InnoDB to MyISAM. Then I deleted the offending table and used the SQL function to create it again. PITA but worth the extra attention to get to 4.0 and not having a live forum inactive.

[Trevor Hannant]

Rik, it may be worth posting in the Bug Tracker and offering a dev the opportunity to have a look at your problem directly and in detail in case there's anything that needs done to the process.