Announcement

Collapse
No announcement yet.

Can not be a part of FULL text error

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

  • 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

  • #2
    same here
    how can we fix this?

    Comment


    • #3
      mmm how can fix this?

      Comment


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

        Comment


        • #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 - Full / Mobile
          Vote for your favorite feature requests and the bugs you want to see fixed.

          Comment


          • #6
            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 8th Jan '09, 6:55am.

            Comment


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