mirror of
https://github.com/koel/koel.git
synced 2026-04-25 08:46:00 +03:00
[GH-ISSUE #2142] [Bug]: Migrating database fails with "General error: 1829" #1099
Labels
No labels
Authentication
Dependencies
Documentation
Feature Request
Flac
Help Wanted
Installation/Setup
Integration
Mobile
PR Welcome
Pending Release
Performance
Playlist
S3
Search
Sync
[Pri] Low
[Pri] Normal
[Status] Keep Open
[Status] Needs Author Reply
[Status] Needs Review
[Status] Stale
[Status] Will Implement
[Type] Blessed
[Type] Bug
[Type] Duplicate
[Type] Enhancement
[Type] Help Request
[Type] Question
[Type] Task
pull-request
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/koel-koel#1099
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
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.
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.songsin /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:571Stack 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 tableartistsdropid) in /usr/www/users/tswtzk/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825Stack 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
@phanan commented on GitHub (Oct 22, 2025):
What's your MySQL version?
@Doppelkeks12 commented on GitHub (Oct 22, 2025):
Looks like https://github.com/koel/koel/issues/2046
@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
@tsawitzki commented on GitHub (Oct 22, 2025):
@phanan the upper being what the CLI gives me in SSH,
10.11.14-MariaDB-0+deb12u2is what I get in phpMyAdminSELECT VERSION();@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.
@tsawitzki commented on GitHub (Oct 22, 2025):
ok, so what might be wrong with my setup then?
@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?
@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_ciis the standard I believe, and Koel works well with it.@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
@phanan commented on GitHub (Oct 23, 2025):
Glad it worked for you!