database migration error

dexterity42 / SharedProjectTimesheetsBundle

Shared Project Timesheets Bundle - Kimai 2 Plugin

MIT License

9 stars 14 forks source link

database migration error #16

Closed BeckeBauer closed 3 years ago

BeckeBauer commented 3 years ago

I tried to install the plugin but got the following error:

Migration 2020120600000 failed during Execution. Error Unknown database type enum requested, Doctrine\DBAL\Platforms\MariaDb1027Platform may not support it.

[ERROR] Failed to install SharedProjectTimesheetsBundle database: Unknown database type enum requested, Doctrine\DBAL\Platforms\MariaDb1027Platform may not support it.

I am using MariaDB. Any idea how to solve the issue?

dexterity42 commented 3 years ago

Hi @BeckeBauer, i'm sorry to hear that you have problems installing the plugin. Sadly its a little confusing, as none of the migrations are using the enum type. In addition, the MariaDb1027Platform only extends the MysqlPlatform which is the one i've tested the migrations with.

Could you please try if the following settings solve the issue: https://symfony.com/doc/current/doctrine/dbal.html#registering-custom-mapping-types-in-the-schematool

Looking forward to your reply.

BeckeBauer commented 3 years ago

Added the suggested entries to my local.yaml, reloaded the cache and voila, installation went trough smoothly:

Thanks for the help

dexterity42 commented 3 years ago

Good to know - thanks for your response and for closing the issue!