**Mautic 3.3 My PHP version is : 7.3.2.6
*My MySQL 8.0.22 - MySQL Community Server - GPL
Updating/Installing Errors
Database migration issue with the folowing error, any help will be appreciate
Updating database schema…
In AbstractMySQLDriver.php line 106:
An exception occurred while executing ‘ALTER TABLE ma_oauth2_accesstokens A
DD CONSTRAINT FK_AD7042B419EB6921 FOREIGN KEY (client_id) REFERENCES ma_oau
th2_clients (id) ON DELETE CASCADE’:
SQLSTATE[HY000]: General error: 3780 Referencing column ‘client_id’ and ref
erenced column ‘id’ in foreign key constraint ‘FK_AD7042B419EB6921’ are inc
ompatible.
In PDOConnection.php line 80:
SQLSTATE[HY000]: General error: 3780 Referencing column ‘client_id’ and ref
erenced column ‘id’ in foreign key constraint ‘FK_AD7042B419EB6921’ are inc
ompatible.
In PDOConnection.php line 75:
SQLSTATE[HY000]: General error: 3780 Referencing column ‘client_id’ and ref
erenced column ‘id’ in foreign key constraint ‘FK_AD7042B419EB6921’ are inc
ompatible.
Already posted in the referenced thread, but in case someone here still has the same problem: I created a tool to address these issues. I was able to fix the problem in the end, although it required hundreds of SQL queries.