[solved] Nextant scan issue: SQLSTATE[42000]: Syntax error or access violation

Hello,

when i would start the indexing i get this error:

``````  [    Doctrine\DBAL\Exception\DriverException]
An exception occurred while executing '
SELECT `fileid`, `storage`, `path`, `parent`, `name`,
`mimetype`, `storage_mtime`, `mimepart`, `size`, `mtime`,
`encrypted`, `etag`, `permissions`, `checksum`
FROM `oc_filecache`
WHERE `storage` = ? AND `name` COLLATE UTF8_general_ci LIKE ?' with params [3, "%%%"]:
SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'UTF8_general_ci' is not valid for CHARACTER SET 'utf8mb4'

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'UTF8_general_ci' is not valid for CHARACTER SET 'utf8mb4'

[PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'UTF8_general_ci' is not valid for CHARACTER SET 'utf8mb4'
``````

how can i solve it?

The issue was that the database tables have this format “utf8mb4” but it must be “uft8_general_ci”. I have edit the tables with phpmyadmin and all issues are solved.