9.5.4からでも9.5.2からでも、さくらインターネットで運用しているサイトでもエックスサーバーで運用しているサイトでも、「管理画面＞システムと設定＞Concrete をアップデート＞更新を適用」ページで「更新をインストール」ボタンを押すとエラーになります。
このエラーをAIに相談したら、下記の回答でした。
「既存の外部キー制約がカラムの変更をブロックしていることが原因です。この制約があるため、Concrete CMSのアップデート時にカラムの変更処理がブロックされています。一時的にこの外部キー制約を削除することで、アップデートを正常に進めることができます。」
下記SQLを実行するしかアップデートできないのでしょうか？
ALTER TABLE PageContainerInstances DROP FOREIGN KEY FK_～～～;
エラー文を全て貼っていただけると調査が可能です。よろしくお願いします
よろしくお願いいたします。
PDOException Exception DriverException
HTTP 500 Internal Server Error
An exception occurred while executing ‘ALTER TABLE PageContainerInstances CHANGE containerID containerID INT NOT NULL’:
SQLSTATE[HY000]: General error: 1832 Cannot change column ‘containerID’: used in a foreign key constraint ‘FK_英数羅列’
Exceptions 3Stack Traces 3
【Exceptions】
Doctrine\DBAL\Exception
DriverException
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php (line 128)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php → convertException (line 182)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php :: wrapException (line 159)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php :: driverExceptionDuringQuery (line 2222)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php → handleExceptionDuringQuery (line 1537)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php → executeStatement (line 942)
SchemaTool->updateSchema(array(object(ClassMetadata)), true)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Updater/Migrations/AbstractMigration.php (line 125)
foreach ($entities as $entity) { $this->output(t(‘Refreshing schema for %s…’, $entity)); $classes = $em->getClassMetadata($entity); } $tool->updateSchema($classes, true); } protected function refreshDatabaseTables($tables) { $this->output(t(‘Updating database tables found in doctrine xml…’));
AbstractMigration->refreshEntities(array(‘Concrete\Core\Entity\Page\Container\Instance’))
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Updater/Migrations/Migrations/Version20260914000000.php (line 21)
Version20260914000000->upgradeDatabase()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Updater/Migrations/AbstractMigration.php (line 84)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/migrations/lib/Doctrine/Migrations/Version/Executor.php → postUp (line 233)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/migrations/lib/Doctrine/Migrations/Version/Executor.php → executeMigration (line 129)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/migrations/lib/Doctrine/Migrations/Version/Version.php → execute (line 184)
Version->execute(‘up’)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Updater/Update.php (line 248)
Update::updateToCurrentVersion()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Application/Application.php (line 225)
Application->Concrete\Core\Application{closure}()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/System/Mutex/SemaphoreMutex.php (line 139)
SemaphoreMutex->execute(‘core_system_upgrade’, object(Closure))
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Application/Application.php (line 224)
Application->handleAutomaticUpdates()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Foundation/Runtime/Run/DefaultRunner.php (line 277)
DefaultRunner->handleUpdates()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Foundation/Runtime/Run/DefaultRunner.php (line 329)
DefaultRunner->trySteps(array(‘setSystemLocale’, ‘initializeSystemTimezone’, ‘handleUpdates’, ‘setupPackages’, ‘preloadClassAliases’, ‘initializeSiteTimezone’, ‘initializeLegacyUrlDefinitions’, ‘registerLegacyConfigValues’, ‘handlePermissionKeys’, ‘handleEventing’))
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Foundation/Runtime/Run/DefaultRunner.php (line 76)
DefaultRunner->run()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Foundation/Runtime/DefaultRuntime.php (line 102)
DefaultRuntime->run()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/dispatcher.php (line 45)
require(‘/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/dispatcher.php’)
in /home/ユーザー/ドメイン/public_html/concrete/bootstrap/configure.php (line 55)
require(‘/home/ユーザー/ドメイン/public_html/concrete/bootstrap/configure.php’)
in /home/ユーザー/ドメイン/public_html/concrete/dispatcher.php (line 13)
require(‘/home/ユーザー/ドメイン/public_html/concrete/dispatcher.php’)
in /home/ユーザー/ドメイン/public_html/index.php (line 3)
Doctrine\DBAL\Driver\PDO
Exception
SQLSTATE[HY000]: General error: 1832 Cannot change column ‘containerID’: used in a foreign key constraint ‘FK_英数羅列’
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php (line 18)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php :: new (line 60)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php → exec (line 1534)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php → executeStatement (line 942)
SchemaTool->updateSchema(array(object(ClassMetadata)), true)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Updater/Migrations/AbstractMigration.php (line 125)
foreach ($entities as $entity) { $this->output(t(‘Refreshing schema for %s…’, $entity)); $classes = $em->getClassMetadata($entity); } $tool->updateSchema($classes, true); } protected function refreshDatabaseTables($tables) { $this->output(t(‘Updating database tables found in doctrine xml…’));
AbstractMigration->refreshEntities(array(‘Concrete\Core\Entity\Page\Container\Instance’))
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Updater/Migrations/Migrations/Version20260914000000.php (line 21)
Version20260914000000->upgradeDatabase()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Updater/Migrations/AbstractMigration.php (line 84)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/migrations/lib/Doctrine/Migrations/Version/Executor.php → postUp (line 233)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/migrations/lib/Doctrine/Migrations/Version/Executor.php → executeMigration (line 129)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/migrations/lib/Doctrine/Migrations/Version/Version.php → execute (line 184)
Version->execute(‘up’)
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Updater/Update.php (line 248)
Update::updateToCurrentVersion()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Application/Application.php (line 225)
Application->Concrete\Core\Application{closure}()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/System/Mutex/SemaphoreMutex.php (line 139)
SemaphoreMutex->execute(‘core_system_upgrade’, object(Closure))
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Application/Application.php (line 224)
Application->handleAutomaticUpdates()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Foundation/Runtime/Run/DefaultRunner.php (line 277)
DefaultRunner->handleUpdates()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Foundation/Runtime/Run/DefaultRunner.php (line 329)
DefaultRunner->trySteps(array(‘setSystemLocale’, ‘initializeSystemTimezone’, ‘handleUpdates’, ‘setupPackages’, ‘preloadClassAliases’, ‘initializeSiteTimezone’, ‘initializeLegacyUrlDefinitions’, ‘registerLegacyConfigValues’, ‘handlePermissionKeys’, ‘handleEventing’))
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Foundation/Runtime/Run/DefaultRunner.php (line 76)
DefaultRunner->run()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Foundation/Runtime/DefaultRuntime.php (line 102)
DefaultRuntime->run()
in /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/dispatcher.php (line 45)
require(‘/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/dispatcher.php’)
in /home/ユーザー/ドメイン/public_html/concrete/bootstrap/configure.php (line 55)
require(‘/home/ユーザー/ドメイン/public_html/concrete/bootstrap/configure.php’)
in /home/ユーザー/ドメイン/public_html/concrete/dispatcher.php (line 13)
require(‘/home/ユーザー/ドメイン/public_html/concrete/dispatcher.php’)
in /home/ユーザー/ドメイン/public_html/index.php (line 3)
PDOException
SQLSTATE[HY000]: General error: 1832 Cannot change column ‘containerID’: used in a foreign key constraint ‘FK_英数羅列’
【Stack Traces】
[3/3] DriverException
Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing ‘ALTER TABLE PageContainerInstances CHANGE containerID containerID INT NOT NULL’:
SQLSTATE[HY000]: General error: 1832 Cannot change column ‘containerID’: used in a foreign key constraint ‘FK_英数羅列’
at /home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128
at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception occurred while executing ‘ALTER TABLE PageContainerInstances CHANGE containerID containerID INT NOT NULL’:SQLSTATE[HY000]: General error: 1832 Cannot change column ‘containerID’: used in a foreign key constraint ‘FK_英数羅列’’, object(Exception))
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182)
at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(Exception), ‘An exception occurred while executing ‘ALTER TABLE PageContainerInstances CHANGE containerID containerID INT NOT NULL’:SQLSTATE[HY000]: General error: 1832 Cannot change column ‘containerID’: used in a foreign key constraint ‘FK_英数羅列’’)
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159)
at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(Exception), ‘ALTER TABLE PageContainerInstances CHANGE containerID containerID INT NOT NULL’, array())
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2222)
at Doctrine\DBAL\Connection->handleExceptionDuringQuery(object(Exception), ‘ALTER TABLE PageContainerInstances CHANGE containerID containerID INT NOT NULL’, array(), array())
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1537)
at Doctrine\DBAL\Connection->executeStatement(‘ALTER TABLE PageContainerInstances CHANGE containerID containerID INT NOT NULL’)
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php:942)
at Doctrine\ORM\Tools\SchemaTool->updateSchema(array(object(ClassMetadata)), true)
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Updater/Migrations/AbstractMigration.php:125)
at Concrete\Core\Updater\Migrations\AbstractMigration->refreshEntities(array(‘Concrete\Core\Entity\Page\Container\Instance’))
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Updater/Migrations/Migrations/Version20260914000000.php:21)
at Concrete\Core\Updater\Migrations\Migrations\Version20260914000000->upgradeDatabase()
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Updater/Migrations/AbstractMigration.php:84)
at Concrete\Core\Updater\Migrations\AbstractMigration->postUp(object(Generated758751bc7b6c5f97996c4128e65e15aa))
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/migrations/lib/Doctrine/Migrations/Version/Executor.php:233)
at Doctrine\Migrations\Version\Executor->executeMigration(object(Version), object(Version20260914000000), object(ExecutionResult), ‘up’, object(MigratorConfiguration))
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/migrations/lib/Doctrine/Migrations/Version/Executor.php:129)
at Doctrine\Migrations\Version\Executor->execute(object(Version), object(Version20260914000000), ‘up’, object(MigratorConfiguration))
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/vendor/doctrine/migrations/lib/Doctrine/Migrations/Version/Version.php:184)
at Doctrine\Migrations\Version\Version->execute(‘up’)
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Updater/Update.php:248)
at Concrete\Core\Updater\Update::updateToCurrentVersion()
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Application/Application.php:225)
at Concrete\Core\Application\Application->Concrete\Core\Application{closure}()
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/System/Mutex/SemaphoreMutex.php:139)
at Concrete\Core\System\Mutex\SemaphoreMutex->execute(‘core_system_upgrade’, object(Closure))
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Application/Application.php:224)
at Concrete\Core\Application\Application->handleAutomaticUpdates()
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Foundation/Runtime/Run/DefaultRunner.php:277)
at Concrete\Core\Foundation\Runtime\Run\DefaultRunner->handleUpdates()
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Foundation/Runtime/Run/DefaultRunner.php:329)
at Concrete\Core\Foundation\Runtime\Run\DefaultRunner->trySteps(array(‘setSystemLocale’, ‘initializeSystemTimezone’, ‘handleUpdates’, ‘setupPackages’, ‘preloadClassAliases’, ‘initializeSiteTimezone’, ‘initializeLegacyUrlDefinitions’, ‘registerLegacyConfigValues’, ‘handlePermissionKeys’, ‘handleEventing’))
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Foundation/Runtime/Run/DefaultRunner.php:76)
at Concrete\Core\Foundation\Runtime\Run\DefaultRunner->run()
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/src/Foundation/Runtime/DefaultRuntime.php:102)
at Concrete\Core\Foundation\Runtime\DefaultRuntime->run()
(/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/dispatcher.php:45)
at require(‘/home/ユーザー/ドメイン/public_html/updates/concrete-cms-9.5.5-remote-updater/concrete/dispatcher.php’)
(/home/ユーザー/ドメイン/public_html/concrete/bootstrap/configure.php:55)
at require(‘/home/ユーザー/ドメイン/public_html/concrete/bootstrap/configure.php’)
(/home/ユーザー/ドメイン/public_html/concrete/dispatcher.php:13)
at require(‘/home/ユーザー/ドメイン/public_html/concrete/dispatcher.php’)
(/home/ユーザー/ドメイン/public_html/index.php:3)
[2/3] Exception
[1/3] PDOException
その件はもう修正されてるので、次のバージョンを待った方がよさそうです。
そうなのですね。
ありがとうございます🙇🏻