Mapping Module error

brian.maass · September 30, 2025, 5:20pm

I am unable to open pages that have map blocks. If I deactivate Mapping Module, page loads (without map of course). Example page with module activated: https://exhibits.unmc.edu/whc/Picotte

Currently:

```
Omeka S version 4.0.4
```
```
Module:  Mapping v1.10.0
```

I previously upgraded to 4.1.1 and Mapping 2.2.0, but had to go back (restored 4.0.4 backup).

Could Mapping 2.2.0 have added something that the restored backup wouldn’t be able to change back?

Error Log:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘wigtonun_os3.mapping_marker’ doesn’t exist in /home/wigtonun/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /home/wigtonun/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)
#1 /home/wigtonun/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/wigtonun/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(31): Doctrine\DBAL\Connection->executeQuery(‘SELECT m0_.id A…’, Array, Array, NULL)
#3 /home/wigtonun/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(325): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#4 /home/wigtonun/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1181): Doctrine\ORM\Query->_doExecute()
#5 /home/wigtonun/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1135): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#6 /home/wigtonun/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(871): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#7 /home/wigtonun/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(171): Doctrine\ORM\AbstractQuery->getResult(1)
#8 /home/wigtonun/public_html/application/src/Api/Adapter/AbstractEntityAdapter.php(327): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#9 /home/wigtonun/public_html/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#10 /home/wigtonun/public_html/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#11 /home/wigtonun/public_html/modules/AdvancedSearch/src/Api/ManagerDelegator.php(134): Omeka\Api\Manager->search(‘mapping_markers’, Array, Array)
#12 /home/wigtonun/public_html/application/src/View/Helper/Api.php(36): AdvancedSearch\Api\ManagerDelegator->search(‘mapping_markers’, Array)
#13 /home/wigtonun/public_html/modules/Mapping/src/Site/BlockLayout/Map.php(75): Omeka\View\Helper\Api->search(‘mapping_markers’, Array)
#14 /home/wigtonun/public_html/application/src/View/Helper/BlockLayout.php(124): Mapping\Site\BlockLayout\Map->render(Object(Laminas\View\Renderer\PhpRenderer), Object(Omeka\Api\Representation\SitePageBlockRepresentation))
#15 /home/wigtonun/public_html/application/view/omeka/site/page/content.phtml(9): Omeka\View\Helper\BlockLayout->render(Object(Omeka\Api\Representation\SitePageBlockRepresentation))
#16 /home/wigtonun/public_html/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include(‘/home/wigtonun/…’)
#17 /home/wigtonun/public_html/vendor/laminas/laminas-view/src/View.php(194): Laminas\View\Renderer\PhpRenderer->render(NULL)
#18 /home/wigtonun/public_html/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#19 /home/wigtonun/public_html/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren(Object(Laminas\View\Model\ViewModel))
#20 /home/wigtonun/public_html/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#21 /home/wigtonun/public_html/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren(Object(Laminas\View\Model\ViewModel))
#22 /home/wigtonun/public_html/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(98): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#23 /home/wigtonun/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#24 /home/wigtonun/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#25 /home/wigtonun/public_html/vendor/laminas/laminas-mvc/src/Application.php(360): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#26 /home/wigtonun/public_html/vendor/laminas/laminas-mvc/src/Application.php(341): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#27 /home/wigtonun/public_html/index.php(21): Laminas\Mvc\Application->run()
#28 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘wigtonun_os3.mapping_marker’ doesn’t exist in /home/wigtonun/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /home/wigtonun/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /home/wigtonun/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/wigtonun/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(31): Doctrine\DBAL\Connection->executeQuery(‘SELECT m0_.id A…’, Array, Array, NULL)
#3 /home/wigtonun/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(325): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#4 /home/wigtonun/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1181): Doctrine\ORM\Query->_doExecute()
#5 /home/wigtonun/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1135): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 1)
#6 /home/wigtonun/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(871): Doctrine\ORM\AbstractQuery->execute(NULL, 1)
#7 /home/wigtonun/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(171): Doctrine\ORM\AbstractQuery->getResult(1)
#8 /home/wigtonun/public_html/application/src/Api/Adapter/AbstractEntityAdapter.php(327): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#9 /home/wigtonun/public_html/application/src/Api/Manager.php(221): Omeka\Api\Adapter\AbstractEntityAdapter->search(Object(Omeka\Api\Request))
#10 /home/wigtonun/public_html/application/src/Api/Manager.php(59): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#11 /home/wigtonun/public_html/modules/AdvancedSearch/src/Api/ManagerDelegator.php(134): Omeka\Api\Manager->search(‘mapping_markers’, Array, Array)
#12 /home/wigtonun/public_html/application/src/View/Helper/Api.php(36): AdvancedSearch\Api\ManagerDelegator->search(‘mapping_markers’, Array)
#13 /home/wigtonun/public_html/modules/Mapping/src/Site/BlockLayout/Map.php(75): Omeka\View\Helper\Api->search(‘mapping_markers’, Array)
#14 /home/wigtonun/public_html/application/src/View/Helper/BlockLayout.php(124): Mapping\Site\BlockLayout\Map->render(Object(Laminas\View\Renderer\PhpRenderer), Object(Omeka\Api\Representation\SitePageBlockRepresentation))
#15 /home/wigtonun/public_html/application/view/omeka/site/page/content.phtml(9): Omeka\View\Helper\BlockLayout->render(Object(Omeka\Api\Representation\SitePageBlockRepresentation))
#16 /home/wigtonun/public_html/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include(‘/home/wigtonun/…’)
#17 /home/wigtonun/public_html/vendor/laminas/laminas-view/src/View.php(194): Laminas\View\Renderer\PhpRenderer->render(NULL)
#18 /home/wigtonun/public_html/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#19 /home/wigtonun/public_html/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren(Object(Laminas\View\Model\ViewModel))
#20 /home/wigtonun/public_html/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#21 /home/wigtonun/public_html/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren(Object(Laminas\View\Model\ViewModel))
#22 /home/wigtonun/public_html/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(98): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#23 /home/wigtonun/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#24 /home/wigtonun/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#25 /home/wigtonun/public_html/vendor/laminas/laminas-mvc/src/Application.php(360): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#26 /home/wigtonun/public_html/vendor/laminas/laminas-mvc/src/Application.php(341): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#27 /home/wigtonun/public_html/index.php(21): Laminas\Mvc\Application->run()
#28 {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 AND (r2_.is_public = 1)) ON m0_.item_id = i1_.id AND (r2_.id IN (?)) WHERE (m0_.item_id = (SELECT r.id FROM resource r WHERE (r.is_public = 1) AND r.id = m0_.item_id)) GROUP BY m0_.id ORDER BY m0_.id ASC’ with params [1109]:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘wigtonun_os3.mapping_marker’ doesn’t exist in /home/wigtonun/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:61
Stack trace:
#0 /home/wigtonun/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDO\Exception))

fackrellj · September 30, 2025, 5:38pm

Hi @brian.maass ,

I think that depends - upgrading to v2 drops the mapping_marker table. Did you back up the database before the module upgrade and then restore it after reverting to the previous module version? Or did you just back up and restore the files?

github.com

omeka-s-modules/Mapping/blob/32fca040a60ea303bdc507c94481d9db80c90f14/Module.php#L198C45-L198C59


      
          $conn->executeStatement('DROP TABLE mapping_marker;');

brian.maass · September 30, 2025, 5:52pm

I use the backup via Installatron (on Reclaim), which I have believed should include the database and the files. But this error makes me suspicious.

brian.maass · October 4, 2025, 11:54pm

I had to uninstall and reinstall the Mapping module (not just deactivate/reactivate).

This wiped out the mapped points that we had assigned to items, so we had to re-select/assign them. Luckily we didn’t have that many yet.

Thanks.