Can not be a part of FULL text error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lovevn
    Senior Member
    • Sep 2004
    • 152

    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
  • Michael_Jim
    New Member
    • Jan 2007
    • 2
    • 3.6.x

    #2
    same here
    how can we fix this?

    Comment

    • shevko
      New Member
      • Jan 2008
      • 17
      • 3.6.x

      #3
      mmm how can fix this?

      Comment

      • Michael_Jim
        New Member
        • Jan 2007
        • 2
        • 3.6.x

        #4
        export the Database with MySQLDumper: http://www.mysqldumper.de/en/
        Import the Database with MySQLDumper as UTF-8

        Comment

        • Wayne Luke
          vBulletin Technical Support Lead
          • Aug 2000
          • 73979

          #5
          Make sure the post table is a MyISAM table and not an INNODB table.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API

          Comment

          • JohorBahru
            New Member
            • Jan 2009
            • 24

            #6
            Originally posted by Wayne Luke
            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.

            Comment

            • Apolo
              Member
              • Aug 2007
              • 33
              • 3.8.x

              #7
              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.
              ComunidadHosting ยท Web Hosting Forums

              Comment

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