Error when creating/editing items and set, Omeka S 1.4

I’m having new item and creating new item set issues now too. I haven’t uploaded/created item sets in a few months. Everything was working nicely.

Today, I was unable to create an item set with a “Title”. However, i was able to create an item-set with NO TITLE… (“[untitled]”. Anytime i tried to create an item set with a title, it would trigger “Omeka S encountered an error”.

Since i could create an untitled item set, i then tried to edit the title… but it wouldn’t allow me and trigger " Omeka S encountered an error" again.

I will say i have not updated omeka s because the new updates did not have a domain manager module that i liked using.

Any idea how to fix this?

@pafa You’re having the same problem for both items and sets, or just sets?

We can’t really assist more until you follow the instructions linked on those “encountered an error” pages about getting the error details.

Hi @jflatnes

Sorry about that. i needed to turn “development” mode on. Yes, i’m getting items and item set errors. here is the error i’m getting when i try to create a new ITEM SET

Doctrine\DBAL\Exception\SyntaxErrorException
An exception occurred while executing ‘INSERT INTO value (type, lang, value, uri, is_public, resource_id, property_id, value_resource_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)’ with params [“literal”, null, “test”, null, 1, 119214, “1”, null]: 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 ‘value (type, lang, value, uri, is_public, resource_id, property_id, value_res…’ 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 ‘value (type, lang, value, uri, is_public, resource_id, property_id, value_res…’ at line 1 in /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105 Stack trace: #0 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(105): PDOStatement->execute(NULL) #1 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(168): Doctrine\DBAL\Driver\PDOStatement->execute(NULL) #2 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement->execute() #3 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1014): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts() #4 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata)) #5 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork->commit(NULL) #6 /home/pafaarch/public_html/application/src/Api/Adapter/AbstractEntityAdapter.php(277): Doctrine\ORM\EntityManager->flush() #7 /home/pafaarch/public_html/application/src/Api/Manager.php(224): Omeka\Api\Adapter\AbstractEntityAdapter->create(Object(Omeka\Api\Request)) #8 /home/pafaarch/public_html/application/src/Api/Manager.php(78): Omeka\Api\Manager->execute(Object(Omeka\Api\Request)) #9 /home/pafaarch/public_html/application/src/Mvc/Controller/Plugin/Api.php(99): Omeka\Api\Manager->create(‘item_sets’, Array, Array, Array) #10 /home/pafaarch/public_html/application/src/Controller/Admin/ItemSetController.php(28): Omeka\Mvc\Controller\Plugin\Api->create(‘item_sets’, Array) #11 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(78): Omeka\Controller\Admin\ItemSetController->addAction() #12 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent)) #13 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure)) #14 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(104): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent)) #15 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response)) #16 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent)) #17 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure)) #18 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent)) #19 /home/pafaarch/public_html/index.php(21): Zend\Mvc\Application->run() #20 {main} Next Doctrine\DBAL\Driver\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 ‘value (type, lang, value, uri, is_public, resource_id, property_id, value_res…’ at line 1 in /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107 Stack trace: #0 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(168): Doctrine\DBAL\Driver\PDOStatement->execute(NULL) #1 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement->execute() #2 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1014): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts() #3 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata)) #4 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork->commit(NULL) #5 /home/pafaarch/public_html/application/src/Api/Adapter/AbstractEntityAdapter.php(277): Doctrine\ORM\EntityManager->flush() #6 /home/pafaarch/public_html/application/src/Api/Manager.php(224): Omeka\Api\Adapter\AbstractEntityAdapter->create(Object(Omeka\Api\Request)) #7 /home/pafaarch/public_html/application/src/Api/Manager.php(78): Omeka\Api\Manager->execute(Object(Omeka\Api\Request)) #8 /home/pafaarch/public_html/application/src/Mvc/Controller/Plugin/Api.php(99): Omeka\Api\Manager->create(‘item_sets’, Array, Array, Array) #9 /home/pafaarch/public_html/application/src/Controller/Admin/ItemSetController.php(28): Omeka\Mvc\Controller\Plugin\Api->create(‘item_sets’, Array) #10 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(78): Omeka\Controller\Admin\ItemSetController->addAction() #11 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent)) #12 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure)) #13 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(104): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent)) #14 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response)) #15 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent)) #16 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure)) #17 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent)) #18 /home/pafaarch/public_html/index.php(21): Zend\Mvc\Application->run() #19 {main} Next Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing ‘INSERT INTO value (type, lang, value, uri, is_public, resource_id, property_id, value_resource_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)’ with params [“literal”, null, “test”, null, 1, 119214, “1”, null]: 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 ‘value (type, lang, value, uri, is_public, resource_id, property_id, value_res…’ at line 1 in /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:90 Stack trace: #0 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDOException)) #1 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(177): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘INSERT INTO val…’, Array) #2 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement->execute() #3 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1014): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts() #4 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata)) #5 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork->commit(NULL) #6 /home/pafaarch/public_html/application/src/Api/Adapter/AbstractEntityAdapter.php(277): Doctrine\ORM\EntityManager->flush() #7 /home/pafaarch/public_html/application/src/Api/Manager.php(224): Omeka\Api\Adapter\AbstractEntityAdapter->create(Object(Omeka\Api\Request)) #8 /home/pafaarch/public_html/application/src/Api/Manager.php(78): Omeka\Api\Manager->execute(Object(Omeka\Api\Request)) #9 /home/pafaarch/public_html/application/src/Mvc/Controller/Plugin/Api.php(99): Omeka\Api\Manager->create(‘item_sets’, Array, Array, Array) #10 /home/pafaarch/public_html/application/src/Controller/Admin/ItemSetController.php(28): Omeka\Mvc\Controller\Plugin\Api->create(‘item_sets’, Array) #11 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(78): Omeka\Controller\Admin\ItemSetController->addAction() #12 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent)) #13 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure)) #14 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(104): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent)) #15 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response)) #16 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent)) #17 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure)) #18 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent)) #19 /home/pafaarch/public_html/index.php(21): Zend\Mvc\Application->run() #20 {main}

Here is the error for ITEMS
Doctrine\DBAL\Exception\SyntaxErrorException
An exception occurred while executing ‘INSERT INTO value (type, lang, value, uri, is_public, resource_id, property_id, value_resource_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)’ with params [“literal”, null, “testsdf”, null, 1, 119215, “1”, null]: 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 ‘value (type, lang, value, uri, is_public, resource_id, property_id, value_res…’ 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 ‘value (type, lang, value, uri, is_public, resource_id, property_id, value_res…’ at line 1 in /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105

Stack trace:

#0 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(105): PDOStatement->execute(NULL)

#1 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(168): Doctrine\DBAL\Driver\PDOStatement->execute(NULL)

#2 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement->execute()

#3 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1014): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()

#4 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))

#5 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork->commit(NULL)

#6 /home/pafaarch/public_html/application/src/Api/Adapter/AbstractEntityAdapter.php(277): Doctrine\ORM\EntityManager->flush()

#7 /home/pafaarch/public_html/application/src/Api/Manager.php(224): Omeka\Api\Adapter\AbstractEntityAdapter->create(Object(Omeka\Api\Request))

#8 /home/pafaarch/public_html/application/src/Api/Manager.php(78): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))

#9 /home/pafaarch/public_html/application/src/Mvc/Controller/Plugin/Api.php(99): Omeka\Api\Manager->create(‘items’, Array, Array, Array)

#10 /home/pafaarch/public_html/application/src/Controller/Admin/ItemController.php(204): Omeka\Mvc\Controller\Plugin\Api->create(‘items’, Array, Array)

#11 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(78): Omeka\Controller\Admin\ItemController->addAction()

#12 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))

#13 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))

#14 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(104): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))

#15 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))

#16 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))

#17 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))

#18 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))

#19 /home/pafaarch/public_html/index.php(21): Zend\Mvc\Application->run()

#20 {main}

Next Doctrine\DBAL\Driver\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 ‘value (type, lang, value, uri, is_public, resource_id, property_id, value_res…’ at line 1 in /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107

Stack trace:

#0 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(168): Doctrine\DBAL\Driver\PDOStatement->execute(NULL)

#1 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement->execute()

#2 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1014): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()

#3 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))

#4 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork->commit(NULL)

#5 /home/pafaarch/public_html/application/src/Api/Adapter/AbstractEntityAdapter.php(277): Doctrine\ORM\EntityManager->flush()

#6 /home/pafaarch/public_html/application/src/Api/Manager.php(224): Omeka\Api\Adapter\AbstractEntityAdapter->create(Object(Omeka\Api\Request))

#7 /home/pafaarch/public_html/application/src/Api/Manager.php(78): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))

#8 /home/pafaarch/public_html/application/src/Mvc/Controller/Plugin/Api.php(99): Omeka\Api\Manager->create(‘items’, Array, Array, Array)

#9 /home/pafaarch/public_html/application/src/Controller/Admin/ItemController.php(204): Omeka\Mvc\Controller\Plugin\Api->create(‘items’, Array, Array)

#10 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(78): Omeka\Controller\Admin\ItemController->addAction()

#11 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))

#12 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))

#13 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(104): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))

#14 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))

#15 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))

#16 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))

#17 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))

#18 /home/pafaarch/public_html/index.php(21): Zend\Mvc\Application->run()

#19 {main}

Next Doctrine\DBAL\Exception\SyntaxErrorException: An exception occurred while executing ‘INSERT INTO value (type, lang, value, uri, is_public, resource_id, property_id, value_resource_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)’ with params [“literal”, null, “testsdf”, null, 1, 119215, “1”, null]:

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 ‘value (type, lang, value, uri, is_public, resource_id, property_id, value_res…’ at line 1 in /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:90

Stack trace:

#0 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDOException))

#1 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(177): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘INSERT INTO val…’, Array)

#2 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement->execute()

#3 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1014): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()

#4 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))

#5 /home/pafaarch/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork->commit(NULL)

#6 /home/pafaarch/public_html/application/src/Api/Adapter/AbstractEntityAdapter.php(277): Doctrine\ORM\EntityManager->flush()

#7 /home/pafaarch/public_html/application/src/Api/Manager.php(224): Omeka\Api\Adapter\AbstractEntityAdapter->create(Object(Omeka\Api\Request))

#8 /home/pafaarch/public_html/application/src/Api/Manager.php(78): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))

#9 /home/pafaarch/public_html/application/src/Mvc/Controller/Plugin/Api.php(99): Omeka\Api\Manager->create(‘items’, Array, Array, Array)

#10 /home/pafaarch/public_html/application/src/Controller/Admin/ItemController.php(204): Omeka\Mvc\Controller\Plugin\Api->create(‘items’, Array, Array)

#11 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(78): Omeka\Controller\Admin\ItemController->addAction()

#12 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))

#13 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))

#14 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(104): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))

#15 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))

#16 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))

#17 /home/pafaarch/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))

#18 /home/pafaarch/public_html/vendor/zendframework/zend-mvc/src/Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))

#19 /home/pafaarch/public_html/index.php(21): Zend\Mvc\Application->run()

#20 {main}

@pafa, thanks. I’m sure now it’s not the same issue you’re having as @LisaH was. I may split off this thread to keep things separate.

You said you weren’t up to date: how old of an Omeka S version are we talking about here? The issue your log shows is an incompatibility with newer MariaDB installs in particular, and it’s something we fixed way back in Omeka S 2.0.1 in 2019. So do you have an older version than that?

@jflatnes

Yes, i have a very old version, 1.4.0. I didn’t upgrade because the domain manager module was not being updated. I managed to use omeka s successfully for the past 3-4 years without issues.

I moved the thread.

What probably happened here is that you or your host updated MariaDB and you just now have a new enough version of it to hit this problem. We don’t really have a solution for you that doesn’t involve upgrading.

I’m not aware of too many modules that didn’t get updated between versions 1 and 2, are you sure the one you want has no updates?

I figured it was my host updating the DB. I noticed some changes but i haven’t been uploading/creating anything on omeka s for the past year. I reached out to the host to see what they can do.

Yes, the module was not continued. Omeka S - Domain Manager version 1.0. It was by University of Toronto Libraries. There is a SiteSlug but i don’t need that.

thanks for your help.

I believe this is that same Domain Manager module? It’s definitely been worked on past 1.0. But maybe I’m mistaken.