Hello,
I am trying to upgrade to Omeka S version 2.1.2 from version 1.1.1.
I get the Omeka S encountered a problem screen during the update and this is the error log:
2020-08-13T18:07:10+00:00 ERR (3): PDOException: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘FK_694309E47E3C61F9’; check that column/key exists in C:\laragon\www\omeka\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:41
Stack trace:
#0 C:\laragon\www\omeka\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(41): PDO->exec(‘ALTER TABLE sit…’)
#1 C:\laragon\www\omeka\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(1094): Doctrine\DBAL\Driver\PDOConnection->exec(‘ALTER TABLE sit…’)
#2 C:\laragon\www\omeka\application\data\migrations\20190412090532_SiteUserOnDelete.php(11): Doctrine\DBAL\Connection->exec(‘ALTER TABLE sit…’)
#3 C:\laragon\www\omeka\application\src\Db\Migration\Manager.php(80): Omeka\Db\Migrations\SiteUserOnDelete->up(Object(Doctrine\DBAL\Connection))
#4 C:\laragon\www\omeka\application\src\Controller\MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade()
#5 C:\laragon\www\omeka\vendor\zendframework\zend-mvc\src\Controller\AbstractActionController.php(78): Omeka\Controller\MigrateController->indexAction()
#6 C:\laragon\www\omeka\vendor\zendframework\zend-eventmanager\src\EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#7 C:\laragon\www\omeka\vendor\zendframework\zend-eventmanager\src\EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))
#8 C:\laragon\www\omeka\vendor\zendframework\zend-mvc\src\Controller\AbstractController.php(106): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#9 C:\laragon\www\omeka\vendor\zendframework\zend-mvc\src\DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#10 C:\laragon\www\omeka\vendor\zendframework\zend-eventmanager\src\EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#11 C:\laragon\www\omeka\vendor\zendframework\zend-eventmanager\src\EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))
#12 C:\laragon\www\omeka\vendor\zendframework\zend-mvc\src\Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#13 C:\laragon\www\omeka\index.php(21): Zend\Mvc\Application->run()
#14 {main}
Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘FK_694309E47E3C61F9’; check that column/key exists in C:\laragon\www\omeka\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:43
Stack trace:
#0 C:\laragon\www\omeka\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(1094): Doctrine\DBAL\Driver\PDOConnection->exec(‘ALTER TABLE sit…’)
#1 C:\laragon\www\omeka\application\data\migrations\20190412090532_SiteUserOnDelete.php(11): Doctrine\DBAL\Connection->exec(‘ALTER TABLE sit…’)
#2 C:\laragon\www\omeka\application\src\Db\Migration\Manager.php(80): Omeka\Db\Migrations\SiteUserOnDelete->up(Object(Doctrine\DBAL\Connection))
#3 C:\laragon\www\omeka\application\src\Controller\MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade()
#4 C:\laragon\www\omeka\vendor\zendframework\zend-mvc\src\Controller\AbstractActionController.php(78): Omeka\Controller\MigrateController->indexAction()
#5 C:\laragon\www\omeka\vendor\zendframework\zend-eventmanager\src\EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#6 C:\laragon\www\omeka\vendor\zendframework\zend-eventmanager\src\EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))
#7 C:\laragon\www\omeka\vendor\zendframework\zend-mvc\src\Controller\AbstractController.php(106): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#8 C:\laragon\www\omeka\vendor\zendframework\zend-mvc\src\DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#9 C:\laragon\www\omeka\vendor\zendframework\zend-eventmanager\src\EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#10 C:\laragon\www\omeka\vendor\zendframework\zend-eventmanager\src\EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))
#11 C:\laragon\www\omeka\vendor\zendframework\zend-mvc\src\Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#12 C:\laragon\www\omeka\index.php(21): Zend\Mvc\Application->run()
#13 {main}
Next Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘ALTER TABLE site DROP FOREIGN KEY FK_694309E47E3C61F9’:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘FK_694309E47E3C61F9’; check that column/key exists in C:\laragon\www\omeka\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php:106
Stack trace:
#0 C:\laragon\www\omeka\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php(169): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDOException))
#1 C:\laragon\www\omeka\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php(145): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘An exception oc…’)
#2 C:\laragon\www\omeka\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(1096): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), ‘ALTER TABLE sit…’)
#3 C:\laragon\www\omeka\application\data\migrations\20190412090532_SiteUserOnDelete.php(11): Doctrine\DBAL\Connection->exec(‘ALTER TABLE sit…’)
#4 C:\laragon\www\omeka\application\src\Db\Migration\Manager.php(80): Omeka\Db\Migrations\SiteUserOnDelete->up(Object(Doctrine\DBAL\Connection))
#5 C:\laragon\www\omeka\application\src\Controller\MigrateController.php(38): Omeka\Db\Migration\Manager->upgrade()
#6 C:\laragon\www\omeka\vendor\zendframework\zend-mvc\src\Controller\AbstractActionController.php(78): Omeka\Controller\MigrateController->indexAction()
#7 C:\laragon\www\omeka\vendor\zendframework\zend-eventmanager\src\EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#8 C:\laragon\www\omeka\vendor\zendframework\zend-eventmanager\src\EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))
#9 C:\laragon\www\omeka\vendor\zendframework\zend-mvc\src\Controller\AbstractController.php(106): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#10 C:\laragon\www\omeka\vendor\zendframework\zend-mvc\src\DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#11 C:\laragon\www\omeka\vendor\zendframework\zend-eventmanager\src\EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#12 C:\laragon\www\omeka\vendor\zendframework\zend-eventmanager\src\EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure))
#13 C:\laragon\www\omeka\vendor\zendframework\zend-mvc\src\Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#14 C:\laragon\www\omeka\index.php(21): Zend\Mvc\Application->run()
#15 {main}
this is happening in:
PHP version 7.2.11, 7.3.5, and 7.4.9.
Mysql 5.5 , 5.7, Mariadb 10.3
Is there something that I am missing or an update that I should do before going to the current version? All help is appreciated.
thank you