Upgrade to 9.2.0 fails under Windows11 local xampp environment

Developing with Concrete
1

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,

Jeff.

2

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

1 Like
3

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 ?

Jeff.

4

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