Your software My Mautic version is: 3.1.0 My PHP version is: 7.3.20 My MariaDB version is : 10.5 Your problem My problem is: There are 134 Executed Unavailable Migrations Here’s the migration status: [root@vps mmm.mysite.com]# php bin/console cache:clear // Clearing the cache for the pro…

Thank you very much @madpet :slight_smile: 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_3A…

I can’t help you with the foreign key error. I suppose you need to debug exactly what is going on. Once way is to use doctrine:schema:update --dump-sql to see what queries are needed and then simply run them manually one at a time in the MySQL console. Then eventually you will hit the one that cause…

[image] maumatic: General error: 1832 Cannot change column ‘client_id’: used in a foreign key constraint ‘FK_3A18CA5A19EB6921’ So here’s what I tried to solve this foreign key problem: I disabled the foreign key checks in mysql and then tried to run the first SQL statement given by doctrine:s…

Nope, sorry. I don’t know anything about oauth2 or foreign keys in this context. Hopefully someone else can assist.

I have same problem after upgrading to 3.1.0 from 3.0.2 and after trying to check database scheme. [schema_error] . In my case all is very strange as mysql doesn’t properly respond to SET foreign_key_checks = 0; and throws a lot of table constraints’ errors. I have actually tried manually drop …

I have the exact same problem. I couldn’t find any bug report, so I created one: https://github.com/mautic/mautic/issues/9185

@maumatic If you still have the problem, try looking here for an explanation and recommendations to fix: https://github.com/mautic/mautic/issues/9129#issuecomment-696010876

I could finally update my database scheme, I explained how I did here: oAuth Access token Foreign Key on client_id opened 01:21PM - 26 Aug 20 UTC (UTC) [colourfulowl] colourfulowl …

134 Executed Unavailable Migrations - unable to doctrine:schema:update - foreign key constraint 'FK_3A18CA5A19EB6921'

Product Support

madpet September 2, 2020, 12:26pm 2

Hi @maumatic please see my detailed explanation over here. It should answer the question

Topic		Replies	Views
Errors after running schema:update - foreign key constraint Product Support	16	4371	September 12, 2022
Should doctrine:migration:migrate and doctrine:schema:update --force ever be run manually? Product Support discussion , education	6	9195	January 2, 2024
Database migration error FOREIGN KEY constraint Mautic 3 - Install/Upgrade Support	4	1385	July 8, 2024
Error Updating from Mautic 3.0 -->3.01 Mautic 3 - Install/Upgrade Support	11	2371	July 8, 2024
Error while upgrading from 3.3.4 to 4.0 Mautic 4 Install/Upgrade Support	7	3284	May 1, 2022

134 Executed Unavailable Migrations - unable to doctrine:schema:update - foreign key constraint 'FK_3A18CA5A19EB6921'

Related topics