mysql problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • extasa
    Senior Member
    • Mar 2008
    • 106
    • 3.6.x

    mysql problem

    During installation I receive such error:

    Code:
    Database error in vBulletin :
    
    Invalid SQL:
    
    CREATE TABLE post (
    	postid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    	threadid INT UNSIGNED NOT NULL DEFAULT '0',
    	parentid INT UNSIGNED NOT NULL DEFAULT '0',
    	username VARCHAR(100) NOT NULL DEFAULT '',
    	userid INT UNSIGNED NOT NULL DEFAULT '0',
    	title VARCHAR(250) NOT NULL DEFAULT '',
    	dateline INT UNSIGNED NOT NULL DEFAULT '0',
    	pagetext MEDIUMTEXT,
    	allowsmilie SMALLINT NOT NULL DEFAULT '0',
    	showsignature SMALLINT NOT NULL DEFAULT '0',
    	ipaddress CHAR(15) NOT NULL DEFAULT '',
    	iconid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    	visible SMALLINT NOT NULL DEFAULT '0',
    	attach SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    	infraction SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    	reportthreadid INT UNSIGNED NOT NULL DEFAULT '0',
    	PRIMARY KEY (postid),
    	KEY userid (userid),
    	KEY threadid (threadid, userid),
    	FULLTEXT KEY title (title, pagetext)
    ) ENGINE=MyISAM;
    
    MySQL Error   : Column 'title' cannot be part of FULLTEXT index
    Error Number  : 1283
    .
    .
    .
    .
    What can I do now?
  • extasa
    Senior Member
    • Mar 2008
    • 106
    • 3.6.x

    #2
    Can anyone help me?

    Comment

    • Steve Machol
      Former Customer Support Manager
      • Jul 2000
      • 154488

      #3
      What table type is your post table - MyISAM or InnoDB?
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment

      • extasa
        Senior Member
        • Mar 2008
        • 106
        • 3.6.x

        #4
        How to check it?

        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #5
          You can use phpMyAdmin to check it.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment

          • extasa
            Senior Member
            • Mar 2008
            • 106
            • 3.6.x

            #6
            MyISAM

            Comment

            • Steve Machol
              Former Customer Support Manager
              • Jul 2000
              • 154488

              #7
              That should work. However I don't understand how this could be a fresh install since installation does not created fulltext indexes. What are you doing exactly? And which version of MySQL are you running?
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...