Cannot change column 'id': used in a foreign key constraint 'koel/interactions_song_id_foreign' of table 'koel/interactions' about koel HOT 4 CLOSED

I am seeing a similar error on installation. Due to this, Koel can not be installed.

[ERROR] Slave SQL: Error 'Cannot change column 'id': used in a foreign key constraint '<CENSORED>/interactions_song_id_foreign' of table '<CENSORED>/interactions'' on query. Default database: '<CENSORED>'. Query: 'ALTER TABLE songs CHANGE id id VARCHAR(36) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`', Internal MariaDB error code: 1833

Environment

• FreeBSD 13.2
• Koel version: 6.11.2 and 6.11.3
• Database: MariaDB 10.16.16 using Galera

from koel.

Hmm, I'm using MariaDB 10.11.12 and this problem doesn't exist at all:

❯ php artisan koel:init
************************************
*     KOEL INSTALLATION WIZARD     *
************************************

As a reminder, you can always install/upgrade manually following the guide at https://docs.koel.dev

  Clearing caches ............................................... 124ms DONE
   INFO  .env file exists -- skipping.

  Retrieving app key .............................................. 0ms DONE

   INFO  Using app key: base64:8sA+Mibai...

  Migrating database .......................................... 7,768ms DONE
  Creating default admin account ................................ 113ms DONE
  Seeding data ................................................... 61ms DONE

How viable is it if I ask you to try this specific DB version?

from koel.

Hello,

I setup MariaDB 10.11.6 with Galera. Unfortunately, it fails with the same error.

2023-12-28 0:11:16 2177 [Warning] WSREP: Ignoring error 'Cannot change column 'id': used in a foreign key constraint 'CENSORED/interactions_song_id_foreign' of table 'CENSORED/interactions'' on query. Default database: 'CENSORED'. Query: 'ALTER TABLE songs CHANGE id id VARCHAR(36) CHARACTER SET utf8mb4 NOT NULL COLLATEutf8mb4_unicode_ci', Error_code: 1833

from koel.

Weird, I'll take a look.

from koel.