Migrate error during installation

[blackbart420]

Hello, I get the following error when running the database migrate command on installation:

Column `project_id` on table `dashboards` does not match column `id` on `projects`, which has type `int(11)`. To resolve this issue, change the type of the `project_id` column on `dashboards` to be :integer. (For example `t.integer :project_id`).
Original message: Mysql2::Error: Can't create table `redmine_default`.`dashboards` (errno: 150 "Foreign key constraint is incorrectly formed")

I have the current redmine version: 4.2.3 and Ruby 2.7.0

Do you have a clue what's wrong?

Thanks

[alexandermeindl]

Which version of additionals do you use? And which database (version) you use?

additionals migration should create dashboards table with the column project_id as integer, see https://github.com/AlphaNodes/additionals/blob/main/db/migrate/003_create_dashboards.rb#L13

If this is not the case in your environment, maybe your database does not respect rails settings, which should be used from reference table. MySQL 8 works in our tests, see https://github.com/AlphaNodes/additionals/blob/main/.github/workflows/tests.yml#L41
Maybe an old mysql server version raises the problem. The problem cannot be fixed in your plugin.

More information to this topic can be found here: rails/rails#30806

[blackbart420]

Thank you for your answer.
I tried to install the last version of Additionals (3.0.4).
with redmine 4.2.3
ruby 2.7.0
rails 5.2.6
and mysql Ver 15.1 Distrib 10.3.32-MariaDB

So maybe the mariadb version is too old ?