[GH-ISSUE #2142] [Bug]: Migrating database fails with "General error: 1829" #1099

Closed
opened 2026-02-26 02:35:14 +03:00 by kerem · 10 comments
Owner

Originally created by @tsawitzki on GitHub (Oct 22, 2025).
Original GitHub issue: https://github.com/koel/koel/issues/2142

Originally assigned to: @phanan on GitHub.

Read the Troubleshooting guide.

  • I have read and followed the Troubleshooting guide

Reproduction steps

Fresh installation on a Hetzner server using MySQL the installation fails with the attached error log, any hint what could cause this issue?

Expected behavior

Installer just doing the migrating thing and be done with it.

Actual behavior

Cryptic error.

Logs

[2025-10-22 12:15:12] production.ERROR: PDOException: SQLSTATE[HY000]: General error: 1829 Cannot drop column 'id': needed in a foreign key constraint 'songs_contributing_artist_id_foreign' of table koelserver.songs in /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:571
Stack trace:
#0 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(571): PDOStatement->execute()
#1 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\Database\Connection->Illuminate\Database{closure}()
#2 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#3 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\Database\Connection->run()
#4 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\Database\Connection->statement()
#5 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\Database\Schema\Blueprint->build()
#6 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\Database\Schema\Builder->build()
#7 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\Builder->table()
#8 /usr/www/users/tswtzk/koel/database/migrations/2025_07_20_165510_promote_public_ids.php(79): Illuminate\Support\Facades\Facade::__callStatic()
#9 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(507): Illuminate\Database\Migrations\Migration@anonymous->up()
#10 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(432): Illuminate\Database\Migrations\Migrator->runMethod()
#11 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(441): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}()
#12 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->runMigration()
#13 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}()
#14 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(798): Illuminate\Console\View\Components\Task->render()
#15 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->write()
#16 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(211): Illuminate\Database\Migrations\Migrator->runUp()
#17 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(138): Illuminate\Database\Migrations\Migrator->runPending()
#18 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(117): Illuminate\Database\Migrations\Migrator->run()
#19 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(658): Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations{closure}()
#20 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\Database\Migrations\Migrator->usingConnection()
#21 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#22 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#23 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#24 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#25 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#26 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call()
#27 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#28 /usr/www/users/tswtzk/koel/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#29 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#30 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#31 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#32 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#33 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Application.php(166): Symfony\Component\Console\Application->run()
#34 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(427): Illuminate\Console\Application->call()
#35 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Foundation\Console\Kernel->call()
#36 /usr/www/users/tswtzk/koel/app/Console/Commands/InitCommand.php(262): Illuminate\Support\Facades\Facade::__callStatic()
#37 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): App\Console\Commands\InitCommand::App\Console\Commands{closure}()
#38 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/View/Components/Factory.php(60): Illuminate\Console\View\Components\Task->render()
#39 /usr/www/users/tswtzk/koel/app/Console/Commands/InitCommand.php(261): Illuminate\Console\View\Components\Factory->__call()
#40 /usr/www/users/tswtzk/koel/app/Console/Commands/InitCommand.php(56): App\Console\Commands\InitCommand->migrateDatabase()
#41 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\InitCommand->handle()
#42 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#43 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#44 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#45 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call()
#46 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#47 /usr/www/users/tswtzk/koel/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#48 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#49 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#50 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#51 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#52 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run()
#53 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\Foundation\Console\Kernel->handle()
#54 /usr/www/users/tswtzk/koel/artisan(16): Illuminate\Foundation\Application->handleCommand()
#55 {main}

Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1829 Cannot drop column 'id': needed in a foreign key constraint 'songs_contributing_artist_id_foreign' of table koelserver.songs (Connection: mysql, SQL: alter table artists drop id) in /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825
Stack trace:
#0 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#1 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\Database\Connection->run()
#2 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\Database\Connection->statement()
#3 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\Database\Schema\Blueprint->build()
#4 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\Database\Schema\Builder->build()
#5 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\Builder->table()
#6 /usr/www/users/tswtzk/koel/database/migrations/2025_07_20_165510_promote_public_ids.php(79): Illuminate\Support\Facades\Facade::__callStatic()
#7 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(507): Illuminate\Database\Migrations\Migration@anonymous->up()
#8 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(432): Illuminate\Database\Migrations\Migrator->runMethod()
#9 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(441): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}()
#10 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->runMigration()
#11 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations{closure}()
#12 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(798): Illuminate\Console\View\Components\Task->render()
#13 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->write()
#14 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(211): Illuminate\Database\Migrations\Migrator->runUp()
#15 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(138): Illuminate\Database\Migrations\Migrator->runPending()
#16 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(117): Illuminate\Database\Migrations\Migrator->run()
#17 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(658): Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations{closure}()
#18 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\Database\Migrations\Migrator->usingConnection()
#19 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#20 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#21 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#22 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#23 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#24 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call()
#25 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#26 /usr/www/users/tswtzk/koel/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#27 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#28 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#29 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#30 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#31 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Application.php(166): Symfony\Component\Console\Application->run()
#32 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(427): Illuminate\Console\Application->call()
#33 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Foundation\Console\Kernel->call()
#34 /usr/www/users/tswtzk/koel/app/Console/Commands/InitCommand.php(262): Illuminate\Support\Facades\Facade::__callStatic()
#35 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): App\Console\Commands\InitCommand::App\Console\Commands{closure}()
#36 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/View/Components/Factory.php(60): Illuminate\Console\View\Components\Task->render()
#37 /usr/www/users/tswtzk/koel/app/Console/Commands/InitCommand.php(261): Illuminate\Console\View\Components\Factory->__call()
#38 /usr/www/users/tswtzk/koel/app/Console/Commands/InitCommand.php(56): App\Console\Commands\InitCommand->migrateDatabase()
#39 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\InitCommand->handle()
#40 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container{closure}()
#41 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#42 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#43 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call()
#44 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#45 /usr/www/users/tswtzk/koel/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
#46 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#47 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
#48 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
#49 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
#50 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run()
#51 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\Foundation\Console\Kernel->handle()
#52 /usr/www/users/tswtzk/koel/artisan(16): Illuminate\Foundation\Application->handleCommand()
#53 {main}

Koel version

7.15.1

How did you install Koel?

Pre-compiled tar/zip archive

Additional information

  • Server OS: Apache
  • PHP version: 8.2
  • Database: MySQL
  • Node version: n/a
  • Browser & device: n/a
  • Additional context: n/a
Originally created by @tsawitzki on GitHub (Oct 22, 2025). Original GitHub issue: https://github.com/koel/koel/issues/2142 Originally assigned to: @phanan on GitHub. ### Read the Troubleshooting guide. - [x] I have read and followed the Troubleshooting guide ### Reproduction steps Fresh installation on a Hetzner server using MySQL the installation fails with the attached error log, any hint what could cause this issue? ### Expected behavior Installer just doing the migrating thing and be done with it. ### Actual behavior Cryptic error. ### Logs [2025-10-22 12:15:12] production.ERROR: PDOException: SQLSTATE[HY000]: General error: 1829 Cannot drop column 'id': needed in a foreign key constraint 'songs_contributing_artist_id_foreign' of table `koelserver`.`songs` in /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:571 Stack trace: #0 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(571): PDOStatement->execute() #1 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback() #3 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\Database\Connection->run() #4 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\Database\Connection->statement() #5 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\Database\Schema\Blueprint->build() #6 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\Database\Schema\Builder->build() #7 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\Builder->table() #8 /usr/www/users/tswtzk/koel/database/migrations/2025_07_20_165510_promote_public_ids.php(79): Illuminate\Support\Facades\Facade::__callStatic() #9 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(507): Illuminate\Database\Migrations\Migration@anonymous->up() #10 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(432): Illuminate\Database\Migrations\Migrator->runMethod() #11 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(441): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() #12 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->runMigration() #13 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() #14 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(798): Illuminate\Console\View\Components\Task->render() #15 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->write() #16 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(211): Illuminate\Database\Migrations\Migrator->runUp() #17 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(138): Illuminate\Database\Migrations\Migrator->runPending() #18 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(117): Illuminate\Database\Migrations\Migrator->run() #19 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(658): Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations\{closure}() #20 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\Database\Migrations\Migrator->usingConnection() #21 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations() #22 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle() #23 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #24 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure() #25 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod() #26 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call() #27 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call() #28 /usr/www/users/tswtzk/koel/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute() #29 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run() #30 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run() #31 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand() #32 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun() #33 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Application.php(166): Symfony\Component\Console\Application->run() #34 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(427): Illuminate\Console\Application->call() #35 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Foundation\Console\Kernel->call() #36 /usr/www/users/tswtzk/koel/app/Console/Commands/InitCommand.php(262): Illuminate\Support\Facades\Facade::__callStatic() #37 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): App\Console\Commands\InitCommand::App\Console\Commands\{closure}() #38 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/View/Components/Factory.php(60): Illuminate\Console\View\Components\Task->render() #39 /usr/www/users/tswtzk/koel/app/Console/Commands/InitCommand.php(261): Illuminate\Console\View\Components\Factory->__call() #40 /usr/www/users/tswtzk/koel/app/Console/Commands/InitCommand.php(56): App\Console\Commands\InitCommand->migrateDatabase() #41 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\InitCommand->handle() #42 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #43 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure() #44 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod() #45 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call() #46 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call() #47 /usr/www/users/tswtzk/koel/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute() #48 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run() #49 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run() #50 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand() #51 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun() #52 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run() #53 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\Foundation\Console\Kernel->handle() #54 /usr/www/users/tswtzk/koel/artisan(16): Illuminate\Foundation\Application->handleCommand() #55 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1829 Cannot drop column 'id': needed in a foreign key constraint 'songs_contributing_artist_id_foreign' of table `koelserver`.`songs` (Connection: mysql, SQL: alter table `artists` drop `id`) in /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825 Stack trace: #0 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback() #1 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\Database\Connection->run() #2 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\Database\Connection->statement() #3 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\Database\Schema\Blueprint->build() #4 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\Database\Schema\Builder->build() #5 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\Builder->table() #6 /usr/www/users/tswtzk/koel/database/migrations/2025_07_20_165510_promote_public_ids.php(79): Illuminate\Support\Facades\Facade::__callStatic() #7 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(507): Illuminate\Database\Migrations\Migration@anonymous->up() #8 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(432): Illuminate\Database\Migrations\Migrator->runMethod() #9 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(441): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() #10 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->runMigration() #11 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() #12 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(798): Illuminate\Console\View\Components\Task->render() #13 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(244): Illuminate\Database\Migrations\Migrator->write() #14 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(211): Illuminate\Database\Migrations\Migrator->runUp() #15 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(138): Illuminate\Database\Migrations\Migrator->runPending() #16 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(117): Illuminate\Database\Migrations\Migrator->run() #17 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(658): Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations\{closure}() #18 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\Database\Migrations\Migrator->usingConnection() #19 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations() #20 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle() #21 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #22 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure() #23 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod() #24 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call() #25 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call() #26 /usr/www/users/tswtzk/koel/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute() #27 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run() #28 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run() #29 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand() #30 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun() #31 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Application.php(166): Symfony\Component\Console\Application->run() #32 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(427): Illuminate\Console\Application->call() #33 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Foundation\Console\Kernel->call() #34 /usr/www/users/tswtzk/koel/app/Console/Commands/InitCommand.php(262): Illuminate\Support\Facades\Facade::__callStatic() #35 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): App\Console\Commands\InitCommand::App\Console\Commands\{closure}() #36 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/View/Components/Factory.php(60): Illuminate\Console\View\Components\Task->render() #37 /usr/www/users/tswtzk/koel/app/Console/Commands/InitCommand.php(261): Illuminate\Console\View\Components\Factory->__call() #38 /usr/www/users/tswtzk/koel/app/Console/Commands/InitCommand.php(56): App\Console\Commands\InitCommand->migrateDatabase() #39 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\InitCommand->handle() #40 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #41 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure() #42 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod() #43 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Container/Container.php(696): Illuminate\Container\BoundMethod::call() #44 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call() #45 /usr/www/users/tswtzk/koel/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute() #46 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run() #47 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run() #48 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand() #49 /usr/www/users/tswtzk/koel/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun() #50 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run() #51 /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1235): Illuminate\Foundation\Console\Kernel->handle() #52 /usr/www/users/tswtzk/koel/artisan(16): Illuminate\Foundation\Application->handleCommand() #53 {main} ### Koel version 7.15.1 ### How did you install Koel? Pre-compiled tar/zip archive ### Additional information - **Server OS**: Apache - **PHP version**: 8.2 - **Database**: MySQL - **Node version**: n/a - **Browser & device**: n/a - **Additional context**: n/a
kerem closed this issue 2026-02-26 02:35:14 +03:00
Author
Owner

@phanan commented on GitHub (Oct 22, 2025):

What's your MySQL version?

<!-- gh-comment-id:3432338189 --> @phanan commented on GitHub (Oct 22, 2025): What's your MySQL version?
Author
Owner

@Doppelkeks12 commented on GitHub (Oct 22, 2025):

Looks like https://github.com/koel/koel/issues/2046

<!-- gh-comment-id:3432511116 --> @Doppelkeks12 commented on GitHub (Oct 22, 2025): Looks like https://github.com/koel/koel/issues/2046
Author
Owner

@tsawitzki commented on GitHub (Oct 22, 2025):

@phanan it’s mysql Ver 15.1 Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper

<!-- gh-comment-id:3432599413 --> @tsawitzki commented on GitHub (Oct 22, 2025): @phanan it’s mysql Ver 15.1 Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
Author
Owner

@tsawitzki commented on GitHub (Oct 22, 2025):

@phanan the upper being what the CLI gives me in SSH, 10.11.14-MariaDB-0+deb12u2 is what I get in phpMyAdmin SELECT VERSION();

<!-- gh-comment-id:3432620714 --> @tsawitzki commented on GitHub (Oct 22, 2025): @phanan the upper being what the CLI gives me in SSH, `10.11.14-MariaDB-0+deb12u2` is what I get in phpMyAdmin `SELECT VERSION();`
Author
Owner

@phanan commented on GitHub (Oct 22, 2025):

Hmm, I've just created a test run with PHP 8.2 and MariaDB 10.11.14 and it's green for me.

<!-- gh-comment-id:3432661310 --> @phanan commented on GitHub (Oct 22, 2025): Hmm, I've just created a [test run](https://github.com/koel/koel/actions/runs/18719517996/job/53387767431?pr=2144) with PHP 8.2 and MariaDB 10.11.14 and it's green for me.
Author
Owner

@tsawitzki commented on GitHub (Oct 22, 2025):

ok, so what might be wrong with my setup then?

<!-- gh-comment-id:3432977504 --> @tsawitzki commented on GitHub (Oct 22, 2025): ok, so what might be wrong with my setup then?
Author
Owner

@tsawitzki commented on GitHub (Oct 22, 2025):

could the database coaltion be a culprit? if yes, which one would be the right one for Koel?

<!-- gh-comment-id:3432983255 --> @tsawitzki commented on GitHub (Oct 22, 2025): could the database coaltion be a culprit? if yes, which one would be the right one for Koel?
Author
Owner

@phanan commented on GitHub (Oct 22, 2025):

I can't answer that question for you, unfortunately. Maybe try another DB version. I'm not familiar with an "EditLine wrapper," so I wouldn't rule it out either.
Re: colation: utf8mb4_unicode_ci is the standard I believe, and Koel works well with it.

<!-- gh-comment-id:3432987786 --> @phanan commented on GitHub (Oct 22, 2025): I can't answer that question for you, unfortunately. Maybe try another DB version. I'm not familiar with an "EditLine wrapper," so I wouldn't rule it out either. Re: colation: `utf8mb4_unicode_ci` is the standard I believe, and Koel works well with it.
Author
Owner

@tsawitzki commented on GitHub (Oct 23, 2025):

Deleting the database and creating a new one (same steps, same settings) solved the issue. Even if this seems a bit esoteric to me, the issue seems solved for now.
Now unfortunately stuck at this one: #2146

<!-- gh-comment-id:3435699334 --> @tsawitzki commented on GitHub (Oct 23, 2025): Deleting the database and creating a new one (same steps, same settings) solved the issue. Even if this seems a bit esoteric to me, the issue seems solved for now. Now unfortunately stuck at this one: #2146
Author
Owner

@phanan commented on GitHub (Oct 23, 2025):

Glad it worked for you!

<!-- gh-comment-id:3435728280 --> @phanan commented on GitHub (Oct 23, 2025): Glad it worked for you!
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/koel-koel#1099
No description provided.