Trouble Editing Tags in Omeka S ver 3.0.1

Patm · March 3, 2021, 8:00pm

We’re getting an error when trying to edit tags on our items.

Doctrine\ORM\Query\QueryException
[Semantical Error] line 0, col 67 near 'omeka_root omeka_0': Error: Class 'omeka_root' is not defined.
Details:
Doctrine\ORM\Query\QueryException: SELECT omeka_root FROM Folksonomy\Entity\Tag omeka_root INNER JOIN omeka_root omeka_0 WITH omeka_root.id = omeka_0.id WHERE omeka_0.name IN(:omeka_1) GROUP BY omeka_root.id ORDER BY omeka_root.id ASC in /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:43
Stack trace:
#0 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(492): Doctrine\ORM\Query\QueryException::dqlError('SELECT omeka_ro...')
#1 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(992): Doctrine\ORM\Query\Parser->semanticalError('line 0, col 67 ...', Array)
#2 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1735): Doctrine\ORM\Query\Parser->validateAbstractSchemaName('omeka_root')
#3 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1701): Doctrine\ORM\Query\Parser->RangeVariableDeclaration()
#4 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1597): Doctrine\ORM\Query\Parser->Join()
#5 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1320): Doctrine\ORM\Query\Parser->IdentificationVariableDeclaration()
#6 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(879): Doctrine\ORM\Query\Parser->FromClause()
#7 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(848): Doctrine\ORM\Query\Parser->SelectStatement()
#8 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(261): Doctrine\ORM\Query\Parser->QueryLanguage()
#9 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(360): Doctrine\ORM\Query\Parser->getAST()
#10 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Parser->parse()
#11 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(298): Doctrine\ORM\Query->_parse()
#12 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(992): Doctrine\ORM\Query->_doExecute()
#13 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(947): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#14 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(750): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#15 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(177): Doctrine\ORM\AbstractQuery->getResult(1)
#16 /srv/www/adhc/makers/application/src/Api/Adapter/AbstractEntityAdapter.php(299): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#17 /srv/www/adhc/makers/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#18 /srv/www/adhc/makers/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#19 /srv/www/adhc/makers/modules/Folksonomy/src/Mvc/Controller/Plugin/DeleteTags.php(62): Omeka\Api\Manager->search('tags', Array)
#20 /srv/www/adhc/makers/modules/Folksonomy/Module.php(794): Folksonomy\Mvc\Controller\Plugin\DeleteTags->__invoke(Object(Omeka\Entity\Item), Array)
#21 /srv/www/adhc/makers/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Folksonomy\Module->handleTagging(Object(Laminas\EventManager\Event))
#22 /srv/www/adhc/makers/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#23 /srv/www/adhc/makers/application/src/Api/Adapter/AbstractEntityAdapter.php(598): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#24 /srv/www/adhc/makers/application/src/Api/Adapter/AbstractEntityAdapter.php(409): Omeka\Api\Adapter\AbstractEntityAdapter->hydrateEntity(Object(Omeka\Api\Request), Object(Omeka\Entity\Item), Object(Omeka\Stdlib\ErrorStore))
#25 /srv/www/adhc/makers/application/src/Api/Manager.php(233): Omeka\Api\Adapter\AbstractEntityAdapter->update(Object(Omeka\Api\Request))
#26 /srv/www/adhc/makers/application/src/Api/Manager.php(136): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#27 /srv/www/adhc/makers/application/src/Mvc/Controller/Plugin/Api.php(152): Omeka\Api\Manager->update('items', '215', Array, Array, Array)
#28 /srv/www/adhc/makers/application/src/Controller/Admin/ItemController.php(245): Omeka\Mvc\Controller\Plugin\Api->update('items', '215', Array, Array)
#29 /srv/www/adhc/makers/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\Admin\ItemController->editAction()
#30 /srv/www/adhc/makers/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#31 /srv/www/adhc/makers/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#32 /srv/www/adhc/makers/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#33 /srv/www/adhc/makers/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#34 /srv/www/adhc/makers/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#35 /srv/www/adhc/makers/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#36 /srv/www/adhc/makers/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#37 /srv/www/adhc/makers/index.php(21): Laminas\Mvc\Application->run()
#38 {main}

Next Doctrine\ORM\Query\QueryException: [Semantical Error] line 0, col 67 near 'omeka_root omeka_0': Error: Class 'omeka_root' is not defined. in /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:65
Stack trace:
#0 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(492): Doctrine\ORM\Query\QueryException::semanticalError('line 0, col 67 ...', Object(Doctrine\ORM\Query\QueryException))
#1 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(992): Doctrine\ORM\Query\Parser->semanticalError('line 0, col 67 ...', Array)
#2 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1735): Doctrine\ORM\Query\Parser->validateAbstractSchemaName('omeka_root')
#3 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1701): Doctrine\ORM\Query\Parser->RangeVariableDeclaration()
#4 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1597): Doctrine\ORM\Query\Parser->Join()
#5 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1320): Doctrine\ORM\Query\Parser->IdentificationVariableDeclaration()
#6 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(879): Doctrine\ORM\Query\Parser->FromClause()
#7 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(848): Doctrine\ORM\Query\Parser->SelectStatement()
#8 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(261): Doctrine\ORM\Query\Parser->QueryLanguage()
#9 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(360): Doctrine\ORM\Query\Parser->getAST()
#10 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Parser->parse()
#11 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(298): Doctrine\ORM\Query->_parse()
#12 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(992): Doctrine\ORM\Query->_doExecute()
#13 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(947): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#14 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(750): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#15 /srv/www/adhc/makers/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(177): Doctrine\ORM\AbstractQuery->getResult(1)
#16 /srv/www/adhc/makers/application/src/Api/Adapter/AbstractEntityAdapter.php(299): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#17 /srv/www/adhc/makers/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#18 /srv/www/adhc/makers/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#19 /srv/www/adhc/makers/modules/Folksonomy/src/Mvc/Controller/Plugin/DeleteTags.php(62): Omeka\Api\Manager->search('tags', Array)
#20 /srv/www/adhc/makers/modules/Folksonomy/Module.php(794): Folksonomy\Mvc\Controller\Plugin\DeleteTags->__invoke(Object(Omeka\Entity\Item), Array)
#21 /srv/www/adhc/makers/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Folksonomy\Module->handleTagging(Object(Laminas\EventManager\Event))
#22 /srv/www/adhc/makers/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#23 /srv/www/adhc/makers/application/src/Api/Adapter/AbstractEntityAdapter.php(598): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#24 /srv/www/adhc/makers/application/src/Api/Adapter/AbstractEntityAdapter.php(409): Omeka\Api\Adapter\AbstractEntityAdapter->hydrateEntity(Object(Omeka\Api\Request), Object(Omeka\Entity\Item), Object(Omeka\Stdlib\ErrorStore))
#25 /srv/www/adhc/makers/application/src/Api/Manager.php(233): Omeka\Api\Adapter\AbstractEntityAdapter->update(Object(Omeka\Api\Request))
#26 /srv/www/adhc/makers/application/src/Api/Manager.php(136): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#27 /srv/www/adhc/makers/application/src/Mvc/Controller/Plugin/Api.php(152): Omeka\Api\Manager->update('items', '215', Array, Array, Array)
#28 /srv/www/adhc/makers/application/src/Controller/Admin/ItemController.php(245): Omeka\Mvc\Controller\Plugin\Api->update('items', '215', Array, Array)
#29 /srv/www/adhc/makers/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\Admin\ItemController->editAction()
#30 /srv/www/adhc/makers/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#31 /srv/www/adhc/makers/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#32 /srv/www/adhc/makers/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#33 /srv/www/adhc/makers/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#34 /srv/www/adhc/makers/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#35 /srv/www/adhc/makers/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#36 /srv/www/adhc/makers/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#37 /srv/www/adhc/makers/index.php(21): Laminas\Mvc\Application->run()
#38 {main}

I thought it could be related to our reference module which is currently on version 3.4.27.3.

Anyone have any Ideas?

jflatnes · March 3, 2021, 8:09pm

This looks like it’s an issue with the Folksonomy tagging module itself, but I can’t be sure of that, it’s possible it’s a bad interaction between two modules. Do you have a particular reason to suspect that? You may want to check with the modules’ developers (in this case I think they are actually the same person).

Patm · March 3, 2021, 9:25pm

Just from googling the error, I saw someone had a similar issue involving the reference module.
We’ll check on folksonomy though!

Daniel_KM · March 4, 2021, 7:28am

I don’t have issue with Reference 3.4.27.3. Anyway, it doesn’t appear in your log. I can reproduce your issue, that occurs only when removing multiple tags (not only one) during edition of an item, so it is fixed in version Folksonomy 3.3.10.2.

Patm · March 4, 2021, 5:56pm

Ok I think the error log is before we tried updating Folksonomy. We’ll try this!

system · November 9, 2021, 5:57pm

This topic was automatically closed 250 days after the last reply. New replies are no longer allowed.