Upgrade to 9.2.0 fails under Windows11 local xampp environment

Hi There,
Getting this error when trying to upgrade to 9.2.0 from 9.1.3 in my Windows 11 local environment (lower case table names) PHP 8.1.10:

Exception Occurred: C:\xampp\htdocs\updates\concrete-cms-9.2.0\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php:128 An exception occurred while executing ‘ALTER TABLE oauth2clientscopes ADD CONSTRAINT FK_497E26F39ECFF1A8 FOREIGN KEY (clientIdentifier) REFERENCES OAuth2Client (identifier) ON DELETE CASCADE’:

SQLSTATE[HY000]: General error: 1005 Can’t create table cmw_test.oauth2clientscopes (errno: 150 “Foreign key constraint is incorrectly formed”) (0)

Haven’t tried in a hosted test environment yet. Has anyone encountered this issue ?

Thanks & regards,


There is a setting in camp that stops table from being renames to lowercase on windows.

1 Like

Thanks @TMDesigns,

I’d assume I would have to refresh this local site again from a hosted environment (Mixed case table names) after setting the local xampp env for normal mixed case names ?


Yes that’s correct, I would do a test on the new dB