# Database error during update from 3.3.3 to 4.0.1 **URL:** \ **Category:** Mautic 4 Install/Upgrade Support\ **Created:** [October 4, 2021, 8:26pm UTC](https://forum.mautic.org/t/database-error-during-update-from-3-3-3-to-4-0-1/21140 "2021-10-04T20:26:30Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![j007w](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/j007w/32/3279_2.png) [@j007w](https://forum.mautic.org/u/j007w)\ **Post date:** [October 4, 2021, 8:26pm UTC](https://forum.mautic.org/t/database-error-during-update-from-3-3-3-to-4-0-1/21140/1 "2021-10-04T20:26:30Z")
**Your software** _My PHP version is_ : 7.4 _My MySQL/MariaDB version is_ (delete as applicable): 10.4.21 **Updating/Installing Errors** _I am_ (delete as applicable): Updating _Upgrading/installing via_ (delete as applicable) : Command Line _These errors are showing in the installer_ : An error occurred while updating the database. Check log for more details. _These errors are showing in the Mautic log_ : [2021-10-04 20:00:05] mautic.NOTICE: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘SELECT i0\_.is\_published AS is\_published\_0, i0\_.date\_added AS date\_added\_1, i0\_.created\_by AS created\_by\_2, i0\_.created\_by\_user AS created\_by\_user\_3, i0\_.date\_modified AS date\_modified\_4, i0\_.modified\_by AS modified\_by\_5, i0\_.modified\_by\_user AS modified\_by\_user\_6, i0\_.checked\_out AS checked\_out\_7, i0\_.checked\_out\_by AS checked\_out\_by\_8, i0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, i0\_.id AS id\_10, i0\_.name AS name\_11, i0\_.description AS description\_12, i0\_.alias AS alias\_13, i0\_.public\_name AS public\_name\_14, i0\_.filters AS filters\_15, i0\_.is\_global AS is\_global\_16, i0\_.is\_preference\_center AS is\_preference\_center\_17, i0\_.category\_id AS category\_id\_18 FROM mautic\_lead\_lists i0\_ LEFT JOIN mautic\_categories i1\_ ON i0\_.category\_id = i1\_.id ORDER BY i0\_.name ASC’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘i0\_.category\_id’ in ‘field list’ (uncaught exception) at /home/abc/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 while running console command `mautic:segments:update` [2021-10-04 20:00:05] mautic.WARNING: Command `mautic:segments:update` exited with status code 1 [2021-10-04 20:00:07] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘ALTER TABLE mautic\_forms ADD progressive\_profiling\_limit INT(11) DEFAULT NULL;’: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs (uncaught exception) at /home/abc/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 while running console command `doctrine:migrations:migrate` [2021-10-04 20:00:07] mautic.WARNING: Command `doctrine:migrations:migrate` exited with status code 1 [2021-10-04 20:00:07] mautic.WARNING: Command `mautic:update:apply` exited with status code 1 **Your problem** _My problem is_ : I have 2 Mautic instances (2 websites) running on the same server, both running identical versions. I was able to upgrade 1 of the 2 instances successfully. However, on the 2nd instance I received the error as shown above. _Steps I have tried to fix the problem_ : Clear all cache then tried “mautic:update:apply --finish” again. ---
**Author:** ![j007w](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/j007w/32/3279_2.png) [@j007w](https://forum.mautic.org/u/j007w)\ **Post date:** [October 5, 2021, 2:02am UTC](https://forum.mautic.org/t/database-error-during-update-from-3-3-3-to-4-0-1/21140/2 "2021-10-05T02:02:23Z")
I was able to fix this issue by doing a mysql\_upgrade.