Unable to upgrade Bulk Export

Omeka S Modules
1

Hello everyone,

I’m having trouble upgrading the module Bulk Export. I think the problem was because I deactivated the module before uninstalling it. When I tried installing the newer version (either from the command line or from Easy Admin), I kept receiving the following error:

PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘value_data’ already exists in /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:55
Stack trace:
#0 /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(55): PDO->exec()
#1 /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1534): Doctrine\DBAL\Driver\PDOConnection->exec()
#2 /var/www/html/omeka-s/modules/Common/src/TraitModule.php(528): Doctrine\DBAL\Connection->executeStatement()
#3 /var/www/html/omeka-s/modules/Common/src/TraitModule.php(169): BulkExport\Module->execSqlFromFile()
#4 /var/www/html/omeka-s/modules/Common/src/TraitModule.php(126): BulkExport\Module->installAuto()
#5 /var/www/html/omeka-s/application/src/Module/Manager.php(225): BulkExport\Module->install()
#6 /var/www/html/omeka-s/application/src/Controller/Admin/ModuleController.php(117): Omeka\Module\Manager->install()
#7 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(72): Omeka\Controller\Admin\ModuleController->installAction()
#8 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\Controller\AbstractActionController->onDispatch()
#9 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(176): Laminas\EventManager\EventManager->triggerListeners()
#10 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager->triggerEventUntil()
#11 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/DispatchListener.php(117): Laminas\Mvc\Controller\AbstractController->dispatch()
#12 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\DispatchListener->onDispatch()
#13 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(176): Laminas\EventManager\EventManager->triggerListeners()
#14 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(319): Laminas\EventManager\EventManager->triggerEventUntil()
#15 /var/www/html/omeka-s/index.php(26): Laminas\Mvc\Application->run()
#16 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘value_data’ already exists in /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(60): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1534): Doctrine\DBAL\Driver\PDOConnection->exec()
#2 /var/www/html/omeka-s/modules/Common/src/TraitModule.php(528): Doctrine\DBAL\Connection->executeStatement()
#3 /var/www/html/omeka-s/modules/Common/src/TraitModule.php(169): BulkExport\Module->execSqlFromFile()
#4 /var/www/html/omeka-s/modules/Common/src/TraitModule.php(126): BulkExport\Module->installAuto()
#5 /var/www/html/omeka-s/application/src/Module/Manager.php(225): BulkExport\Module->install()
#6 /var/www/html/omeka-s/application/src/Controller/Admin/ModuleController.php(117): Omeka\Module\Manager->install()
#7 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(72): Omeka\Controller\Admin\ModuleController->installAction()
#8 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\Controller\AbstractActionController->onDispatch()
#9 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(176): Laminas\EventManager\EventManager->triggerListeners()
#10 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager->triggerEventUntil()
#11 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/DispatchListener.php(117): Laminas\Mvc\Controller\AbstractController->dispatch()
#12 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\DispatchListener->onDispatch()
#13 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(176): Laminas\EventManager\EventManager->triggerListeners()
#14 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(319): Laminas\EventManager\EventManager->triggerEventUntil()
#15 /var/www/html/omeka-s/index.php(26): Laminas\Mvc\Application->run()
#16 {main}

Next Doctrine\DBAL\Exception\TableExistsException: An exception occurred while executing '# Table to index value length without modifying core table.

Kept in sync via SQL triggers for INSERT/UPDATE, and foreign key for DELETE.

CREATE TABLE value_data (
id INT NOT NULL,
length INT UNSIGNED NOT NULL,
PRIMARY KEY (id),
INDEX idx_value_length (length),
CONSTRAINT FK_value_data_value FOREIGN KEY (id) REFERENCES value (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci’:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘value_data’ already exists in /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:57
Stack trace:
#0 /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
#1 /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
#2 /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2222): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /var/www/html/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1537): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
#4 /var/www/html/omeka-s/modules/Common/src/TraitModule.php(528): Doctrine\DBAL\Connection->executeStatement()
#5 /var/www/html/omeka-s/modules/Common/src/TraitModule.php(169): BulkExport\Module->execSqlFromFile()
#6 /var/www/html/omeka-s/modules/Common/src/TraitModule.php(126): BulkExport\Module->installAuto()
#7 /var/www/html/omeka-s/application/src/Module/Manager.php(225): BulkExport\Module->install()
#8 /var/www/html/omeka-s/application/src/Controller/Admin/ModuleController.php(117): Omeka\Module\Manager->install()
#9 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(72): Omeka\Controller\Admin\ModuleController->installAction()
#10 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\Controller\AbstractActionController->onDispatch()
#11 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(176): Laminas\EventManager\EventManager->triggerListeners()
#12 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager->triggerEventUntil()
#13 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/DispatchListener.php(117): Laminas\Mvc\Controller\AbstractController->dispatch()
#14 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\DispatchListener->onDispatch()
#15 /var/www/html/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(176): Laminas\EventManager\EventManager->triggerListeners()
#16 /var/www/html/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(319): Laminas\EventManager\EventManager->triggerEventUntil()
#17 /var/www/html/omeka-s/index.php(26): Laminas\Mvc\Application->run()
#18 {main}

I tried dropping tables related to the module in MySQL and installing the old version again but received the same error.

Could you help me with how to reinstall the module? Thank you!