Assumptions / What you want to achieve
I'm trying to install OpenSocial using Composer with reference to this page.
https://www.getopensocial.com/blog/product-center/installing-open-social...

Using what you download from here
https://github.com/goalgorilla/social_template

Running the drush command during installation resulted in the following error message:

# composer create-project goalgorilla / social_template: dev-master drupal --no-interaction
# drush site-install social --db-url = mysql: // root: root @ localhost: 3306 / social
The problem / error message that is occurring

[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

Tried
If you try to resolve the error with reference to this, you cannot find a way to downgrade to MySQL5.
https://www.drupal.org/project/social/issues/3097481

Supplementary information (FW / tool version, etc.)
CentOS7
MySQL8

Comments

fantajista created an issue. See original summary.

fantajista’s picture

Issue summary: View changes
gisle’s picture

Assigned: fantajista » Unassigned
Category: Task » Support request
Status: Active » Fixed
Issue tags: -question, -Novice

Thanks for engaging with the community – there are quite a few channels for communication, so I'd like to help you find the right place to ask for help. Please visit http://drupal.org/support, where there is an overview of places where you can go for support.

In most cases, the Post installation forum is the first place to go to seek support for problems with your own website.

This issue queue is specifically for issues related to Drupal.org itself, not for other websites using Drupal, so I shall close this support request as "Fixed", since it got an answer.

PS:
Please do not assign tasks to yourself. Doing so means: "I am going to fix this - please do not interfere". As it unlikely that this is what you meant, I have unassigned you. Please do not add keywords to the "Issue tags" field unless you are familiar with their use. Before adding tags, read the issue tag guidelines. As a new community member, you may also want learn about Issue Queue Etiquette.

fantajista’s picture

Thank you for your advice.

apaderno’s picture

Title: 【CentOS】【Drupal】【OpenSocial】Install fails with "Syntax error" » Install fails with "Syntax error"
Component: User account » Other

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.