#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2015
    Posts
    1
    Rep Power
    0

    Unhappy Help me sql issue


    when i import my sql table i show this error
    #1214 - The used table type doesn't support FULLTEXT indexes
  2. #2
  3. No Profile Picture
    Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2014
    Posts
    21
    Rep Power
    0
    Hey mrumaraziz, welcome to the forums. Without knowing what database software you're running I'm going to go out on a limb and guess that you're importing a with the wrong database engine. For FULLTEXT indexes you'll need to either be running an MyISAM engine for the table, or at least I know thats the case with MySQL. The other option if you're using a version of MySQL newer than 5.6 you can run FULLTEXT indexes with innodb. Hope that helps point you in the right direction.

    Comments on this post

    • Will-O-The-Wisp agrees

IMN logo majestic logo threadwatch logo seochat tools logo