Suite Troubles upgrading a big vB 3.8.4 Patch Level 2 to vB Suite 4.0.1
 

Hi!
I'm tring upgrade my forum http://www.softairmania.it/forum to vB 4 SUITE, that are the steps that I do:

• Backup of the original database and Rename to the test one
• Copy whole vB3 in the new test path
• Changing config.php file to new paths and new database settings and adding define('DISABLE_HOOKS', true); to disable all plugins
• Changing the setting table to point at test url and path
• Testing the vB3 test forum
• From Admin CP create a new default style and setting it as default one
• Manual disabling all plugins and products (just to be sure)
• Overwrite ALL existing files with the vB4.0.1 suite one
• Running the UPGRADE procedure

All goes well but during the upgrade procedure I got an error in Step 2) Misc Table Alterations (2/3) (Step 2 of 13):

Attachment 41633

Step 2) Misc Table Alterations (2/3)

• Altering subscribegroup Table (1 of 1)
• Altering forum Table (1 of 1)
• Altering thread Table (1 of 2)
• Altering thread Table (2 of 2)
• Altering tachyforumpost Table (1 of 1)
• Altering tachythreadpost Table (1 of 1)
• Altering style Table (1 of 1)
• Altering template Table (1 of 1)
• Creating templatemerge table
• Altering tag Table (1 of 1)
• Creating index canonicaltagid on tag
• Updating phrasetype table
• Creating contenttype table

Code:
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 'xxx.contenttype' (errno: 121)
Error Number : 1005
Request Date : Thursday, January 14th 2010 @ 03:43:44 AM
Error Date : Thursday, January 14th 2010 @ 03:43:45 AM
Script : http://xxx/install/upgrade_400a1.php?step=2
Referrer : http://xxx/install/upgrade_400a1.php?step=2
IP Address : xxx
Username :
Classname : vB_Database
MySQL Version : 5.1.42


I retried all procedure more than one but I got always that error, than I tried to run the query by phpmyadmin and I got: #1005 - Can't create table 'xxx.contenttype' (errno: 121)

I noticed ENGINE=InnoDB in the query than I tried to remove it and try again, it goes.
To be sure that my MySQL server support InnoDB in my test databases I run the following query:
Code:
CREATE TABLE `xxx`.`innodb_table` (
`test` INT NOT NULL
) ENGINE = INNODB;
And it goes, I've that table created in my database.

Than I checked my forum test user auth and it have: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE
It can create tables...

Server infos:
PHP 5.2.12
mysql 5.1.42

What's up?
What must I do?
Have I do semthing wronge?
Suggests?

Thank's

Best regards
Attached Images

• http://vb.ma7room.com/jpg.gif dberror.jpg‎ (60.8 KB)