Update 7.0.1 failed
-
Hello,
My Koel application was automatically updated last night. I noticed the discussions on Koel's GitHub yesterday regarding an issue with Laravel migration. It seems that the error is still persisting for me.
There's my app log :
Jul 12 10:20:36 ==> Initializing or migrating koel Jul 12 10:20:36 ************************************ <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - * KOEL INSTALLATION WIZARD * <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - ************************************ <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - As a reminder, you can always install/upgrade manually following the guide at https://docs.koel.dev <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - Jul 12 10:20:36 <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - INFO Running in no-interaction mode. <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - Jul 12 10:20:36 Clearing caches ................................................... 3ms DONE Jul 12 10:20:36 .env file exists -- skipping .......................................... DONE Jul 12 10:20:36 Retrieving app key ................................................ 0ms DONE Jul 12 10:20:36 Using app key: base64:3GDdd3xI5.. ..................................... DONE Jul 12 10:20:36 Migrating database ............................................... 12ms FAIL Jul 12 10:20:36 <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - ERROR Oops! Koel installation or upgrade didn't finish successfully. <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - Jul 12 10:20:36 ERROR Please check the error log at storage/logs/laravel.log and try again. <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - Jul 12 10:20:36 ERROR For further troubleshooting, visit https://docs.koel.dev/troubleshooting. <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - Jul 12 10:20:36 ERROR 😥 Sorry for this. You deserve better. <30>1 2024-07-12T08:20:36Z ubuntu 8931e473-d426-4611-a94e-8f32cda1cb34 883810 8931e473-d426-4611-a94e-8f32cda1cb34 - Jul 12 10:20:47 => Healtheck error: Error: Timeout of 7000ms exceeded Jul 12 10:20:53 => Healtheck error: Error: connect EHOSTUNREACH 172.18.18.151:8000all logs that I can find here : https://www.swisstransfer.com/d/ac00d043-07f6-45f4-8d60-ffbfdfd16fef
-
The directory doesn't exist. As soon as I set the app in recovery mode. I lost this file, I guess.My bad, I just forgot to start the app.
This is the log that I can find :[2024-07-12 11:51:31] production.ERROR: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'position' in /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:587 Stack trace: #0 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(587): PDOStatement->execute() #1 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(816): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback() #3 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(588): Illuminate\Database\Connection->run() #4 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(110): Illuminate\Database\Connection->statement() #5 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(602): Illuminate\Database\Schema\Blueprint->build() #6 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(444): Illuminate\Database\Schema\Builder->build() #7 /app/code/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(355): Illuminate\Database\Schema\Builder->table() #8 /app/code/database/migrations/2024_01_27_171649_add_position_into_playlists_table.php(13): Illuminate\Support\Facades\Facade::__callStatic() #9 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(493): Illuminate\Database\Migrations\Migration@anonymous->up() #10 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(410): Illuminate\Database\Migrations\Migrator->runMethod() #11 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(419): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() #12 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\Database\Migrations\Migrator->runMigration() #13 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() #14 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(756): Illuminate\Console\View\Components\Task->render() #15 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\Database\Migrations\Migrator->write() #16 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(181): Illuminate\Database\Migrations\Migrator->runUp() #17 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(124): Illuminate\Database\Migrations\Migrator->runPending() #18 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(92): Illuminate\Database\Migrations\Migrator->run() #19 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(633): Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations\{closure}() #20 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(104): Illuminate\Database\Migrations\Migrator->usingConnection() #21 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle() #22 /app/code/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #23 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #24 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #25 /app/code/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call() #26 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call() #27 /app/code/vendor/symfony/console/Command/Command.php(326): Illuminate\Console\Command->execute() #28 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run() #29 /app/code/vendor/symfony/console/Application.php(1096): Illuminate\Console\Command->run() #30 /app/code/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand() #31 /app/code/vendor/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun() #32 /app/code/vendor/laravel/framework/src/Illuminate/Console/Application.php(163): Symfony\Component\Console\Application->run() #33 /app/code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(400): Illuminate\Console\Application->call() #34 /app/code/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(355): Illuminate\Foundation\Console\Kernel->call() #35 /app/code/app/Console/Commands/InitCommand.php(273): Illuminate\Support\Facades\Facade::__callStatic() #36 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): App\Console\Commands\InitCommand::App\Console\Commands\{closure}() #37 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Factory.php(58): Illuminate\Console\View\Components\Task->render() #38 /app/code/app/Console/Commands/InitCommand.php(274): Illuminate\Console\View\Components\Factory->__call() #39 /app/code/app/Console/Commands/InitCommand.php(62): App\Console\Commands\InitCommand->migrateDatabase() #40 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\InitCommand->handle() #41 /app/code/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #42 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #43 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #44 /app/code/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call() #45 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call() #46 /app/code/vendor/symfony/console/Command/Command.php(326): Illuminate\Console\Command->execute() #47 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run() #48 /app/code/vendor/symfony/console/Application.php(1096): Illuminate\Console\Command->run() #49 /app/code/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand() #50 /app/code/vendor/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun() #51 /app/code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\Component\Console\Application->run() #52 /app/code/artisan(35): Illuminate\Foundation\Console\Kernel->handle() #53 {main} Next Illuminate\Database\QueryException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'position' (Connection: mysql, SQL: alter table `playlist_song` add `position` int unsigned not null default '0') in /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829 Stack trace: #0 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\Database\Connection->runQueryCallback() #1 /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php(588): Illuminate\Database\Connection->run() #2 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(110): Illuminate\Database\Connection->statement() #3 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(602): Illuminate\Database\Schema\Blueprint->build() #4 /app/code/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(444): Illuminate\Database\Schema\Builder->build() #5 /app/code/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(355): Illuminate\Database\Schema\Builder->table() #6 /app/code/database/migrations/2024_01_27_171649_add_position_into_playlists_table.php(13): Illuminate\Support\Facades\Facade::__callStatic() #7 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(493): Illuminate\Database\Migrations\Migration@anonymous->up() #8 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(410): Illuminate\Database\Migrations\Migrator->runMethod() #9 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(419): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() #10 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\Database\Migrations\Migrator->runMigration() #11 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}() #12 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(756): Illuminate\Console\View\Components\Task->render() #13 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\Database\Migrations\Migrator->write() #14 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(181): Illuminate\Database\Migrations\Migrator->runUp() #15 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(124): Illuminate\Database\Migrations\Migrator->runPending() #16 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(92): Illuminate\Database\Migrations\Migrator->run() #17 /app/code/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(633): Illuminate\Database\Console\Migrations\MigrateCommand->Illuminate\Database\Console\Migrations\{closure}() #18 /app/code/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(104): Illuminate\Database\Migrations\Migrator->usingConnection() #19 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle() #20 /app/code/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #21 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #22 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #23 /app/code/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call() #24 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call() #25 /app/code/vendor/symfony/console/Command/Command.php(326): Illuminate\Console\Command->execute() #26 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run() #27 /app/code/vendor/symfony/console/Application.php(1096): Illuminate\Console\Command->run() #28 /app/code/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand() #29 /app/code/vendor/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun() #30 /app/code/vendor/laravel/framework/src/Illuminate/Console/Application.php(163): Symfony\Component\Console\Application->run() #31 /app/code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(400): Illuminate\Console\Application->call() #32 /app/code/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(355): Illuminate\Foundation\Console\Kernel->call() #33 /app/code/app/Console/Commands/InitCommand.php(273): Illuminate\Support\Facades\Facade::__callStatic() #34 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): App\Console\Commands\InitCommand::App\Console\Commands\{closure}() #35 /app/code/vendor/laravel/framework/src/Illuminate/Console/View/Components/Factory.php(58): Illuminate\Console\View\Components\Task->render() #36 /app/code/app/Console/Commands/InitCommand.php(274): Illuminate\Console\View\Components\Factory->__call() #37 /app/code/app/Console/Commands/InitCommand.php(62): App\Console\Commands\InitCommand->migrateDatabase() #38 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\InitCommand->handle() #39 /app/code/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #40 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure() #41 /app/code/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod() #42 /app/code/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call() #43 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call() #44 /app/code/vendor/symfony/console/Command/Command.php(326): Illuminate\Console\Command->execute() #45 /app/code/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\Component\Console\Command\Command->run() #46 /app/code/vendor/symfony/console/Application.php(1096): Illuminate\Console\Command->run() #47 /app/code/vendor/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand() #48 /app/code/vendor/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun() #49 /app/code/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\Component\Console\Application->run() #50 /app/code/artisan(35): Illuminate\Foundation\Console\Kernel->handle() #51 {main} -
Thanks for your response. I have found a clear response to the problem and address it on the github : https://github.com/koel/koel/issues/1780
-
I resolved the issue by editing the migration that won't run.
You can mark this thread as completed.For those who might be had the same issue. I will address a PR in the GitHub of the koel project, with a various fixes and refactor of the Laravel migration to make them bulletproof.
-
N nebulon marked this topic as a question on
-
N nebulon has marked this topic as solved on
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login