Nextclound 16 and MySQL 8.0.16

hrolofs · May 5, 2019, 8:26pm

Hello,

i try to install Nextcloud and MySQL with docker. Both are the latest versions.

I got an error during the installation when nextcloud try to create the database tables.

Error while trying to create admin user: An exception occurred while executing ‘CREATE TABLE groups (gid VARCHAR(64) DEFAULT ‘’ NOT NULL, PRIMARY KEY(gid)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ENGINE = InnoDB ROW_FORMAT = compressed’: 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 syntax to use near ‘groups (gid VARCHAR(64) DEFAULT ‘’ NOT NULL, PRIMARY KEY(gid)) DEFAULT CHARACTER’ at line 1

I think the reason behind is that with MySQL 8.0.2 GROUPS is now a reserverd word and cannot used as table name without quoting.

https://dev.mysql.com/doc/refman/8.0/en/keywords.html

Regards, Henry

kesselb · June 21, 2019, 7:43pm

As workaround until some fix is available set NEXTCLOUD_TABLE_PREFIX to oc_ or something non empty.

github.com

nextcloud/docker/blob/df048873ab32ed3dc226bef48c0c22e3590c7386/16.0/apache/config/autoconfig.php#L26


} elseif (getenv('POSTGRES_DB') && getenv('POSTGRES_USER') && getenv('POSTGRES_PASSWORD') && getenv('POSTGRES_HOST')) {
    $AUTOCONFIG["dbtype"] = "pgsql";
    $AUTOCONFIG["dbname"] = getenv('POSTGRES_DB');
    $AUTOCONFIG["dbuser"] = getenv('POSTGRES_USER');
    $AUTOCONFIG["dbpass"] = getenv('POSTGRES_PASSWORD');
    $AUTOCONFIG["dbhost"] = getenv('POSTGRES_HOST');
    $autoconfig_enabled = true;
}


if ($autoconfig_enabled) {
    $AUTOCONFIG["dbtableprefix"] = getenv('NEXTCLOUD_TABLE_PREFIX') ?: "";


    $AUTOCONFIG["directory"] = getenv('NEXTCLOUD_DATA_DIR') ?: "/var/www/html/data";
}