Suite MySQL error while upgrading from 3.8.6 PL1 to 4.0.5

محروم.كوم · #1 08-01-2010, 11:00 AM

Hello,

Still trying to upgrade my forum from 3.8.6 to 4.0.5, I made a copy of the database and of the forum files to another directory, to avoid the destruction of my production forum.

I erased the customised styles, created a new Default Style and deleted the "old" one. I also disabled all mods by adding the magic phrase in config.php.

After uploading files in the directory, I launched the upgrading procedure, and at step 2 I got this error : Quote:
Database error in vBulletin 3.8.6:

Invalid SQL:
CREATE TABLE vb_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 './testupgradev4/vb_contenttype.frm' (errno: 121)
Error Number : 1005
Request Date : Sunday, August 1st 2010 @ 08:23:26 AM
Error Date : Sunday, August 1st 2010 @ 08:23:29 AM
Script : http://www.baldursgateworld.fr/testu...0a1.php?step=2
Referrer : http://www.baldursgateworld.fr/testu...0a1.php?step=1
IP Address : 92.157.142.105
Username :
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch4-log

Dunno why the first table was able to be created : Quote:
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 vb_templatemerge table

Updating vb_adminmessage table

Updating vb_adminmessage table

Updating vb_adminmessage table

Altering tag Table (1 of 1)

Creating index canonicaltagid on vb_tag

Updating vb_phrasetype table

Creating vb_contenttype table

Database error

Did I do something wrong ? Forgot something ?

After consulting some documentation about MySQL, it seems to be a foreign key problem, but I'm not sure... this ? Quote:
contenttypeid INT UNSIGNED NOT NULL AUTO_INCREMENT,

Thanks for your help __DEFINE_LIKE_SHARE__