# DB error when upgrading from 4.1.2 to 4.4.2

**URL:** <https://forum.mautic.org/t/db-error-when-upgrading-from-4-1-2-to-4-4-2/25517>\
**Category:** Mautic 4 Install/Upgrade Support\
**Created:** [September 27, 2022, 9:06am UTC](https://forum.mautic.org/t/db-error-when-upgrading-from-4-1-2-to-4-4-2/25517 "2022-09-27T09:06:23Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![modifiedcontent](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/modifiedcontent/32/511_2.png) [@modifiedcontent](https://forum.mautic.org/u/modifiedcontent)\
**Post date:** [October 17, 2022, 7:51am UTC](https://forum.mautic.org/t/db-error-when-upgrading-from-4-1-2-to-4-4-2/25517/6 "2022-10-17T07:51:03Z")

</div>

@gathh - as explained in the comment I linked earlier I steamrolled through a similar error using the following with failing queries from the upgrade script:

```auto
SET foreign_key_checks = 0;
-- run some queries
SET foreign_key_checks = 1;

```

I fixed - hopefully… - another problem [here](https://forum.mautic.org/t/csv-imports-fail-stalling-in-progress-runtime-less-than-1-second/25199/15) by optimizing/fixing the table that was causing problems via PHPMyAdmin.

That issue apparently has something to do with using InnoDB vs MYISAM as engine and different charsets and collation. One has limits on the size of keys and that is causing all these foreign keys violations all over the place, I guess.

But no word on any of that from Mautic developers so far.

---

_[View the full topic](https://forum.mautic.org/t/db-error-when-upgrading-from-4-1-2-to-4-4-2/25517)._