Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Could not create table ha_user_services #51

Open
biz87 opened this issue May 15, 2023 · 0 comments
Open

Could not create table ha_user_services #51

biz87 opened this issue May 15, 2023 · 0 comments
Labels

Comments

@biz87
Copy link
Member

biz87 commented May 15, 2023

Сообщение об ошибке / 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 )
@biz87 biz87 added the bug label May 15, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant