hello admins,
we upgraded our Omeka-S instance to version 3.2 and now we get following error if we try to add a media file via upload to an item:
Laminas\Db\Adapter\Exception\InvalidQueryException
Statement could not be executed (42000 - 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 '“log” (“created”,“severity”,“message”,“owner_id”,“context”) VALUES ('2022-04-27 ’ at line 1)
Details:
PDOException: 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 '“log” (“created”,“severity”,“message”,“owner_id”,“context”) VALUES ('2022-04-27 ’ at line 1 in /var/www/html/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Statement.php:238 Stack trace: #0 /var/www/html/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Statement.php(238): PDOStatement->execute()
…
The same happens using the REST-API
curl -F 'file[0]=@tts-ayd-0029.txt' -F 'data={"o:ingester": "upload", "file_index": 0,"o:label"' "text.txt", "o:item": {"o:id": 60}}' 'https://foo.org/api/media?key_identity=xxx&key_credential=xxx'
…
Laminas\Db\Adapter\Exception\InvalidQueryException
Statement could not be executed (42000 - 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
'"log" ("created","severity","message","owner_id","context") VALUES ('2022-04-27 ' at line 1)
Details:
PDOException: 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 ri
ght syntax to use near '"log" ("created","severity","message","owner_id","context") VALUES ('2022-04-27 '
at line 1 in /var/www/html/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Statement.php:238
...
Our configuration:
System information
Omeka S
Version 3.2.0
PHP
Version 7.4.27
SAPI apache2handler
Memory Limit 64M
POST Size Limit 64M
File Upload Limit 64M
Garbage Collection Yes
Extensions apache2handler, Core, ctype, curl, date, dom, fileinfo, filter, ftp, gd, hash, iconv, json, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, session, SimpleXML, sodium, SPL, sqlite3, standard, tokenizer, xml, xmlreader, xmlwriter, zlib
MySQL
Server Version 5.7.36
Client Version mysqlnd 7.4.27
Mode ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION
OS
Version Linux 3.10.0-1160.59.1.el7.x86_64 x86_64
Have you an ideas?
best regards,
Andre