[GH-ISSUE #544] 'Illegal mix of collations' when scanning a path #387

New issue

Open

opened 2026-02-26 02:33:02 +03:00 by kerem · 6 comments

kerem commented 2026-02-26 02:33:02 +03:00

Owner

Copy link

Originally created by @jrwren on GitHub (Feb 23, 2017).
Original GitHub issue: https://github.com/koel/koel/issues/544

Hey, thanks for contributing to Koel! To save time for both of us, please make sure these checkboxes are checked before submitting the issue:

• You have read and followed closely the Wiki, Upgrade Guide, as well as Troubleshooting
• The issue has not been reported before
• This is not a "how to install on Windows" or "why is my npm messed up" question
• You're a cool person

All checked? Now also make sure your issue

• Is associated with a version. Or better yet, a commit. d905063fb6
• Is as detailed as possible (ahem... OS, browser, steps to reproduce, maybe?)
• Includes the error output if it's a bug/error report ("Whoops!" is not very helpful, you know)
• Is in English, 因为我不说中文。

Running master (d905063fb6) a new install, scanning a new media dir.

It seems one of the id3 tags in one of my mp3 files is bad. This is from pastebin:

[2017-02-23 00:06:48] production.ERROR: PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=' in /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:323
Stack trace:
#0 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): PDOStatement->execute()
#1 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database{closure}('select * from ...', Array) #2 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select * from ...', Array, Object(Closure))
#3 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select * from ...', Array, Object(Closure)) #4 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1718): Illuminate\Database\Connection->select('select * from ...', Array, true)
#5 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Illuminate\Database\Query\Builder->runSelect()
#6 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(493): Illuminate\Database\Query\Builder->get(Array)
#7 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(477): Illuminate\Database\Eloquent\Builder->getModels(Array)
#8 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(409): Illuminate\Database\Eloquent\Builder->get(Array)
#9 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(374): Illuminate\Database\Eloquent\Builder->first()
#10 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1316): Illuminate\Database\Eloquent\Builder->firstOrCreate(Array)
#11 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1328): Illuminate\Database\Eloquent\Model->__call('firstOrCreate', Array)
#12 /home/jrwren/src/koel/app/Models/Album.php(65): Illuminate\Database\Eloquent\Model::__callStatic('firstOrCreate', Array)
#13 /home/jrwren/src/koel/app/Models/File.php(248): App\Models\Album::get(Object(App\Models\Artist), '\xFF\xFE', false)
#14 /home/jrwren/src/koel/app/Services/Media.php(84): App\Models\File->sync(Array, false)
#15 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): App\Services\Media->sync()
#16 /home/jrwren/src/koel/app/Http/Controllers/API/SettingController.php(25): Illuminate\Support\Facades\Facade::__callStatic('sync', Array)
#17 [internal function]: App\Http\Controllers\API\SettingController->store(Object(App\Http\Requests\API\SettingRequest))
#18 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#19 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('store', Array)
#20 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\API\SettingController), 'store')
#21 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#22 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#23 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#24 /home/jrwren/src/koel/app/Http/Middleware/GetUserFromToken.php(39): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#25 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\GetUserFromToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#26 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#27 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#28 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#29 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#30 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#31 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), '60', '1')
#32 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#33 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#34 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#35 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#36 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#37 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#38 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))
#39 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#40 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#41 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#42 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#43 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#44 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#45 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#46 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#47 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#48 /home/jrwren/src/koel/app/Http/Middleware/UseDifferentConfigIfE2E.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#49 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\UseDifferentConfigIfE2E->handle(Object(Illuminate\Http\Request), Object(Closure))
#50 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#51 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#52 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#53 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#54 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#55 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#56 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#57 /home/jrwren/src/koel/index.php(52): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#58 /home/jrwren/src/koel/server.php(19): require_once('/home/jrwren/sr...')
#59 {main}

Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=' (SQL: select * from albums where (artist_id = 2449 and name = ��) limit 1) in /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647
Stack trace:
#0 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select * from ...', Array, Object(Closure)) #1 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select * from ...', Array, Object(Closure))
#2 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1718): Illuminate\Database\Connection->select('select * from `...', Array, true)
#3 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Illuminate\Database\Query\Builder->runSelect()
#4 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(493): Illuminate\Database\Query\Builder->get(Array)
#5 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(477): Illuminate\Database\Eloquent\Builder->getModels(Array)
#6 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(409): Illuminate\Database\Eloquent\Builder->get(Array)
#7 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(374): Illuminate\Database\Eloquent\Builder->first()
#8 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1316): Illuminate\Database\Eloquent\Builder->firstOrCreate(Array)
#9 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1328): Illuminate\Database\Eloquent\Model->__call('firstOrCreate', Array)
#10 /home/jrwren/src/koel/app/Models/Album.php(65): Illuminate\Database\Eloquent\Model::__callStatic('firstOrCreate', Array)
#11 /home/jrwren/src/koel/app/Models/File.php(248): App\Models\Album::get(Object(App\Models\Artist), '\xFF\xFE', false)
#12 /home/jrwren/src/koel/app/Services/Media.php(84): App\Models\File->sync(Array, false)
#13 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): App\Services\Media->sync()
#14 /home/jrwren/src/koel/app/Http/Controllers/API/SettingController.php(25): Illuminate\Support\Facades\Facade::__callStatic('sync', Array)
#15 [internal function]: App\Http\Controllers\API\SettingController->store(Object(App\Http\Requests\API\SettingRequest))
#16 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array)
#17 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('store', Array)
#18 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\API\SettingController), 'store')
#19 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController()
#20 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run()
#21 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#22 /home/jrwren/src/koel/app/Http/Middleware/GetUserFromToken.php(39): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#23 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\GetUserFromToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#24 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#25 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#26 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#27 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#28 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#29 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), '60', '1')
#30 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#31 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#32 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#33 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#34 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#35 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#36 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))
#37 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#38 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#39 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#40 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#41 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#42 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#43 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#44 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#45 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#46 /home/jrwren/src/koel/app/Http/Middleware/UseDifferentConfigIfE2E.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#47 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\UseDifferentConfigIfE2E->handle(Object(Illuminate\Http\Request), Object(Closure))
#48 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#49 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#50 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#51 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))
#52 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))
#53 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#54 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#55 /home/jrwren/src/koel/index.php(52): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#56 /home/jrwren/src/koel/server.php(19): require_once('/home/jrwren/sr...')
#57 {main}

It seems maybe the name has a BOM? name = ) ` is how the message shows using less.

Originally created by @jrwren on GitHub (Feb 23, 2017). Original GitHub issue: https://github.com/koel/koel/issues/544 Hey, thanks for contributing to Koel! To save time for both of us, please make sure these checkboxes are checked before submitting the issue: - [X] You have read and followed closely the [Wiki](https://github.com/phanan/koel/wiki), [Upgrade Guide](https://github.com/phanan/koel/releases), as well as [Troubleshooting](https://github.com/phanan/koel/wiki/Troubleshooting) - [X] The issue has not been reported before - [X] This is not a "how to install on Windows" or "why is my npm messed up" question - [X] You're a cool person All checked? Now also make sure your issue - [X] Is associated with a version. Or better yet, a commit. d905063fb64765f7c3ab27672bb7b01e8d397b5b - [X] Is as detailed as possible (ahem... OS, browser, steps to reproduce, maybe?) - [X] Includes the error output if it's a bug/error report ("Whoops!" is not very helpful, you know) - [X] Is in English, 因为我不说中文。 Running master (d905063fb64765f7c3ab27672bb7b01e8d397b5b) a new install, scanning a new media dir. It seems one of the id3 tags in one of my mp3 files is bad. This is from pastebin: [2017-02-23 00:06:48] production.ERROR: PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=' in /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:323 Stack trace: #0 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): PDOStatement->execute() #1 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select * from `...', Array) #2 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure)) #3 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #4 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1718): Illuminate\Database\Connection->select('select * from `...', Array, true) #5 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Illuminate\Database\Query\Builder->runSelect() #6 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(493): Illuminate\Database\Query\Builder->get(Array) #7 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(477): Illuminate\Database\Eloquent\Builder->getModels(Array) #8 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(409): Illuminate\Database\Eloquent\Builder->get(Array) #9 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(374): Illuminate\Database\Eloquent\Builder->first() #10 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1316): Illuminate\Database\Eloquent\Builder->firstOrCreate(Array) #11 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1328): Illuminate\Database\Eloquent\Model->__call('firstOrCreate', Array) #12 /home/jrwren/src/koel/app/Models/Album.php(65): Illuminate\Database\Eloquent\Model::__callStatic('firstOrCreate', Array) #13 /home/jrwren/src/koel/app/Models/File.php(248): App\Models\Album::get(Object(App\Models\Artist), '\xFF\xFE', false) #14 /home/jrwren/src/koel/app/Services/Media.php(84): App\Models\File->sync(Array, false) #15 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): App\Services\Media->sync() #16 /home/jrwren/src/koel/app/Http/Controllers/API/SettingController.php(25): Illuminate\Support\Facades\Facade::__callStatic('sync', Array) #17 [internal function]: App\Http\Controllers\API\SettingController->store(Object(App\Http\Requests\API\SettingRequest)) #18 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #19 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('store', Array) #20 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\API\SettingController), 'store') #21 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #22 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #23 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /home/jrwren/src/koel/app/Http/Middleware/GetUserFromToken.php(39): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #25 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\GetUserFromToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #28 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #29 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #31 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), '60', '1') #32 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #33 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #34 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #35 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #36 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #37 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #38 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #39 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #40 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #42 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #43 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #44 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #45 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #46 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #47 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #48 /home/jrwren/src/koel/app/Http/Middleware/UseDifferentConfigIfE2E.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #49 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\UseDifferentConfigIfE2E->handle(Object(Illuminate\Http\Request), Object(Closure)) #50 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #51 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #52 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #53 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #54 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #55 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #56 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #57 /home/jrwren/src/koel/index.php(52): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #58 /home/jrwren/src/koel/server.php(19): require_once('/home/jrwren/sr...') #59 {main} Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=' (SQL: select * from `albums` where (`artist_id` = 2449 and `name` = ��) limit 1) in /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647 Stack trace: #0 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure)) #1 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #2 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1718): Illuminate\Database\Connection->select('select * from `...', Array, true) #3 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Illuminate\Database\Query\Builder->runSelect() #4 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(493): Illuminate\Database\Query\Builder->get(Array) #5 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(477): Illuminate\Database\Eloquent\Builder->getModels(Array) #6 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(409): Illuminate\Database\Eloquent\Builder->get(Array) #7 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(374): Illuminate\Database\Eloquent\Builder->first() #8 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1316): Illuminate\Database\Eloquent\Builder->firstOrCreate(Array) #9 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1328): Illuminate\Database\Eloquent\Model->__call('firstOrCreate', Array) #10 /home/jrwren/src/koel/app/Models/Album.php(65): Illuminate\Database\Eloquent\Model::__callStatic('firstOrCreate', Array) #11 /home/jrwren/src/koel/app/Models/File.php(248): App\Models\Album::get(Object(App\Models\Artist), '\xFF\xFE', false) #12 /home/jrwren/src/koel/app/Services/Media.php(84): App\Models\File->sync(Array, false) #13 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): App\Services\Media->sync() #14 /home/jrwren/src/koel/app/Http/Controllers/API/SettingController.php(25): Illuminate\Support\Facades\Facade::__callStatic('sync', Array) #15 [internal function]: App\Http\Controllers\API\SettingController->store(Object(App\Http\Requests\API\SettingRequest)) #16 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #17 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('store', Array) #18 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\API\SettingController), 'store') #19 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #20 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #21 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #22 /home/jrwren/src/koel/app/Http/Middleware/GetUserFromToken.php(39): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #23 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\GetUserFromToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #24 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #25 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #26 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #27 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #28 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #29 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), '60', '1') #30 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #31 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #32 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #33 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #34 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #35 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #36 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #37 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #38 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #39 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #40 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(30): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #41 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #42 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #43 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #44 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #45 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #46 /home/jrwren/src/koel/app/Http/Middleware/UseDifferentConfigIfE2E.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #47 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\UseDifferentConfigIfE2E->handle(Object(Illuminate\Http\Request), Object(Closure)) #48 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #49 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #50 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #51 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #52 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #53 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #54 /home/jrwren/src/koel/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #55 /home/jrwren/src/koel/index.php(52): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #56 /home/jrwren/src/koel/server.php(19): require_once('/home/jrwren/sr...') #57 {main} It seems maybe the name has a BOM? `name` = <FF><FE>) ` is how the message shows using less.

kerem added the

[Status] Needs Review

[Status] Keep Open

Sync

labels 2026-02-26 02:33:02 +03:00

kerem commented 2026-02-26 02:33:03 +03:00

Author

Owner

Copy link

@jrwren commented on GitHub (Feb 23, 2017):

HRM, it seems pastebin and github are both eating the characters. <FF><FE> is what is displayed in less output.

<!-- gh-comment-id:281849367 --> @jrwren commented on GitHub (Feb 23, 2017): HRM, it seems pastebin and github are both eating the characters. `<FF><FE>` is what is displayed in less output.

kerem commented 2026-02-26 02:33:03 +03:00

Author

Owner

Copy link

@phanan commented on GitHub (Feb 23, 2017):

Are you sure this is master? Because I see an now-obsolete UseDifferentConfigIfE2E class there.

<!-- gh-comment-id:281876129 --> @phanan commented on GitHub (Feb 23, 2017): Are you sure this is `master`? Because I see an now-obsolete `UseDifferentConfigIfE2E` class there.

kerem commented 2026-02-26 02:33:03 +03:00

Author

Owner

Copy link

@jrwren commented on GitHub (Feb 23, 2017):

Yes, I just double checked. d905063fb6

I have worked around with this patch: github.com/jrwren/koel@6d1a9659ef

I think this is my fault for having music with bad id3 tags.

<!-- gh-comment-id:281878397 --> @jrwren commented on GitHub (Feb 23, 2017): Yes, I just double checked. d905063fb64765f7c3ab27672bb7b01e8d397b5b I have worked around with this patch: https://github.com/jrwren/koel/commit/6d1a9659ef3239e8cb60706c984abd62124966e9 I think this is my fault for having music with bad id3 tags.

kerem commented 2026-02-26 02:33:03 +03:00

Author

Owner

Copy link

@phanan commented on GitHub (Feb 23, 2017):

Thanks for reporting the issue. I'll keep this open in case others encounter the same problem.

<!-- gh-comment-id:281878963 --> @phanan commented on GitHub (Feb 23, 2017): Thanks for reporting the issue. I'll keep this open in case others encounter the same problem.

kerem commented 2026-02-26 02:33:03 +03:00

Author

Owner

Copy link

@coderobe commented on GitHub (May 4, 2017):

I was having the same issue. Koel initializes the tables in the DB as utf8_unicode_ci, even though it requires utf8mb4_unicode_ci (even for some valid artists, albums, and/or tracks). You can work around it by manually setting the collation of every table in the DB to utf8mb4_unicode_ci - setting the global DB collation does not work.

<!-- gh-comment-id:299205466 --> @coderobe commented on GitHub (May 4, 2017): I was having the same issue. Koel initializes the tables in the DB as `utf8_unicode_ci`, even though it requires `utf8mb4_unicode_ci` (even for some valid artists, albums, and/or tracks). You can work around it by manually setting the collation of every table in the DB to `utf8mb4_unicode_ci` - setting the global DB collation does not work.

kerem commented 2026-02-26 02:33:03 +03:00

Author

Owner

Copy link

@kalamun commented on GitHub (Aug 4, 2017):

Same problem here, fixed running these queries:

ALTER TABLE `albums` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `artists` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `interactions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `migrations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `password_resets` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `playlists` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `playlists_song` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `settings` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `songs` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `users` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Some tables (interactions and songs) gave error converting, so I've manually converted them column by column.

<!-- gh-comment-id:320350071 --> @kalamun commented on GitHub (Aug 4, 2017): Same problem here, fixed running these queries: ``` ALTER TABLE `albums` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `artists` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `interactions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `migrations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `password_resets` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `playlists` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `playlists_song` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `settings` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `songs` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `users` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ``` Some tables (interactions and songs) gave error converting, so I've manually converted them column by column.

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

Subscribe

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#387

No description provided.