# 134 Executed Unavailable Migrations - unable to doctrine:schema:update - foreign key constraint 'FK\_3A18CA5A19EB6921'

**URL:** <https://forum.mautic.org/t/134-executed-unavailable-migrations-unable-to-doctrineupdate-foreign-key-constraint-fk-3a18ca5a19eb6921/15850>\
**Category:** Product Support\
**Created:** [August 28, 2020, 4:13pm UTC](https://forum.mautic.org/t/134-executed-unavailable-migrations-unable-to-doctrineupdate-foreign-key-constraint-fk-3a18ca5a19eb6921/15850 "2020-08-28T16:13:25Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![maumatic](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/maumatic/32/3284_2.png) [@maumatic](https://forum.mautic.org/u/maumatic)\
**Post date:** [September 2, 2020, 2:01pm UTC](https://forum.mautic.org/t/134-executed-unavailable-migrations-unable-to-doctrineupdate-foreign-key-constraint-fk-3a18ca5a19eb6921/15850/3 "2020-09-02T14:01:08Z")

</div>

Thank you very much @madpet 🙂

With your help I think I fixed the 134 “`Executed Unavailable Migrations`” problem.

Now I still have the `doctrine:schema:update` which is failing with the message:  
`General error: 1832 Cannot change column 'client_id': used in a foreign key constraint 'FK_3A18CA5A19EB6921'`

When I run `doctrine:schema:update --dump-sql` I have more than 100 SQL statements to be executed to bring my database up to date. So far it’s working ok like that but I fear one day it won’t anymore, so I still would like to do this update.

Any hint about fixing this foreign key constraint ?

---

_[View the full topic](https://forum.mautic.org/t/134-executed-unavailable-migrations-unable-to-doctrineupdate-foreign-key-constraint-fk-3a18ca5a19eb6921/15850)._