CSV-import error


#1

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


#2

What version of MySQL are you using? You can easily check on the System Information screen linked at the bottom of every admin page.

That’s a fairly surprising error message you’re getting, as the “utf8mb4” character set being complained about is widely used throughout Omeka S.


#3

Herewith I’m sending you the information:
MySQL
Server Version 5.1.69-log
Client Version mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
Mode


#4

That version of MySQL is significantly too old to run Omeka S.

I’m not sure how you got it installed in the first place.