Omeka S 4.1 not displaying items

Pretty broad issue here. If you click on “Items” under resources, Omeka throws an error. Same error if you click on an item in an item set, or an item displayed in a Carousel.

Hugely long error follows:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘omeka.mapping_marker’ doesn’t exist in /home/apache2/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /home/apache2/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)
#1 /home/apache2/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(31): Doctrine\DBAL\Connection->executeQuery(‘SELECT m0_.id A…’, Array, Array, NULL)
#3 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(325): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#4 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1181): Doctrine\ORM\Query->_doExecute()
#5 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1135): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#6 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(871): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#7 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(171): Doctrine\ORM\AbstractQuery->getResult(1)
#8 /home/apache2/htdocs/application/src/Api/Adapter/AbstractEntityAdapter.php(335): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#9 /home/apache2/htdocs/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#10 /home/apache2/htdocs/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#11 /home/apache2/htdocs/modules/AdvancedSearch/src/Api/ManagerDelegator.php(134): Omeka\Api\Manager->search(‘mapping_markers’, Array, Array)
#12 /home/apache2/htdocs/modules/Mapping/Module.php(477): AdvancedSearch\Api\ManagerDelegator->search(‘mapping_markers’, Array)
#13 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Mapping\Module->filterItemJsonLd(Object(Laminas\EventManager\Event))
#14 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(144): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#15 /home/apache2/htdocs/application/src/Api/Representation/AbstractResourceRepresentation.php(93): Laminas\EventManager\EventManager->trigger(‘rep.resource.js…’, Object(Omeka\Api\Representation\ItemRepresentation), Object(ArrayObject))
#16 [internal function]: Omeka\Api\Representation\AbstractResourceRepresentation->jsonSerialize()
#17 /home/apache2/htdocs/application/src/Api/Representation/AbstractResourceRepresentation.php(288): json_encode(Object(Omeka\Api\Representation\ItemRepresentation))
#18 /home/apache2/htdocs/application/Module.php(258): Omeka\Api\Representation\AbstractResourceRepresentation->embeddedJsonLd()
#19 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Omeka\Module->Omeka{closure}(Object(Laminas\EventManager\Event))
#20 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#21 /home/apache2/htdocs/application/src/View/Helper/Trigger.php(60): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#22 /home/apache2/htdocs/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(407): Omeka\View\Helper\Trigger->__invoke(‘view.browse.aft…’)
#23 /home/apache2/htdocs/application/view/omeka/admin/item/browse.phtml(101): Laminas\View\Renderer\PhpRenderer->__call(‘trigger’, Array)
#24 /home/apache2/htdocs/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include(‘/home/apache2/h…’)
#25 /home/apache2/htdocs/vendor/laminas/laminas-view/src/View.php(194): Laminas\View\Renderer\PhpRenderer->render(NULL)
#26 /home/apache2/htdocs/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#27 /home/apache2/htdocs/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren(Object(Laminas\View\Model\ViewModel))
#28 /home/apache2/htdocs/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(98): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#29 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#30 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#31 /home/apache2/htdocs/vendor/laminas/laminas-mvc/src/Application.php(360): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#32 /home/apache2/htdocs/vendor/laminas/laminas-mvc/src/Application.php(341): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#33 /home/apache2/htdocs/index.php(21): Laminas\Mvc\Application->run()
#34 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘omeka.mapping_marker’ doesn’t exist in /home/apache2/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /home/apache2/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /home/apache2/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(31): Doctrine\DBAL\Connection->executeQuery(‘SELECT m0_.id A…’, Array, Array, NULL)
#3 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(325): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#4 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1181): Doctrine\ORM\Query->_doExecute()
#5 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1135): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#6 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(871): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#7 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(171): Doctrine\ORM\AbstractQuery->getResult(1)
#8 /home/apache2/htdocs/application/src/Api/Adapter/AbstractEntityAdapter.php(335): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#9 /home/apache2/htdocs/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#10 /home/apache2/htdocs/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#11 /home/apache2/htdocs/modules/AdvancedSearch/src/Api/ManagerDelegator.php(134): Omeka\Api\Manager->search(‘mapping_markers’, Array, Array)
#12 /home/apache2/htdocs/modules/Mapping/Module.php(477): AdvancedSearch\Api\ManagerDelegator->search(‘mapping_markers’, Array)
#13 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Mapping\Module->filterItemJsonLd(Object(Laminas\EventManager\Event))
#14 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(144): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#15 /home/apache2/htdocs/application/src/Api/Representation/AbstractResourceRepresentation.php(93): Laminas\EventManager\EventManager->trigger(‘rep.resource.js…’, Object(Omeka\Api\Representation\ItemRepresentation), Object(ArrayObject))
#16 [internal function]: Omeka\Api\Representation\AbstractResourceRepresentation->jsonSerialize()
#17 /home/apache2/htdocs/application/src/Api/Representation/AbstractResourceRepresentation.php(288): json_encode(Object(Omeka\Api\Representation\ItemRepresentation))
#18 /home/apache2/htdocs/application/Module.php(258): Omeka\Api\Representation\AbstractResourceRepresentation->embeddedJsonLd()
#19 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Omeka\Module->Omeka{closure}(Object(Laminas\EventManager\Event))
#20 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#21 /home/apache2/htdocs/application/src/View/Helper/Trigger.php(60): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#22 /home/apache2/htdocs/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(407): Omeka\View\Helper\Trigger->__invoke(‘view.browse.aft…’)
#23 /home/apache2/htdocs/application/view/omeka/admin/item/browse.phtml(101): Laminas\View\Renderer\PhpRenderer->__call(‘trigger’, Array)
#24 /home/apache2/htdocs/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include(‘/home/apache2/h…’)
#25 /home/apache2/htdocs/vendor/laminas/laminas-view/src/View.php(194): Laminas\View\Renderer\PhpRenderer->render(NULL)
#26 /home/apache2/htdocs/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#27 /home/apache2/htdocs/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren(Object(Laminas\View\Model\ViewModel))
#28 /home/apache2/htdocs/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(98): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#29 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#30 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#31 /home/apache2/htdocs/vendor/laminas/laminas-mvc/src/Application.php(360): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#32 /home/apache2/htdocs/vendor/laminas/laminas-mvc/src/Application.php(341): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#33 /home/apache2/htdocs/index.php(21): Laminas\Mvc\Application->run()
#34 {main}

Next Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing ‘SELECT m0_.id AS id_0, m0_.lat AS lat_1, m0_.lng AS lng_2, m0_.label AS label_3, m0_.item_id AS item_id_4, m0_.media_id AS media_id_5 FROM mapping_marker m0_ INNER JOIN (item i1_ LEFT JOIN resource r2_ ON i1_.id = r2_.id) ON m0_.item_id = i1_.id AND (r2_.id IN (?)) GROUP BY m0_.id ORDER BY m0_.id ASC’ with params [52228]:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘omeka.mapping_marker’ doesn’t exist in /home/apache2/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:61
Stack trace:
#0 /home/apache2/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDO\Exception))
#1 /home/apache2/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), ‘An exception oc…’)
#2 /home/apache2/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), ‘SELECT m0_.id A…’, Array)
#3 /home/apache2/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1313): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), ‘SELECT m0_.id A…’, Array, Array)
#4 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(31): Doctrine\DBAL\Connection->executeQuery(‘SELECT m0_.id A…’, Array, Array, NULL)
#5 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(325): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#6 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1181): Doctrine\ORM\Query->_doExecute()
#7 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1135): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#8 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(871): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#9 /home/apache2/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(171): Doctrine\ORM\AbstractQuery->getResult(1)
#10 /home/apache2/htdocs/application/src/Api/Adapter/AbstractEntityAdapter.php(335): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#11 /home/apache2/htdocs/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#12 /home/apache2/htdocs/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#13 /home/apache2/htdocs/modules/AdvancedSearch/src/Api/ManagerDelegator.php(134): Omeka\Api\Manager->search(‘mapping_markers’, Array, Array)
#14 /home/apache2/htdocs/modules/Mapping/Module.php(477): AdvancedSearch\Api\ManagerDelegator->search(‘mapping_markers’, Array)
#15 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Mapping\Module->filterItemJsonLd(Object(Laminas\EventManager\Event))
#16 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(144): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#17 /home/apache2/htdocs/application/src/Api/Representation/AbstractResourceRepresentation.php(93): Laminas\EventManager\EventManager->trigger(‘rep.resource.js…’, Object(Omeka\Api\Representation\ItemRepresentation), Object(ArrayObject))
#18 [internal function]: Omeka\Api\Representation\AbstractResourceRepresentation->jsonSerialize()
#19 /home/apache2/htdocs/application/src/Api/Representation/AbstractResourceRepresentation.php(288): json_encode(Object(Omeka\Api\Representation\ItemRepresentation))
#20 /home/apache2/htdocs/application/Module.php(258): Omeka\Api\Representation\AbstractResourceRepresentation->embeddedJsonLd()
#21 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Omeka\Module->Omeka{closure}(Object(Laminas\EventManager\Event))
#22 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#23 /home/apache2/htdocs/application/src/View/Helper/Trigger.php(60): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#24 /home/apache2/htdocs/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(407): Omeka\View\Helper\Trigger->__invoke(‘view.browse.aft…’)
#25 /home/apache2/htdocs/application/view/omeka/admin/item/browse.phtml(101): Laminas\View\Renderer\PhpRenderer->__call(‘trigger’, Array)
#26 /home/apache2/htdocs/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include(‘/home/apache2/h…’)
#27 /home/apache2/htdocs/vendor/laminas/laminas-view/src/View.php(194): Laminas\View\Renderer\PhpRenderer->render(NULL)
#28 /home/apache2/htdocs/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#29 /home/apache2/htdocs/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren(Object(Laminas\View\Model\ViewModel))
#30 /home/apache2/htdocs/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(98): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#31 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#32 /home/apache2/htdocs/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#33 /home/apache2/htdocs/vendor/laminas/laminas-mvc/src/Application.php(360): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#34 /home/apache2/htdocs/vendor/laminas/laminas-mvc/src/Application.php(341): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#35 /home/apache2/htdocs/index.php(21): Laminas\Mvc\Application->run()
#36 {main}

You have the Mapping module installed but you’re missing one of its tables.

Maybe you deleted it?

Disabling Mapping should eliminate the error. Uninstalling it would do so permanently, but it would remove any Mapping tables you do still have in your database.