MySql error while installing VBulletin

Discussion in 'MySQL' started by netmaxin123, Jun 30, 2007.

0
  1. #1
    Hello Dear all,

    I am trying to install Vbulletin and I face following issue

    Invalid SQL:
    CREATE TABLE userfield (
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    temp MEDIUMTEXT NOT NULL DEFAULT '',
    field1 MEDIUMTEXT NOT NULL,
    field2 MEDIUMTEXT NOT NULL,
    field3 MEDIUMTEXT NOT NULL,
    field4 MEDIUMTEXT NOT NULL,
    PRIMARY KEY (userid)
    )

    mysql error: BLOB/TEXT column 'temp' can't have a default value

    mysql error number: 1101

    I am not at all Sql expert, I was running installation step and at step 3 i got this error when it was creating tables , can anybody please help me how to resolve this

    thanks in advance

    Regards,
    Netmaxin
     
    netmaxin123, Jun 30, 2007 IP
  2. SupernalMedia

    SupernalMedia Well-Known Member

    Messages:
    427
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    110
    #2
    Do you have a paid for version of vb or is this a cracked/modded version?
     
    SupernalMedia, Jul 1, 2007 IP
  3. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #3
    what mysql and vbuletin version you have?
     
    gibex, Jul 1, 2007 IP