starred/koel-koel
1
0
Fork 0
mirror of https://github.com/koel/koel.git synced 2026-04-25 08:46:00 +03:00
Code Issues 67 Projects Releases 10 Packages Wiki Activity

[GH-ISSUE #103] Duplicate ID problem #72

New issue
Closed
opened 2026-02-26 02:32:02 +03:00 by kerem · 0 comments
kerem commented 2026-02-26 02:32:02 +03:00
Owner
Copy link

Originally created by @etopian on GitHub (Dec 17, 2015).
Original GitHub issue: https://github.com/koel/koel/issues/103

get this, seems to go away when i run the import a second time.

Error:
Whoops, looks like something went wrong.
2/2 QueryException in Connection.php line 651: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'fcd03b4ccec80f8b29c44463640afc9e' for key 'PRIMARY' (SQL: insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (fcd03b4ccec80f8b29c44463640afc9e, file, 281.88734693878, , /DATA/music/mp3s/file.mp3, 1396244966, 245, 2015-12-17 21:08:11, 2015-12-17 21:08:11))

    in Connection.php line 651
    at Connection->runQueryCallback('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11'), object(Closure)) in Connection.php line 611
    at Connection->run('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11'), object(Closure)) in Connection.php line 391
    at Connection->statement('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11')) in Connection.php line 347
    at Connection->insert('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11')) in Processor.php line 32
    at Processor->processInsertGetId(object(Builder), 'insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11'), 'id') in Builder.php line 1799
    at Builder->insertGetId(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id')
    at call_user_func_array(array(object(Builder), 'insertGetId'), array(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id')) in Builder.php line 943
    at Builder->__call('insertGetId', array(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id')) in Model.php line 1639
    at Builder->insertGetId(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id') in Model.php line 1639
    at Model->insertAndSetId(object(Builder), array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11')) in Model.php line 1608
    at Model->performInsert(object(Builder), array()) in Model.php line 1514
    at Model->save() in Model.php line 610
    at Model::updateOrCreate(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e'), array('title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245')) in Media.php line 120
    at Media->syncFile(object(SplFileInfo)) in Media.php line 52
    at Media->sync() in Facade.php line 213
    at Facade::__callStatic('sync', array()) in SettingController.php line 25
    at Media::sync() in SettingController.php line 25
    at SettingController->save(object(SettingRequest))
    at call_user_func_array(array(object(SettingController), 'save'), array(object(SettingRequest))) in Controller.php line 256
    at Controller->callAction('save', array(object(SettingRequest))) in ControllerDispatcher.php line 164
    at ControllerDispatcher->call(object(SettingController), object(Route), 'save') in ControllerDispatcher.php line 112
    at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
    at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
    at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
    at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 114
    at ControllerDispatcher->callWithinStack(object(SettingController), object(Route), object(Request), 'save') in ControllerDispatcher.php line 69
    at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\API\SettingController', 'save') in Route.php line 203
    at Route->runWithCustomDispatcher(object(Request)) in Route.php line 134
    at Route->run(object(Request)) in Router.php line 708
    at Router->Illuminate\Routing\{closure}(object(Request))
    at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Authenticate.php line 45
    at Authenticate->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
    at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
    at Pipeline->then(object(Closure)) in Router.php line 710
    at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 675
    at Router->dispatchToRoute(object(Request)) in Router.php line 635
    at Router->dispatch(object(Request)) in Kernel.php line 236
    at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
    at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 50
    at VerifyCsrfToken->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
    at ShareErrorsFromSession->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in StartSession.php line 62
    at StartSession->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
    at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 59
    at EncryptCookies->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
    at CheckForMaintenanceMode->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
    at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
    at Pipeline->then(object(Closure)) in Kernel.php line 122
    at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 87
    at Kernel->handle(object(Request)) in index.php line 53

1/2 PDOException in Connection.php line 390: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'fcd03b4ccec80f8b29c44463640afc9e' for key 'PRIMARY'

    in Connection.php line 390
    at PDOStatement->execute(array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11')) in Connection.php line 390
    at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11')) in Connection.php line 644
    at Connection->runQueryCallback('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11'), object(Closure)) in Connection.php line 611
    at Connection->run('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11'), object(Closure)) in Connection.php line 391
    at Connection->statement('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11')) in Connection.php line 347
    at Connection->insert('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11')) in Processor.php line 32
    at Processor->processInsertGetId(object(Builder), 'insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11'), 'id') in Builder.php line 1799
    at Builder->insertGetId(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id')
    at call_user_func_array(array(object(Builder), 'insertGetId'), array(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id')) in Builder.php line 943
    at Builder->__call('insertGetId', array(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id')) in Model.php line 1639
    at Builder->insertGetId(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id') in Model.php line 1639
    at Model->insertAndSetId(object(Builder), array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11')) in Model.php line 1608
    at Model->performInsert(object(Builder), array()) in Model.php line 1514
    at Model->save() in Model.php line 610
    at Model::updateOrCreate(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e'), array('title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245')) in Media.php line 120
    at Media->syncFile(object(SplFileInfo)) in Media.php line 52
    at Media->sync() in Facade.php line 213
    at Facade::__callStatic('sync', array()) in SettingController.php line 25
    at Media::sync() in SettingController.php line 25
    at SettingController->save(object(SettingRequest))
    at call_user_func_array(array(object(SettingController), 'save'), array(object(SettingRequest))) in Controller.php line 256
    at Controller->callAction('save', array(object(SettingRequest))) in ControllerDispatcher.php line 164
    at ControllerDispatcher->call(object(SettingController), object(Route), 'save') in ControllerDispatcher.php line 112
    at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
    at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
    at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
    at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 114
    at ControllerDispatcher->callWithinStack(object(SettingController), object(Route), object(Request), 'save') in ControllerDispatcher.php line 69
    at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\API\SettingController', 'save') in Route.php line 203
    at Route->runWithCustomDispatcher(object(Request)) in Route.php line 134
    at Route->run(object(Request)) in Router.php line 708
    at Router->Illuminate\Routing\{closure}(object(Request))
    at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Authenticate.php line 45
    at Authenticate->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
    at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
    at Pipeline->then(object(Closure)) in Router.php line 710
    at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 675
    at Router->dispatchToRoute(object(Request)) in Router.php line 635
    at Router->dispatch(object(Request)) in Kernel.php line 236
    at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
    at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 50
    at VerifyCsrfToken->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
    at ShareErrorsFromSession->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in StartSession.php line 62
    at StartSession->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
    at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 59
    at EncryptCookies->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
    at CheckForMaintenanceMode->handle(object(Request), object(Closure))
    at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124
    at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
    at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103
    at Pipeline->then(object(Closure)) in Kernel.php line 122
    at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 87
    at Kernel->handle(object(Request)) in index.php line 53
Originally created by @etopian on GitHub (Dec 17, 2015). Original GitHub issue: https://github.com/koel/koel/issues/103 get this, seems to go away when i run the import a second time. ``` Error: Whoops, looks like something went wrong. 2/2 QueryException in Connection.php line 651: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'fcd03b4ccec80f8b29c44463640afc9e' for key 'PRIMARY' (SQL: insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (fcd03b4ccec80f8b29c44463640afc9e, file, 281.88734693878, , /DATA/music/mp3s/file.mp3, 1396244966, 245, 2015-12-17 21:08:11, 2015-12-17 21:08:11)) in Connection.php line 651 at Connection->runQueryCallback('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11'), object(Closure)) in Connection.php line 611 at Connection->run('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11'), object(Closure)) in Connection.php line 391 at Connection->statement('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11')) in Connection.php line 347 at Connection->insert('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11')) in Processor.php line 32 at Processor->processInsertGetId(object(Builder), 'insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11'), 'id') in Builder.php line 1799 at Builder->insertGetId(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id') at call_user_func_array(array(object(Builder), 'insertGetId'), array(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id')) in Builder.php line 943 at Builder->__call('insertGetId', array(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id')) in Model.php line 1639 at Builder->insertGetId(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id') in Model.php line 1639 at Model->insertAndSetId(object(Builder), array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11')) in Model.php line 1608 at Model->performInsert(object(Builder), array()) in Model.php line 1514 at Model->save() in Model.php line 610 at Model::updateOrCreate(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e'), array('title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245')) in Media.php line 120 at Media->syncFile(object(SplFileInfo)) in Media.php line 52 at Media->sync() in Facade.php line 213 at Facade::__callStatic('sync', array()) in SettingController.php line 25 at Media::sync() in SettingController.php line 25 at SettingController->save(object(SettingRequest)) at call_user_func_array(array(object(SettingController), 'save'), array(object(SettingRequest))) in Controller.php line 256 at Controller->callAction('save', array(object(SettingRequest))) in ControllerDispatcher.php line 164 at ControllerDispatcher->call(object(SettingController), object(Route), 'save') in ControllerDispatcher.php line 112 at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103 at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 114 at ControllerDispatcher->callWithinStack(object(SettingController), object(Route), object(Request), 'save') in ControllerDispatcher.php line 69 at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\API\SettingController', 'save') in Route.php line 203 at Route->runWithCustomDispatcher(object(Request)) in Route.php line 134 at Route->run(object(Request)) in Router.php line 708 at Router->Illuminate\Routing\{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Authenticate.php line 45 at Authenticate->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103 at Pipeline->then(object(Closure)) in Router.php line 710 at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 675 at Router->dispatchToRoute(object(Request)) in Router.php line 635 at Router->dispatch(object(Request)) in Kernel.php line 236 at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 50 at VerifyCsrfToken->handle(object(Request), object(Closure)) at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in ShareErrorsFromSession.php line 49 at ShareErrorsFromSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in StartSession.php line 62 at StartSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37 at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 59 at EncryptCookies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103 at Pipeline->then(object(Closure)) in Kernel.php line 122 at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 87 at Kernel->handle(object(Request)) in index.php line 53 1/2 PDOException in Connection.php line 390: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'fcd03b4ccec80f8b29c44463640afc9e' for key 'PRIMARY' in Connection.php line 390 at PDOStatement->execute(array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11')) in Connection.php line 390 at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11')) in Connection.php line 644 at Connection->runQueryCallback('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11'), object(Closure)) in Connection.php line 611 at Connection->run('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11'), object(Closure)) in Connection.php line 391 at Connection->statement('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11')) in Connection.php line 347 at Connection->insert('insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11')) in Processor.php line 32 at Processor->processInsertGetId(object(Builder), 'insert into `songs` (`id`, `title`, `length`, `lyrics`, `path`, `mtime`, `album_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?)', array('fcd03b4ccec80f8b29c44463640afc9e', 'file', '281.88734693878', '', '/DATA/music/mp3s/file.mp3', '1396244966', '245', '2015-12-17 21:08:11', '2015-12-17 21:08:11'), 'id') in Builder.php line 1799 at Builder->insertGetId(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id') at call_user_func_array(array(object(Builder), 'insertGetId'), array(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id')) in Builder.php line 943 at Builder->__call('insertGetId', array(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id')) in Model.php line 1639 at Builder->insertGetId(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11'), 'id') in Model.php line 1639 at Model->insertAndSetId(object(Builder), array('id' => 'fcd03b4ccec80f8b29c44463640afc9e', 'title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245', 'updated_at' => '2015-12-17 21:08:11', 'created_at' => '2015-12-17 21:08:11')) in Model.php line 1608 at Model->performInsert(object(Builder), array()) in Model.php line 1514 at Model->save() in Model.php line 610 at Model::updateOrCreate(array('id' => 'fcd03b4ccec80f8b29c44463640afc9e'), array('title' => 'file', 'length' => '281.88734693878', 'lyrics' => '', 'path' => '/DATA/music/mp3s/file.mp3', 'mtime' => '1396244966', 'album_id' => '245')) in Media.php line 120 at Media->syncFile(object(SplFileInfo)) in Media.php line 52 at Media->sync() in Facade.php line 213 at Facade::__callStatic('sync', array()) in SettingController.php line 25 at Media::sync() in SettingController.php line 25 at SettingController->save(object(SettingRequest)) at call_user_func_array(array(object(SettingController), 'save'), array(object(SettingRequest))) in Controller.php line 256 at Controller->callAction('save', array(object(SettingRequest))) in ControllerDispatcher.php line 164 at ControllerDispatcher->call(object(SettingController), object(Route), 'save') in ControllerDispatcher.php line 112 at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103 at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 114 at ControllerDispatcher->callWithinStack(object(SettingController), object(Route), object(Request), 'save') in ControllerDispatcher.php line 69 at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\API\SettingController', 'save') in Route.php line 203 at Route->runWithCustomDispatcher(object(Request)) in Route.php line 134 at Route->run(object(Request)) in Router.php line 708 at Router->Illuminate\Routing\{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Authenticate.php line 45 at Authenticate->handle(object(Request), object(Closure)) at call_user_func_array(array(object(Authenticate), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103 at Pipeline->then(object(Closure)) in Router.php line 710 at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 675 at Router->dispatchToRoute(object(Request)) in Router.php line 635 at Router->dispatch(object(Request)) in Kernel.php line 236 at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 139 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in VerifyCsrfToken.php line 50 at VerifyCsrfToken->handle(object(Request), object(Closure)) at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in ShareErrorsFromSession.php line 49 at ShareErrorsFromSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in StartSession.php line 62 at StartSession->handle(object(Request), object(Closure)) at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37 at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in EncryptCookies.php line 59 at EncryptCookies->handle(object(Request), object(Closure)) at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44 at CheckForMaintenanceMode->handle(object(Request), object(Closure)) at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 124 at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) at call_user_func(object(Closure), object(Request)) in Pipeline.php line 103 at Pipeline->then(object(Closure)) in Kernel.php line 122 at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 87 at Kernel->handle(object(Request)) in index.php line 53 ```
kerem closed this issue 2026-02-26 02:32:02 +03:00
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
dependabot/composer/phpunit/phpunit-12.5.22
dependabot/npm_and_yarn/dompurify-3.4.0
dependabot/npm_and_yarn/vite-plus-0.1.17
dependabot/composer/phpseclib/phpseclib-3.0.51
release
1889-duplicate-upload-detection
test/home-screen-empty-to-content
fix/exclude-songless-albums-from-recently-added
refactor/laravel-prompts
fix/wma-cover-art-exception
fix/remove-redundant-seed-step
chore/upgrade-laravel-13
chore/upgrade-vue-3.5.29
test/phase-7-components
dbg-2142
demo-fix
debug-mysql
trusthosts
seek
fix-equalizer
sentry
invite-user
remove-v6-obsolete
fix/song-list
feat/paths-filter
fix/home
fix/footer
feat/progressive
php81
dev/public-playlists
cy
feat/l7
dependabot/composer/pusher/pusher-php-server-4.1.4
dependabot/composer/laravel/framework-5.8.38
dependabot/composer/jackiedo/dotenv-editor-1.1.1
renovate/pin-dependencies
actions
api-doc
feat/recently-played
fix-tests
fix-cover-page
upload
stylejs-196
compilation
vuex
android-notif
nojquery
demo
vue2
2.0
1.1
v9.1.1
latest
v9.1.0
v9.0.0
v8.3.1
v8.3.0
v8.2.0
v8.1.0
v8.0.0
v7.15.1
v7.15.0
v7.14.0
v7.13.0
v7.12.0
v7.11.0
v7.10.4
v7.10.3
v7.10.2
v7.10.1
v7.10.0
v7.9.0
v7.8.1
v7.8.0
v7.7.1
v7.7.0
v7.6.3
v7.6.2
v7.6.1
v7.6.0
v7.5.2
v7.5.1
v7.5.0
v7.4.2
v7.4.1
v7.4.0
v7.3.1
v7.3.0
v7.2.2
v7.2.1
v7.2.0
v7.1.0
v7.0.12
v7.0.11
v7.0.10
v7.0.9
v7.0.8
v7.0.7
v7.0.6
v7.0.5
v7.0.4
v7.0.3
v7.0.2
v7.0.1
v7.0.0
v6.12.1
v6.12.0
v6.11.5
v6.11.4
v6.11.3
v6.11.2
v6.11.1
v6.11.0
v6.10.0
v6.9.0
v6.8.5
v6.8.4
v6.8.3
v6.8.2
v6.8.1
v6.8.0
v6.7.5
v6.7.4
v6.7.3
v6.7.2
v6.7.1
v6.7.0
v6.6.0
v6.5.3
v6.5.2
v6.5.1
v6.5.0
v6.4.3
v6.4.2
v6.4.1
v6.4.0
v6.3.0
v6.2.2
v6.2.1
v6.2.0
v6.1.0
v6.0.6
v6.0.5
v6.0.4
v6.0.3
v6.0.2
v6.0.1
v6.0.0
v0.0.0-beta
v5.1.14
v5.1.13
v5.1.12
v5.1.11
v5.1.10
v5.1.9
v5.1.8
v5.1.7
v5.1.6
v5.1.5
v5.1.4
v5.1.3
v5.1.2
v5.1.1
v5.1.0
v5.0.2
v5.0.1
v5.0.0
v4.4.0
v4.3.1
v4.3.0
v4.2.2
v4.2.1
v4.2.0
v4.1.1
v4.1.0
v4.0.0
v3.7.2
v3.7.1
v3.7.0
v3.6.2
v3.6.1
v3.6.0
v3.5.5
v3.5.4
v3.5.3
v3.5.2
v3.5.1
v3.5.0
v3.4.1
v3.4.0
v3.3.1
v3.3.0
v3.2.0
v3.1.1
v3.1.0
v3.0.1
v3.0.0
v2.2.1
v2.2.0
v2.1.0
v2.0.2
v2.0.1
v2.0.0
v1.1.2
v1.1.1
1.0.0-beta
Labels
Clear 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

Mirrored from GitHub Pull Request

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
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
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#72
No description provided.