Dear all,
I have the following error message when I install CSV import:
Omeka S is een fout tegengekomen
Doctrine\DBAL\Exception\DriverException
An exception occurred while executing ‘CREATE TABLE csvimport_import ( id INT AUTO_INCREMENT NOT NULL, job_id INT NOT NULL, undo_job_id INT DEFAULT NULL, comment VARCHAR(255) DEFAULT NULL, resource_type VARCHAR(255) NOT NULL, has_err TINYINT(1) NOT NULL, stats LONGTEXT NOT NULL COMMENT ‘(DC2Type:json_array)’, UNIQUE INDEX UNIQ_17B50881BE04EA9 (job_id), UNIQUE INDEX UNIQ_17B508814C276F75 (undo_job_id), PRIMARY KEY(id) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB’: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: ‘utf8mb4’
Details:
exception ‘PDOException’ with message ‘SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: ‘utf8mb4’’ in …/releases/20190118102856/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:57
Stack trace:
Next exception ‘Doctrine\DBAL\Driver\PDOException’ with message ‘SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: ‘utf8mb4’’ in …/releases/20190118102856/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:59
Stack trace:
Next exception ‘Doctrine\DBAL\Exception\DriverException’ with message 'An exception occurred while executing ‘CREATE TABLE csvimport_import (
id INT AUTO_INCREMENT NOT NULL,
job_id INT NOT NULL,
undo_job_id INT DEFAULT NULL,
comment VARCHAR(255) DEFAULT NULL,
resource_type VARCHAR(255) NOT NULL,
has_err TINYINT(1) NOT NULL,
stats LONGTEXT NOT NULL COMMENT ‘(DC2Type:json_array)’,
UNIQUE INDEX UNIQ_17B50881BE04EA9 (job_id),
UNIQUE INDEX UNIQ_17B508814C276F75 (undo_job_id),
PRIMARY KEY(id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB’:
SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: ‘utf8mb4’’ in …/releases/20190118102856/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115
Stack trace:
Thank you in advance,
Sophie