Database error when trying to upgrade.

[Oneback]

Trying to upgrade on my test server which is on my local computer with a WAMP configuration and on step one I get the following error:

Database error in vBulletin 3.6.8:

Invalid SQL:
CREATE TABLE socialgroup (
            groupid INT unsigned NOT NULL auto_increment,
            name VARCHAR(255) NOT NULL DEFAULT '',
            description TEXT NOT NULL DEFAULT '',
            creatoruserid INT unsigned NOT NULL DEFAULT '0',
            dateline INT unsigned NOT NULL DEFAULT '0',
            members INT unsigned NOT NULL DEFAULT '0',
            picturecount INT unsigned NOT NULL DEFAULT '0',
            lastpost INT unsigned NOT NULL DEFAULT '0',
            lastposter VARCHAR(255) NOT NULL DEFAULT '',
            lastposterid INT UNSIGNED NOT NULL DEFAULT '0',
            lastgmid INT UNSIGNED NOT NULL DEFAULT '0',
            visible INT UNSIGNED NOT NULL DEFAULT '0',
            deleted INT UNSIGNED NOT NULL DEFAULT '0',
            moderation INT UNSIGNED NOT NULL DEFAULT '0',
            PRIMARY KEY  (groupid),
            KEY creatoruserid (creatoruserid),
            KEY dateline (dateline),
            FULLTEXT KEY name (name, description)
        ) ENGINE=MyISAM;

MySQL Error  : BLOB/TEXT column 'description' can't have a default value
Error Number : 1101
Date         : Wednesday, December 19th 2007 @ 01:02:52 PM
Script       : http://localhost/forums/install/upgrade_370b2.php?step=1
Referrer     : http://localhost/forums/install/upgrade_370b2.php?rand=633
IP Address   : 127.0.0.1
Username     : 
Classname    : vB_Database

[Oneback]

Okay got this figured out, works now.

[thom81]

Okay got this figured out, works now.

Can you give me feedback about your solution?
I have the same problem in my test area...

Regards
thom

[thom81]

Look here: http://www.vbulletin.com/forum/proje...?issueid=24159

thom