Errors after running schema:update - foreign key constraint

Why do you use schema update force command in prod. env.? Please use bin/console doctrine:migrations:migrate.

Also since it seems like a problem related to incomplete migrations from the past, you might benefit from reading this: MySQL error upgrading to 4.2 - #9 by cwmarketing

I would avoid any upgrades until you resolve the issues with migration.