Error updating to 3.2.1 on Reclaimhosting platform

[yaeln]

Hello, I need some basic help: our Omeka-s wont come up after the last update. We work on a Reclaimhosting server.
Thanks in advance
Yael

Here is the error log:

Doctrine\DBAL\Exception\TableExistsException
An exception occurred while executing ‘CREATE TABLE value_annotation (id INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;’: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘value_annotation’ already exists

Details:

PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘value_annotation’ already exists in /home/evaanita/public_html/archiving/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:132 Stack trace: #0 /home/evaanita/public_html/archiving/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(132): PDO->query(‘CREATE TABLE va…’) #1 /home/evaanita/public_html/archiving/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(36): Doctrine\DBAL\Driver\PDOConnection->doQuery(‘CREATE TABLE va…’) #2 /home/evaanita/public_html/archiving/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1437): Doctrine\DBAL\Driver\PDOConnection->query(‘CREATE TABLE va…’) #3 /home/evaanita/public_html/archiving/application/data/migrations/20210810083804_AddValueAnnotation.php(11): Doctrine\DBAL\Connection->query(‘CREATE TABLE va…’) #4 /home/evaanita/public_html/archiving/application/src/Db/Migration/Manager.php(80): Omeka\Db\Migrations\AddValueAnnotation->up(Object(Doctrine\DBAL\Connection)) #5 /home/evaanita/public_html/archiving/application/src/Controller/MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade() #6 /home/evaanita/public_html/archiving/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\MigrateController->indexAction() #7 /home/evaanita/public_html/archiving/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #8 /home/evaanita/public_html/archiving/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #9 /home/evaanita/public_html/archiving/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #10 /home/evaanita/public_html/archiving/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response)) #11 /home/evaanita/public_html/archiving/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #12 /home/evaanita/public_html/archiving/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #13 /home/evaanita/public_html/archiving/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #14 /home/evaanita/public_html/archiving/index.php(21): Laminas\Mvc\Application->run() #15 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘value_annotation’ already exists in /home/evaanita/public_html/archiving/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: #0 /home/evaanita/public_html/archiving/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(134): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException)) #1 /home/evaanita/public_html/archiving/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(36): Doctrine\DBAL\Driver\PDOConnection->doQuery(‘CREATE TABLE va…’) #2 /home/evaanita/public_html/archiving/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1437): Doctrine\DBAL\Driver\PDOConnection->query(‘CREATE TABLE va…’) #3 /home/evaanita/public_html/archiving/application/data/migrations/20210810083804_AddValueAnnotation.php(11): Doctrine\DBAL\Connection->query(‘CREATE TABLE va…’) #4 /home/evaanita/public_html/archiving/application/src/Db/Migration/Manager.php(80): Omeka\Db\Migrations\AddValueAnnotation->up(Object(Doctrine\DBAL\Connection)) #5 /home/evaanita/public_html/archiving/application/src/Controller/MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade() #6 /home/evaanita/public_html/archiving/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\MigrateController->indexAction() #7 /home/evaanita/public_html/archiving/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #8 /home/evaanita/public_html/archiving/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #9 /home/evaanita/public_html/archiving/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #10 /home/evaanita/public_html/archiving/vendor/laminas/laminas-mvc/src/DispatchListener.php(139): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response)) #11 /home/evaanita/public_html/archiving/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #12 /home/evaanita/public_html/archiving/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #13 /home/evaanita/public_html/archiving/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #14 /home/evaanita/public_html/archiving/index.php(21): Laminas\Mvc\Application->run() #15 {main} Next Doctrine\DBAL\Exception\TableExistsException: An exception occurred while executing ‘CREATE TABLE value_annotation (id INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;’: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘value_annotation’ already exists in /home/evaanita/public_html/archiving/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:57 Stack trace: #0 /home/evaanita/public_html/archiving/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/evaanita/public_html/archiving/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/evaanita/public_html/archiving/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 va…’, Array) #3 /home/evaanita/public_html/archiving/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1439): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), ‘CREATE TABLE va…’) #4 /home/evaanita/public_html/archiving/application/data/migrations/20210810083804_AddValueAnnotation.php(11): Doctrine\DBAL\Connection->query(‘CREATE TABLE va…’) #5 /home/evaanita/public_html/archiving/application/src/Db/Migration/Manager.php(80): Omeka\Db\Migrations\AddValueAnnotation->up(Object(Doctrine\DBAL\Connection)) #6 /home/evaanita/public_html/archiving/application/src/Controller/MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade() #7 /home/evaanita/public_html/archiving/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\MigrateController->indexAction() #8 /home/evaanita/public_html/archiving/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #9 /home/evaanita/public_html/archiving/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #10 /home/evaanita/public_html/archiving/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #11 /home/evaanita/public_html/archiving/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/evaanita/public_html/archiving/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #13 /home/evaanita/public_html/archiving/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #14 /home/evaanita/public_html/archiving/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #15 /home/evaanita/public_html/archiving/index.php(21): Laminas\Mvc\Application->run() #16 {main}

[jflatnes]

That’s odd… what’s happening here is that Omeka S is trying to upgrade your site. But it’s trying to do the upgrade for 3.2.0, not 3.2.1, even though the error message indicates that you were on 3.2.0 already.

Did you do anything odd previously, like have an upgrade fail or have to restore the database? It’s odd for these two things to be out of sync like that.

Were you previously on 3.2.0, or an earlier version?

[yaeln]

Yes, we upgraded the Omeka-s to 3.2.0 manually, and a few weeks after the ReclaimHosting automation upgraded to the current version.
Any ideas what I can do?

[jflatnes]

If you were on 3.2.0 before, then you could “skip” this migration since it should already be done.

You have two ways you can do this. The migration that’s causing you trouble is the file application/data/migrations/20210810083804_AddValueAnnotation.php.

Omeka S stores data on which migrations have already been done in a database table called migration. You can add this migration’s number, 20210810083804 as a row in that table, and then Omeka S won’t run it anymore.

Alternatively, you could go into the file itself and just comment out the lines that run the queries, i.e., replace every

$conn->query( ...

with

//$conn->query(

This will just make the system “run” the migration (which will actually do nothing because you commented out all those lines), and it will record it as being done.