How to reproduce
- Download and install concrete5.7.5.6.
- Setup multilingual website with demo contents. I followed https://youtu.be/bZIqxGAS1FE
- Replace concrete directory with 5.7.5.13
- Run /ccm/system/upgrade.
- Replace concrete directory with 8.4.0RC2
- Run /ccm/system/upgrade and it's failed.
An exception occurred while executing 'ALTER TABLE FileImageThumbnailTypeFileSets ADD CONSTRAINT FK_BD75F88D480660E5 FOREIGN KEY (ftfsThumbnailType) REFERENCES FileImageThumbnailTypes (ftTypeID) ON DELETE CASCADE': SQLSTATE[HY000]: General error: 1822 Failed to add the foreign key constaint. Missing index for constraint 'FK_BD75F88D480660E5' in the referenced table 'FileImageThumbnailTypes'
Environment Info
Laravel valet
Server: nginx
php: 5.6.33
MySQL: 5.7.21
sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
[Also tried with sql_mode: '']
How to reproduce
Environment Info
Laravel valet
Server: nginx
php: 5.6.33
MySQL: 5.7.21
sql_mode:
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION[Also tried with sql_mode: '']