Migrations failing on fresh install in fresh db in mariaDB Almalinux 9

[CarlSinclair]

PDOException: SQLSTATE[HY000]: General error: 1833 Cannot change column 'id': used in a foreign key constraint 'movim/caches_user_id_foreign' of table 'movim/caches' in /var/www/html/movim/vendor/illuminate/database/Connection.php:587
Stack trace:
#0 /var/www/html/movim/vendor/illuminate/database/Connection.php(587): PDOStatement->execute()
#1 /var/www/html/movim/vendor/illuminate/database/Connection.php(816): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#2 /var/www/html/movim/vendor/illuminate/database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/html/movim/vendor/illuminate/database/Connection.php(576): Illuminate\Database\Connection->run()
#4 /var/www/html/movim/vendor/illuminate/database/Schema/Blueprint.php(110): Illuminate\Database\Connection->statement()
#5 /var/www/html/movim/vendor/illuminate/database/Schema/Builder.php(602): Illuminate\Database\Schema\Blueprint->build()
#6 /var/www/html/movim/vendor/illuminate/database/Schema/Builder.php(444): Illuminate\Database\Schema\Builder->build()
#7 /var/www/html/movim/database/migrations/20180510141439_change_length_contacts_id.php(30): Illuminate\Database\Schema\Builder->table()
#8 /var/www/html/movim/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(111): ChangeLengthContactsId->up()
#9 /var/www/html/movim/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(388): Phinx\Migration\Manager\Environment->executeMigration()
#10 /var/www/html/movim/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(359): Phinx\Migration\Manager->executeMigration()
#11 /var/www/html/movim/vendor/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(122): Phinx\Migration\Manager->migrate()
#12 /var/www/html/movim/vendor/symfony/console/Command/Command.php(326): Phinx\Console\Command\Migrate->execute()
#13 /var/www/html/movim/vendor/symfony/console/Application.php(1078): Symfony\Component\Console\Command\Command->run()
#14 /var/www/html/movim/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand()
#15 /var/www/html/movim/vendor/robmorgan/phinx/src/Phinx/Console/PhinxApplication.php(70): Symfony\Component\Console\Application->doRun()
#16 /var/www/html/movim/vendor/symfony/console/Application.php(175): Phinx\Console\PhinxApplication->doRun()
#17 /var/www/html/movim/vendor/robmorgan/phinx/bin/phinx(28): Symfony\Component\Console\Application->run()
#18 /var/www/html/movim/vendor/bin/phinx(119): include('...')
#19 {main}

Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1833 Cannot change column 'id': used in a foreign key constraint 'movim/caches_user_id_foreign' of table 'movim/caches' (Connection: default, SQL: ALTER TABLE users CHANGE id id VARCHAR(256) NOT NULL) in /var/www/html/movim/vendor/illuminate/database/Connection.php:829
Stack trace:
#0 /var/www/html/movim/vendor/illuminate/database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/movim/vendor/illuminate/database/Connection.php(576): Illuminate\Database\Connection->run()
#2 /var/www/html/movim/vendor/illuminate/database/Schema/Blueprint.php(110): Illuminate\Database\Connection->statement()
#3 /var/www/html/movim/vendor/illuminate/database/Schema/Builder.php(602): Illuminate\Database\Schema\Blueprint->build()
#4 /var/www/html/movim/vendor/illuminate/database/Schema/Builder.php(444): Illuminate\Database\Schema\Builder->build()
#5 /var/www/html/movim/database/migrations/20180510141439_change_length_contacts_id.php(30): Illuminate\Database\Schema\Builder->table()
#6 /var/www/html/movim/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(111): ChangeLengthContactsId->up()
#7 /var/www/html/movim/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(388): Phinx\Migration\Manager\Environment->executeMigration()
#8 /var/www/html/movim/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(359): Phinx\Migration\Manager->executeMigration()
#9 /var/www/html/movim/vendor/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(122): Phinx\Migration\Manager->migrate()
#10 /var/www/html/movim/vendor/symfony/console/Command/Command.php(326): Phinx\Console\Command\Migrate->execute()
#11 /var/www/html/movim/vendor/symfony/console/Application.php(1078): Symfony\Component\Console\Command\Command->run()
#12 /var/www/html/movim/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand()
#13 /var/www/html/movim/vendor/robmorgan/phinx/src/Phinx/Console/PhinxApplication.php(70): Symfony\Component\Console\Application->doRun()
#14 /var/www/html/movim/vendor/symfony/console/Application.php(175): Phinx\Console\PhinxApplication->doRun()
#15 /var/www/html/movim/vendor/robmorgan/phinx/bin/phinx(28): Symfony\Component\Console\Application->run()
#16 /var/www/html/movim/vendor/bin/phinx(119): include('...')
#17 {main}
Script vendor/bin/phinx migrate --ansi handling the movim:migrate event returned with error code 1

[edhelas]

What is you MariaDB version. Also there is a lot of chances that your distro is enforcing some behavior, I cannot test them against the multiple MySQL/MariaDB flags that exists, do check your error on Stackoverflow and see if there's a specific config on your side to change in your database config.

[CarlSinclair]

Ver 15.1 Distrib 10.11.7-MariaDB, for Linux (x86_64) using EditLine wrapper

Pretty weird that this happened on a fresh install though, following the instructions.

[edhelas]

Hello, got any news regarding that issue ?

[CarlSinclair]

What info do you need? I provided the MariaDB version.

[edhelas]

As I was saying above, I'm not planning to test Movim on the myriad of MySQL/MariaDB flavors, but I'm open to integrate fixes that you may find along the way.

[CarlSinclair]

I tried setting it up using Postgres but ran into other problems probably due to the fact that I'm on RHEL, so I'm just going to give up on it for now until I set up a Debian-based machine.