Skip to content

Could not create table ha_user_services #51

@biz87

Description

@biz87

Сообщение об ошибке / Error message

Резюме / Summary

ENGINE=InnoDB
FULLTEXT INDEX extended
The used table type doesn't support FULLTEXT indexes

Full sql text

Could not create table `***_ha_user_services` SQL: CREATE TABLE `modx_dS4_ha_user_services` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT, `internalKey` INT(10) unsigned NOT NULL, `identifier` VARCHAR(100) NOT NULL, `provider` VARCHAR(50) NOT NULL, `createdon` DATETIME NULL, `websiteurl` VARCHAR(255) NULL, `profileurl` VARCHAR(255) NULL, `photourl` VARCHAR(255) NULL, `displayname` VARCHAR(100) NULL, `description` TEXT NULL, `firstname` VARCHAR(100) NULL, `lastname` VARCHAR(100) NULL, `gender` VARCHAR(50) NULL, `language` VARCHAR(50) NULL, `age` TINYINT(3) NULL, `birthday` TINYINT(2) NULL, `birthmonth` TINYINT(2) NULL, `birthyear` SMALLINT(4) NULL, `email` VARCHAR(100) NULL, `emailverified` VARCHAR(100) NULL, `phone` VARCHAR(100) NULL, `address` VARCHAR(255) NULL, `country` VARCHAR(100) NULL, `region` VARCHAR(100) NULL, `city` VARCHAR(100) NULL, `zip` VARCHAR(25) NULL, `extended` TEXT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `unique_fields` (`internalKey`,`provider`), FULLTEXT INDEX `extended` (`extended`)) ENGINE=InnoDB ERROR: Array ( [0] => HY000 [1] => 1214 [2] => The used table type doesn't support FULLTEXT indexes )

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions