Mapping module not installing

Hello,

Anyone else having problems with Maping module installation in the latest version of Omeka S?

What kind of problem are you having? An error message?

Yes. I am attaching it below.

PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘mapping_marker’ already exists in /home/albanon1/adsh.al/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:53
Stack trace:
#0 /home/albanon1/adsh.al/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(53): PDO->exec(‘CREATE TABLE ma…’)
#1 /home/albanon1/adsh.al/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1567): Doctrine\DBAL\Driver\PDOConnection->exec(‘CREATE TABLE ma…’)
#2 /home/albanon1/adsh.al/modules/Mapping/Module.php(119): Doctrine\DBAL\Connection->exec(‘CREATE TABLE ma…’)
#3 /home/albanon1/adsh.al/application/src/Module/Manager.php(240): Mapping\Module->install(Object(Laminas\ServiceManager\ServiceManager))
#4 /home/albanon1/adsh.al/application/src/Controller/Admin/ModuleController.php(117): Omeka\Module\Manager->install(Object(Omeka\Module\Module))
#5 /home/albanon1/adsh.al/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\Admin\ModuleController->installAction()
#6 /home/albanon1/adsh.al/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#7 /home/albanon1/adsh.al/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#8 /home/albanon1/adsh.al/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#9 /home/albanon1/adsh.al/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#10 /home/albanon1/adsh.al/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#11 /home/albanon1/adsh.al/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#12 /home/albanon1/adsh.al/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#13 /home/albanon1/adsh.al/index.php(21): Laminas\Mvc\Application->run()
#14 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘mapping_marker’ already exists in /home/albanon1/adsh.al/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /home/albanon1/adsh.al/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(58): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /home/albanon1/adsh.al/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1567): Doctrine\DBAL\Driver\PDOConnection->exec(‘CREATE TABLE ma…’)
#2 /home/albanon1/adsh.al/modules/Mapping/Module.php(119): Doctrine\DBAL\Connection->exec(‘CREATE TABLE ma…’)
#3 /home/albanon1/adsh.al/application/src/Module/Manager.php(240): Mapping\Module->install(Object(Laminas\ServiceManager\ServiceManager))
#4 /home/albanon1/adsh.al/application/src/Controller/Admin/ModuleController.php(117): Omeka\Module\Manager->install(Object(Omeka\Module\Module))
#5 /home/albanon1/adsh.al/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\Admin\ModuleController->installAction()
#6 /home/albanon1/adsh.al/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#7 /home/albanon1/adsh.al/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#8 /home/albanon1/adsh.al/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#9 /home/albanon1/adsh.al/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#10 /home/albanon1/adsh.al/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#11 /home/albanon1/adsh.al/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#12 /home/albanon1/adsh.al/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#13 /home/albanon1/adsh.al/index.php(21): Laminas\Mvc\Application->run()
#14 {main}

Next Doctrine\DBAL\Exception\TableExistsException: An exception occurred while executing ‘CREATE TABLE mapping_marker (id INT AUTO_INCREMENT NOT NULL, item_id INT NOT NULL, media_id INT DEFAULT NULL, lat DOUBLE PRECISION NOT NULL, lng DOUBLE PRECISION NOT NULL, label VARCHAR(255) DEFAULT NULL, INDEX IDX_667C9244126F525E (item_id), INDEX IDX_667C9244EA9FDD75 (media_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;’:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘mapping_marker’ already exists in /home/albanon1/adsh.al/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:57
Stack trace:
#0 /home/albanon1/adsh.al/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/albanon1/adsh.al/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/albanon1/adsh.al/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2214): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), ‘CREATE TABLE ma…’, Array)
#3 /home/albanon1/adsh.al/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1569): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), ‘CREATE TABLE ma…’)
#4 /home/albanon1/adsh.al/modules/Mapping/Module.php(119): Doctrine\DBAL\Connection->exec(‘CREATE TABLE ma…’)
#5 /home/albanon1/adsh.al/application/src/Module/Manager.php(240): Mapping\Module->install(Object(Laminas\ServiceManager\ServiceManager))
#6 /home/albanon1/adsh.al/application/src/Controller/Admin/ModuleController.php(117): Omeka\Module\Manager->install(Object(Omeka\Module\Module))
#7 /home/albanon1/adsh.al/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\Admin\ModuleController->installAction()
#8 /home/albanon1/adsh.al/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#9 /home/albanon1/adsh.al/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#10 /home/albanon1/adsh.al/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#11 /home/albanon1/adsh.al/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#12 /home/albanon1/adsh.al/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#13 /home/albanon1/adsh.al/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#14 /home/albanon1/adsh.al/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#15 /home/albanon1/adsh.al/index.php(21): Laminas\Mvc\Application->run()
#16 {main}

So, the error you’re getting here says that the tables for the Mapping module are at least partially already installed. You could remove them from your database (using something like cpanel or phpmyadmin, maybe) to get past this error.

This could just be a sign that you had a different error occur initially, or maybe that you had vestiges in your database of a previous installation left over.

The table it’s complaining is already there is mapping_marker, though there are some other mapping_ tables that may be there also.