前提・実現したいこと
このページを参考に、Composerを使ってOpenSocialをインストールしようとしています。
こちらからダウンロードしたものを使って
インストール中のdrushコマンド実行し、以下のエラーメッセージが発生しました。
# composer create-project goalgorilla/social_template:dev-master drupal --no-interaction # drush site-install social --db-url=mysql://root:root@localhost:3306/social
発生している問題・エラーメッセージ
[root@v133-18-31-5 drupal3]# drush -y site-install social --db-url=mysql://root: root@localhost:3306/social // You are about to DROP all tables in your 'social' database. Do you want to // continue?: yes. [notice] Starting Drupal installation. This takes a while. In SqlContentEntityStorage.php line 1611: Exception thrown while performing a schema update. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syn tax to use near 'groups ( `id` INT unsigned NOT NULL auto_increment, `type` VARCHAR(32) CHARACTE' at line 1: CREATE TABLE {groups} ( `id` INT unsigned NOT NULL auto_increment, `type` VARCHAR(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL CO MMENT 'The ID of the target entity.', `uuid` VARCHAR(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL, `langcode` VARCHAR(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NUL L, PRIMARY KEY (`id`), UNIQUE KEY `group_field__uuid__value` (`uuid`), INDEX `group_field__type__target_id` (`type`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8mb4 COMMENT 'The base table for group entities.'; Array ( ) In Connection.php line 692: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i n your SQL syntax; check the manual that corresponds to your MySQL server v ersion for the right syntax to use near 'groups ( `id` INT unsigned NOT NULL auto_increment, `type` VARCHAR(32) CHARACTE' at line 1: CREATE TABLE {groups} ( `id` INT unsigned NOT NULL auto_increment, `type` VARCHAR(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL CO MMENT 'The ID of the target entity.', `uuid` VARCHAR(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL, `langcode` VARCHAR(12) CHARACTER SET ascii COLLATE ascii_general_ci NOT NUL L, PRIMARY KEY (`id`), UNIQUE KEY `group_field__uuid__value` (`uuid`), INDEX `group_field__type__target_id` (`type`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8mb4 COMMENT 'The base table for group entities.'; Array ( ) In Statement.php line 59: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i n your SQL syntax; check the manual that corresponds to your MySQL server v ersion for the right syntax to use near 'groups ( `id` INT unsigned NOT NULL auto_increment, `type` VARCHAR(32) CHARACTE' at line 1 site:install [--db-url DB-URL] [--db-prefix DB-PREFIX] [--db-su DB-SU] [--db-su-pw DB-SU-PW] [--account-name [ACCOUNT-NAME]] [--account-mail [ACCOUNT-MAIL]] [--site-mail [SITE-MAIL]] [--account-pass ACCOUNT-PASS] [--locale [LOCALE]] [--site-name [SITE-NAME]] [--site-pass SITE-PASS] [--sites-subdir SITES-SUBDIR] [--config-dir CONFIG-DIR] [--existing-config] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-d|--debug] [-y|--yes] [--no] [--remote-host REMOTE-HOST] [--remote-user REMOTE-USER] [-r|--root ROOT] [-l|--uri URI] [--simulate] [--pipe] [-D|--define DEFINE] [--druplicon] [--notify [NOTIFY]] [--xh-link XH-LINK] [--] <command> [<profile>]...
試したこと
こちらを参考にエラー解消を試みようと、MySQL5系にダウングレードしようとして方法が見つかりません。
補足情報(FW/ツールのバージョンなど)
CentOS7
MySQL8
回答1件
あなたの回答
tips
プレビュー