# Unable to complete upgrade from v3.2.5 to 3.3

**URL:** <https://forum.mautic.org/t/unable-to-complete-upgrade-from-v3-2-5-to-3-3/18267>\
**Category:** Mautic 3 - Install/Upgrade Support\
**Created:** [February 23, 2021, 11:48am UTC](https://forum.mautic.org/t/unable-to-complete-upgrade-from-v3-2-5-to-3-3/18267 "2021-02-23T11:48:18Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![garzettone](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/garzettone/32/838_2.png) [@garzettone](https://forum.mautic.org/u/garzettone)\
**Post date:** [February 23, 2021, 11:48am UTC](https://forum.mautic.org/t/unable-to-complete-upgrade-from-v3-2-5-to-3-3/18267/1 "2021-02-23T11:48:18Z")

</div>

**Your software**  
_My PHP version is_ : 7.4.15  
\*My MySQL/MariaDB version is MariaDB version  
mysql Ver 15.1 Distrib 10.3.17-MariaDB, for Linux (x86\_64) using readline 5.1

**Updating/Installing Errors**  
I am Updating  
Upgrading via Command Line:  
php bin/console mautic:update:apply  
php bin/console mautic:update:apply --finish

These errors are showing in the installer\* :  
An error occurred while updating the database. Check the logs for more information.

These errors are showing in the Mautic log\* :

console.ERROR: Error thrown while running command “doctrine:migrations:migrate --quiet --no-interaction”. Message: “An exception occurred while executing ‘ALTER TABLE lead\_lists ADD CONSTRAINT FK\_6EC1522A12469DE2 FOREIGN KEY (category\_id) REFERENCES categories (id) ON DELETE SET NULL’: SQLSTATE[HY000]: General error: 1005 Can’t create table `mautic_servizivisionova_com`.`lead_lists` (errno: 150 “Foreign key constraint is incorrectly formed”)” {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘ALTER TABLE lead\_lists ADD CONSTRAINT FK\_6EC1522A12469DE2 FOREIGN KEY (category\_id) REFERENCES categories (id) ON DELETE SET NULL’:\n\nSQLSTATE[HY000]: General error: 1005 Can’t create table `mautic_servizivisionova_com`.`lead_lists` (errno: 150 “Foreign key constraint is incorrectly formed”) at /var/www/mautic/mautic.servizivisionova.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 1005 Can’t create table `mautic_servizivisionova_com`.`lead_lists` (errno: 150 “Foreign key constraint is incorrectly formed”) at /var/www/mautic/mautic.servizivisionova.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1005 Can’t create table `mautic_servizivisionova_com`.`lead_lists` (errno: 150 “Foreign key constraint is incorrectly formed”) at /var/www/mautic/mautic.servizivisionova.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75)",“command”:“doctrine:migrations:migrate --quiet --no-interaction”,“message”:“An exception occurred while executing ‘ALTER TABLE lead\_lists ADD CONSTRAINT FK\_6EC1522A12469DE2 FOREIGN KEY (category\_id) REFERENCES categories (id) ON DELETE SET NULL’:\n\nSQLSTATE[HY000]: General error: 1005 Can’t create table `mautic_servizivisionova_com`.`lead_lists` (errno: 150 “Foreign key constraint is incorrectly formed”)”}

_These errors are showing in the upgrade\_log.txt file (located in the root of your Mautic instance when an upgrade has been attempted - ensure you remove or redact any sensitive data such as domain names in the file path)_ : no file upgrade\_log.txt found

**Your problem**  
_My problem is_ :  
Upgrade failed

_Steps I have tried to fix the problem_ :  
none

---

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [February 23, 2021, 11:53am UTC](https://forum.mautic.org/t/unable-to-complete-upgrade-from-v3-2-5-to-3-3/18267/2 "2021-02-23T11:53:46Z")

</div>

I went and updated from 3.2.4 → 3.2.5 and all of a sudden lost my dashboard.  
Went and upgraded php to 7.4 and ran the CLI update to 3.3 and it kept throwing errors “Could not read the cached update data to apply the update.”

Eventually went back to the UI and saw that everything was updated and now running 3.3.  
I can see the updates in the Forms according to the announcements, however the new email + landing page builder were not packed in the release ☹ sadly. There is a thread on this in slack at the moment, so I am sure that there will be a new release coming in the next day or so.

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [February 23, 2021, 12:45pm UTC](https://forum.mautic.org/t/unable-to-complete-upgrade-from-v3-2-5-to-3-3/18267/3 "2021-02-23T12:45:11Z")

</div>

There is an issue with the upgrade package being tracked in

> <https://github.com/mautic/mautic/issues/9710>
>
> Bug Description
> Hello. After updating from version 3.2.5 to 3.3.0, eager to try the new builder engine, it seems to be unavailable...

and fixed in a PR which will be merged shortly:

> <https://github.com/mautic/mautic/pull/9713>

We will issue a release today to address this - it’s due to some logic in the build script which ignored the builder in the upgrade package only - it is included in the full installation package.

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [February 23, 2021, 12:51pm UTC](https://forum.mautic.org/t/unable-to-complete-upgrade-from-v3-2-5-to-3-3/18267/4 "2021-02-23T12:51:03Z")

</div>

Migration issue is being tracked here with a potential workaround:

> <https://github.com/mautic/mautic/issues/9709>
>
> Bug Description
> When upgrading to 3.3 from 3.2.5 the migrations did not run correctly. The error was
> ALTER TABLE lead\_lists ADD category\_id INT...

---

<div class="post-metadata">

**Author:** ![jcmtnez](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jcmtnez/32/2336_2.png) [@jcmtnez](https://forum.mautic.org/u/jcmtnez)\
**Post date:** [February 28, 2021, 4:48pm UTC](https://forum.mautic.org/t/unable-to-complete-upgrade-from-v3-2-5-to-3-3/18267/5 "2021-02-28T16:48:24Z")

</div>

I updated from v3.2.5 to 3.3.1 and I’m aso missing the blocks inside the dashboard.  
My dashboard has only spinning icons.  
Everything else works, as far as I can tell.

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [February 28, 2021, 9:42pm UTC](https://forum.mautic.org/t/unable-to-complete-upgrade-from-v3-2-5-to-3-3/18267/6 "2021-02-28T21:42:12Z")

</div>

Hi there,

Please can you share how you did the update (in the UI or at command line?) and whether you’ve cleared the cache?

Are there errors in your logs?

Are there errors in the browser console?

---

<div class="post-metadata">

**Author:** ![jcmtnez](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jcmtnez/32/2336_2.png) [@jcmtnez](https://forum.mautic.org/u/jcmtnez)\
**Post date:** [March 3, 2021, 4:49pm UTC](https://forum.mautic.org/t/unable-to-complete-upgrade-from-v3-2-5-to-3-3/18267/7 "2021-03-03T16:49:58Z")

</div>

I used the command line.  
I have cleared the cache multiple times.

---

<div class="post-metadata">

**Author:** ![gabe](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gabe/32/436_2.png) [@gabe](https://forum.mautic.org/u/gabe)\
**Post date:** [March 3, 2021, 5:55pm UTC](https://forum.mautic.org/t/unable-to-complete-upgrade-from-v3-2-5-to-3-3/18267/8 "2021-03-03T17:55:51Z")

</div>

This same thing happened to me when I upgraded to 3.3.1 from 3.2.5. I was able to solve it. You can see how [on github](https://github.com/mautic/mautic/issues/9673#issuecomment-786089401).
