Database migration error FOREIGN KEY constraint

[pboisdenghien]

**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.

[hhjchen]

@pboisdenghien were you able to get through this? If so, could you share? I’m seeing a similar error. Thx!

[aerendir]

Did you solved this? I’m facing the same issue (and trying to fix it, but it is really hard and annoying )

[aerendir]

I’ve just replied here giving a bit more context about the issue: it is the same issue

Error Updating from Mautic 3.0 -->3.01

Dropping the foreign key doesn’t work. Once dropped, running a bin/console doctrine:schema:update --force tries to recreate the foreign key, but the query results in an error: An exception occurred while executing ‘ALTER TABLE *_oauth2_accesstokens ADD CONSTRAINT FK_E6019FAD19EB6921 FOREIGN KEY (client_id) REFERENCES *_oauth2_clients (id) ON DELETE CASCADE’: SQLSTATE[HY000]: General error: 3780 Referencing column ‘client_id’ and referenced column ‘id’ in foreign key constraint ‘FK_E6019FAD19…