Hi!
I'm tring upgrade my forum http://www.softairmania.it/forum to vB 4 SUITE, that are the steps that I do:
All goes well but during the upgrade procedure I got an error in Step 2) Misc Table Alterations (2/3) (Step 2 of 13):
Step 2) Misc Table Alterations (2/3)
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:
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
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):
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:
[COLOR=#000000][FONT=Times New Roman][FONT=tahoma][B]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 '[/B][/FONT][/FONT][/COLOR][COLOR=#000000][FONT=Times New Roman][FONT=tahoma][B]xxx[/B][/FONT][/FONT][/COLOR][COLOR=#000000][FONT=Times New Roman][FONT=tahoma][B].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://[/B][/FONT][/FONT][/COLOR][COLOR=#000000][FONT=Times New Roman][FONT=tahoma][B]xxx[/B][/FONT][/FONT][/COLOR][COLOR=#000000][FONT=Times New Roman][FONT=tahoma][B]/install/upgrade_400a1.php?step=2 Referrer : http://[/B][/FONT][/FONT][/COLOR][COLOR=#000000][FONT=Times New Roman][FONT=tahoma][B]xxx[/B][/FONT][/FONT][/COLOR][COLOR=#000000][FONT=Times New Roman][FONT=tahoma][B]/install/upgrade_400a1.php?step=2 IP Address : xxx Username : Classname : vB_Database MySQL Version : 5.1.42[/B][/FONT][/FONT][/COLOR]
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;
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
Comment