Announcement

Collapse
No announcement yet.

mysql problem

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?

  • #2
    Can anyone help me?

    Comment


    • #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


      • #4
        How to check it?

        Comment


        • #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


          • #6
            MyISAM

            Comment


            • #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...
              X