# Error updating 1.2.0 (db error)

**URL:** <https://forum.mautic.org/t/error-updating-1-2-0-db-error/2307>\
**Category:** Product Support\
**Created:** [September 8, 2015, 3:56pm UTC](https://forum.mautic.org/t/error-updating-1-2-0-db-error/2307 "2015-09-08T15:56:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![enzo](https://avatars.discourse-cdn.com/v4/letter/e/3ab097/32.png) [@enzo](https://forum.mautic.org/u/enzo)\
**Post date:** [September 8, 2015, 3:56pm UTC](https://forum.mautic.org/t/error-updating-1-2-0-db-error/2307/1 "2015-09-08T15:56:04Z")

</div>

ALTER TABLE form\_fields CHANGE form\_id form\_id INT NOT NULL Migration 20150724000000 failed during Execution. Error An exception occurred while executing ‘ALTER TABLE form\_fields CHANGE form\_id form\_id INT NOT NULL’: SQLSTATE[HY000]: General error: 1832 Cannot change column ‘form\_id’: used in a foreign key constraint ‘FK\_7C0B37265FF69B7D’ [DoctrineDBALDBALException] An exception occurred while executing ‘ALTER TABLE form\_fields CHANGE form\_id form\_id INT NOT NULL’: SQLSTATE[HY000]: General error: 1832 Cannot change column ‘form\_id’: used in a foreign key constraint ‘FK\_7C0B37265FF69B7D’ [PDOException] SQLSTATE[HY000]: General error: 1832 Cannot change column ‘form\_id’: used in a foreign key constraint ‘FK\_7C0B37265FF69B7D’ doctrine:migrations:migrate ] ] ] [version] [] []  
  
  
  
I solved this error deleting all forms

---

<div class="post-metadata">

**Author:** ![enzo](https://avatars.discourse-cdn.com/v4/letter/e/3ab097/32.png) [@enzo](https://forum.mautic.org/u/enzo)\
**Post date:** [September 8, 2015, 3:56pm UTC](https://forum.mautic.org/t/error-updating-1-2-0-db-error/2307/2 "2015-09-08T15:56:04Z")

</div>

ALTER TABLE form\_fields CHANGE form\_id form\_id INT NOT NULL Migration 20150724000000 failed during Execution. Error An exception occurred while executing ‘ALTER TABLE form\_fields CHANGE form\_id form\_id INT NOT NULL’: SQLSTATE[HY000]: General error: 1832 Cannot change column ‘form\_id’: used in a foreign key constraint ‘FK\_7C0B37265FF69B7D’ [DoctrineDBALDBALException] An exception occurred while executing ‘ALTER TABLE form\_fields CHANGE form\_id form\_id INT NOT NULL’: SQLSTATE[HY000]: General error: 1832 Cannot change column ‘form\_id’: used in a foreign key constraint ‘FK\_7C0B37265FF69B7D’ [PDOException] SQLSTATE[HY000]: General error: 1832 Cannot change column ‘form\_id’: used in a foreign key constraint ‘FK\_7C0B37265FF69B7D’ doctrine:migrations:migrate [–write-sql] [–dry-run] [–query-time] [–configuration[="…"]] [–db-configuration[="…"]] [–em[="…"]] [version] [] []

I solved this error deleting all forms

---

<div class="post-metadata">

**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\
**Post date:** [September 10, 2015, 8:17am UTC](https://forum.mautic.org/t/error-updating-1-2-0-db-error/2307/3 "2015-09-10T08:17:06Z")

</div>

I wrote an article about failed upgrade. Hope it helps [http://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful](http://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful)

---

<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 2, 2020, 10:58pm UTC](https://forum.mautic.org/t/error-updating-1-2-0-db-error/2307/4 "2020-02-02T22:58:33Z")

</div>

Closed on February 2, 2020, 10:58pm UTC