# Can't get past this database incompatibility. Need help

**URL:** https://forum.mautic.org/t/cant-get-past-this-database-incompatibility-need-help/24297
**Category:** Mautic 4 Install/Upgrade Support
**Created:** [June 1, 2022, 2:08am UTC](https://forum.mautic.org/t/cant-get-past-this-database-incompatibility-need-help/24297 "2022-06-01T02:08:58Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![crozilla](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/crozilla/32/2054_2.png) [@crozilla](https://forum.mautic.org/u/crozilla)
#### Post date: [June 1, 2022, 2:08am UTC](https://forum.mautic.org/t/cant-get-past-this-database-incompatibility-need-help/24297/1 "2022-06-01T02:08:59Z")

</div>

**Your software** v4.3.1  
_My PHP version is_ : 7.4  
_My MySQL/MariaDB version is_ (delete as applicable): MySQL/MariaDB version v8.0

**Updating/Installing Errors**  
_I am_: Updating  
_Upgrading/installing via_ : Command Line

_These errors are showing in the installer_ :  
An exception occurred while executing ‘ALTER TABLE oauth2\_accesstokens ADD CONSTRAINT FK\_XXXXXXXXXXXXXXXX FOREIGN KEY (user\_id) REFERENCES users (id) ON DELETE CASCADE’:  
SQLSTATE[HY000]: General error: 3780 Referencing column ‘user\_id’ and referenced column ‘id’ in foreign key constraint ‘FK\_XXXXXXXXXXXXXXXX’ are incompatible.

_These errors are showing in the Mautic log_ :

**Your problem**  
_My problem is_ : I can’t sort this (and I assume other) foreign key constraint issues. Schema update fails, won’t complete.

_Steps I have tried to fix the problem_ :  
I have tried all these tips: [https://docs.mautic.org/en/troubleshooting](https://docs.mautic.org/en/troubleshooting) and these: [https://mauteam.org/mautic/mautic-admins/mautic-update-how-to-dont-click-that-button/](https://mauteam.org/mautic/mautic-admins/mautic-update-how-to-dont-click-that-button/) and even [manually addressing the constraints](https://forum.mautic.org/t/manually-addressing-foreign-key-constraint-error-in-db/24177) in the DB without success.

---

<div class="post-metadata">

### Author: ![crozilla](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/crozilla/32/2054_2.png) [@crozilla](https://forum.mautic.org/u/crozilla)
#### Post date: [June 2, 2022, 2:48pm UTC](https://forum.mautic.org/t/cant-get-past-this-database-incompatibility-need-help/24297/2 "2022-06-02T14:48:08Z")

</div>

I gave up. Installed a fresh 4.3.1 and now have to manually migrate all my data. Fun.
