Announcement

Collapse
No announcement yet.

Can not be a part of FULL text error

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

  • Apolo
    replied
    Found this very handy tip:

    Just to add to Thomas's good advice: And to sort things out in PHPMyAdmin you have to change the characterset for all columns AT THE SAME TIME.
    Just wasted half a day trying again and again to change the columns one at a time and continually getting the error message about the FULLTEXT index.
    Source: http://stackoverflow.com/questions/6...fulltext-index

    So you just click/select the specific table, select the fields/rows you want to modify and then click on "change". Then you can set the COLLATION for all of them at the same time and click on SAVE.

    That's it.

    Leave a comment:


  • JohorBahru
    replied
    Originally posted by Wayne Luke View Post
    Make sure the post table is a MyISAM table and not an INNODB table.
    my post table is a MyISAM table, yet still receiving this error
    Column 'pagetext' cannot be part of FULLTEXT index
    Last edited by JohorBahru; Thu 8 Jan '09, 5:55am.

    Leave a comment:


  • Wayne Luke
    replied
    Make sure the post table is a MyISAM table and not an INNODB table.

    Leave a comment:


  • Michael_Jim
    replied
    export the Database with MySQLDumper: http://www.mysqldumper.de/en/
    Import the Database with MySQLDumper as UTF-8

    Leave a comment:


  • shevko
    replied
    mmm how can fix this?

    Leave a comment:


  • Michael_Jim
    replied
    same here
    how can we fix this?

    Leave a comment:


  • lovevn
    started a topic Can not be a part of FULL text error

    Can not be a part of FULL text error

    When I tried to change some field of my database collation from latin 1 to utf8-general-ci via phpmyadmin, I got this error

    Code:
     
    SQL query: 
    ALTER TABLE `post` CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 
    MySQL said:  
    #1283 - Column 'pagetext' cannot be part of FULLTEXT index
    What does it mean? How can I change it?

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