Hi, I’m running into an error when trying to use the “displace values” feature in bulk edit. I’m trying to displace dcterms:description to BIO:biography for an entire itemset, but trying to test it on a single item first. Does anyone have any fixes? Here is the error code I am encountering:
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 MariaDB server version for the right syntax to use near '“log” (“created”,“severity”,“message”,“owner_id”,“context”) VALUES (‘2022-01-…’ 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 MariaDB server version for the right syntax to use near '“log” (“created”,“severity”,“message”,“owner_id”,“context”) VALUES (‘2022-01-…’ at line 1 in /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Statement.php:238 Stack trace: #0 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Statement.php(238): PDOStatement->execute() #1 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-log/src/Writer/Db.php(128): Laminas\Db\Adapter\Driver\Pdo\Statement->execute(Array) #2 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-log/src/Writer/AbstractWriter.php(282): Laminas\Log\Writer\Db->doWrite(Array) #3 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-log/src/Logger.php(459): Laminas\Log\Writer\AbstractWriter->write(Array) #4 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-log/src/Logger.php(502): Laminas\Log\Logger->log(3, ‘PDOException: S…’, Array) #5 /home/u866347951/domains/craftarchive.ca/public_html/application/src/Mvc/ExceptionListener.php(54): Laminas\Log\Logger->err(‘PDOException: S…’) #6 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Omeka\Mvc\ExceptionListener->handleException(Object(Laminas\Mvc\MvcEvent)) #7 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent)) #8 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-mvc/src/DispatchListener.php(153): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent)) #9 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #10 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #11 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #12 /home/u866347951/domains/craftarchive.ca/public_html/index.php(21): Laminas\Mvc\Application->run() #13 {main} Next 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 MariaDB server version for the right syntax to use near '“log” (“created”,“severity”,“message”,“owner_id”,“context”) VALUES (‘2022-01-…’ at line 1) in /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Statement.php:243 Stack trace: #0 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-log/src/Writer/Db.php(128): Laminas\Db\Adapter\Driver\Pdo\Statement->execute(Array) #1 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-log/src/Writer/AbstractWriter.php(282): Laminas\Log\Writer\Db->doWrite(Array) #2 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-log/src/Logger.php(459): Laminas\Log\Writer\AbstractWriter->write(Array) #3 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-log/src/Logger.php(502): Laminas\Log\Logger->log(3, ‘PDOException: S…’, Array) #4 /home/u866347951/domains/craftarchive.ca/public_html/application/src/Mvc/ExceptionListener.php(54): Laminas\Log\Logger->err(‘PDOException: S…’) #5 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Omeka\Mvc\ExceptionListener->handleException(Object(Laminas\Mvc\MvcEvent)) #6 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent)) #7 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-mvc/src/DispatchListener.php(153): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent)) #8 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #9 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #10 /home/u866347951/domains/craftarchive.ca/public_html/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #11 /home/u866347951/domains/craftarchive.ca/public_html/index.php(21): Laminas\Mvc\Application->run() #12 {main}