Error when trying to upgrade Omeka S 2.0.2 to 3.1.0 on Reclaim Hosting

pfernandez · January 16, 2022, 10:03pm

Hi there,

Quite new to omeka so would appreciate any help you can provide.

I’ve been attempting to upgrade an instance of Omeka S 2.0.2 to the current latest version 3.1.0 to no avail.

My latest attempt has been made following the manual instructions in the omeka forum here: Installing - Omeka S User Manual

and the error message currently displaying (after filling the Install form) is:

An exception occurred while executing ‘CREATE TABLE api_key ( id varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, owner_id int NOT NULL, label varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, credential_hash varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL, last_ip varbinary(16) DEFAULT NULL COMMENT ‘(DC2Type:ip_address)’, last_accessed datetime DEFAULT NULL, created datetime NOT NULL, PRIMARY KEY (id), KEY IDX_C912ED9D7E3C61F9 (owner_id), CONSTRAINT FK_C912ED9D7E3C61F9 FOREIGN KEY (owner_id) REFERENCES user (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci’: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘api_key’ already exists

Any guess to what my next step should be regading this ‘api key’ table?

Thanks very much in advance to the community.

Best,

Pedro

jflatnes · January 19, 2022, 9:01pm

You shouldn’t be filling in the Install form during an upgrade. You followed the “Upgrading” instructions on that page?

pfernandez · January 19, 2022, 9:27pm

Thank you, John.
I’ve advanced a bit since I wrote the post.
The message I am getting now (while in the migrate page) is this: (Note that I am testing the upgrade in a test subdomain to not interrupt services in the main website).

Omeka S encountered an error

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

Details:

PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘item_site’ already exists in /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:53 Stack trace: #0 /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(53): PDO->exec(‘CREATE TABLE it…’) #1 /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1567): Doctrine\DBAL\Driver\PDOConnection->exec(‘CREATE TABLE it…’) #2 /home/hiddenga/test.hiddengalleries.eu/application/data/migrations/20200224022356_SiteItems.php(28): Doctrine\DBAL\Connection->exec(‘CREATE TABLE it…’) #3 /home/hiddenga/test.hiddengalleries.eu/application/src/Db/Migration/Manager.php(80): Omeka\Db\Migrations\SiteItems->up(Object(Doctrine\DBAL\Connection)) #4 /home/hiddenga/test.hiddengalleries.eu/application/src/Controller/MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade() #5 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\MigrateController->indexAction() #6 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #7 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #8 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #9 /home/hiddenga/test.hiddengalleries.eu/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/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #11 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #12 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #13 /home/hiddenga/test.hiddengalleries.eu/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 ‘item_site’ already exists in /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: #0 /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(58): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException)) #1 /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1567): Doctrine\DBAL\Driver\PDOConnection->exec(‘CREATE TABLE it…’) #2 /home/hiddenga/test.hiddengalleries.eu/application/data/migrations/20200224022356_SiteItems.php(28): Doctrine\DBAL\Connection->exec(‘CREATE TABLE it…’) #3 /home/hiddenga/test.hiddengalleries.eu/application/src/Db/Migration/Manager.php(80): Omeka\Db\Migrations\SiteItems->up(Object(Doctrine\DBAL\Connection)) #4 /home/hiddenga/test.hiddengalleries.eu/application/src/Controller/MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade() #5 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\MigrateController->indexAction() #6 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #7 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #8 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #9 /home/hiddenga/test.hiddengalleries.eu/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/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #11 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #12 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #13 /home/hiddenga/test.hiddengalleries.eu/index.php(21): Laminas\Mvc\Application->run() #14 {main} Next Doctrine\DBAL\Exception\TableExistsException: An exception occurred while executing ‘CREATE TABLE item_site (item_id INT NOT NULL, site_id INT NOT NULL, INDEX IDX_A1734D1F126F525E (item_id), INDEX IDX_A1734D1FF6BD1646 (site_id), PRIMARY KEY(item_id, site_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;’: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘item_site’ already exists in /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:57 Stack trace: #0 /home/hiddenga/test.hiddengalleries.eu/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/hiddenga/test.hiddengalleries.eu/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/hiddenga/test.hiddengalleries.eu/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 it…’, Array) #3 /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1569): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), ‘CREATE TABLE it…’) #4 /home/hiddenga/test.hiddengalleries.eu/application/data/migrations/20200224022356_SiteItems.php(28): Doctrine\DBAL\Connection->exec(‘CREATE TABLE it…’) #5 /home/hiddenga/test.hiddengalleries.eu/application/src/Db/Migration/Manager.php(80): Omeka\Db\Migrations\SiteItems->up(Object(Doctrine\DBAL\Connection)) #6 /home/hiddenga/test.hiddengalleries.eu/application/src/Controller/MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade() #7 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\MigrateController->indexAction() #8 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #9 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #10 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #11 /home/hiddenga/test.hiddengalleries.eu/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/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #13 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #14 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #15 /home/hiddenga/test.hiddengalleries.eu/index.php(21): Laminas\Mvc\Application->run() #16 {main}

jflatnes · January 19, 2022, 9:43pm

One first thing to do is to restore to a fresh copy of the database from before you started your upgrade attempts.

This error looks like something you might be seeing because of your previous attempts altering the database improperly.

pfernandez · January 19, 2022, 10:51pm

Thank you John,
Restored database and tried again:
Same error I believe.

Omeka S encountered an error

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

Details:

PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘item_site’ already exists in /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:53 Stack trace: #0 /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(53): PDO->exec(‘CREATE TABLE it…’) #1 /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1567): Doctrine\DBAL\Driver\PDOConnection->exec(‘CREATE TABLE it…’) #2 /home/hiddenga/test.hiddengalleries.eu/application/data/migrations/20200224022356_SiteItems.php(28): Doctrine\DBAL\Connection->exec(‘CREATE TABLE it…’) #3 /home/hiddenga/test.hiddengalleries.eu/application/src/Db/Migration/Manager.php(80): Omeka\Db\Migrations\SiteItems->up(Object(Doctrine\DBAL\Connection)) #4 /home/hiddenga/test.hiddengalleries.eu/application/src/Controller/MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade() #5 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\MigrateController->indexAction() #6 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #7 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #8 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #9 /home/hiddenga/test.hiddengalleries.eu/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/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #11 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #12 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #13 /home/hiddenga/test.hiddengalleries.eu/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 ‘item_site’ already exists in /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: #0 /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(58): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException)) #1 /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1567): Doctrine\DBAL\Driver\PDOConnection->exec(‘CREATE TABLE it…’) #2 /home/hiddenga/test.hiddengalleries.eu/application/data/migrations/20200224022356_SiteItems.php(28): Doctrine\DBAL\Connection->exec(‘CREATE TABLE it…’) #3 /home/hiddenga/test.hiddengalleries.eu/application/src/Db/Migration/Manager.php(80): Omeka\Db\Migrations\SiteItems->up(Object(Doctrine\DBAL\Connection)) #4 /home/hiddenga/test.hiddengalleries.eu/application/src/Controller/MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade() #5 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\MigrateController->indexAction() #6 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #7 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #8 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #9 /home/hiddenga/test.hiddengalleries.eu/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/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #11 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #12 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #13 /home/hiddenga/test.hiddengalleries.eu/index.php(21): Laminas\Mvc\Application->run() #14 {main} Next Doctrine\DBAL\Exception\TableExistsException: An exception occurred while executing ‘CREATE TABLE item_site (item_id INT NOT NULL, site_id INT NOT NULL, INDEX IDX_A1734D1F126F525E (item_id), INDEX IDX_A1734D1FF6BD1646 (site_id), PRIMARY KEY(item_id, site_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;’: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘item_site’ already exists in /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:57 Stack trace: #0 /home/hiddenga/test.hiddengalleries.eu/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/hiddenga/test.hiddengalleries.eu/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/hiddenga/test.hiddengalleries.eu/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 it…’, Array) #3 /home/hiddenga/test.hiddengalleries.eu/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1569): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), ‘CREATE TABLE it…’) #4 /home/hiddenga/test.hiddengalleries.eu/application/data/migrations/20200224022356_SiteItems.php(28): Doctrine\DBAL\Connection->exec(‘CREATE TABLE it…’) #5 /home/hiddenga/test.hiddengalleries.eu/application/src/Db/Migration/Manager.php(80): Omeka\Db\Migrations\SiteItems->up(Object(Doctrine\DBAL\Connection)) #6 /home/hiddenga/test.hiddengalleries.eu/application/src/Controller/MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade() #7 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(77): Omeka\Controller\MigrateController->indexAction() #8 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #9 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #10 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(103): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #11 /home/hiddenga/test.hiddengalleries.eu/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/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #13 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #14 /home/hiddenga/test.hiddengalleries.eu/vendor/laminas/laminas-mvc/src/Application.php(331): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #15 /home/hiddenga/test.hiddengalleries.eu/index.php(21): Laminas\Mvc\Application->run() #16 {main}

jflatnes · January 19, 2022, 11:08pm

Where did you restore it from?

The item_site table this error is mentioning is only added by the upgrade to 3.0. Since it’s saying it’s there already, there’s something odd about your database, even the restored one. It’s possible your restore process only replaced the tables actually that were part of your 2.0.2 backup, so it’s just not touching this out-of-place 3.0 table.

You can try to just manually remove the item_site table from your database, if you’re comfortable with that. Alternatively you can load your backup into a fresh, empty, database.

pfernandez · January 20, 2022, 9:44pm

Thank you so much, John.
Deleting that table worked.
Upgrade done!
I very much appreciate your help.
Best,
Pedro