When in a matter, and trying to recreate tasks:
Unexpected result: {
"message": "SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: phpip,
SQL: CALL recreate_tasks(4458, timothy))",
"exception": "Illuminate\Database\QueryException",
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"line": 841,
"trace": [
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"line": 797,
"function": "runQueryCallback",
"class": "Illuminate\Database\Connection",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"line": 576,
"function": "run",
"class": "Illuminate\Database\Connection",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php",
"line": 496,
"function": "statement",
"class": "Illuminate\Database\Connection",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php",
"line": 363,
"function": "__call",
"class": "Illuminate\Database\DatabaseManager",
"type": "->"
},
{
"file": "/var/www/phpip/routes/web.php",
"line": 136,
"function": "__callStatic",
"class": "Illuminate\Support\Facades\Facade",
"type": "::"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/CallableDispatcher.php",
"line": 39,
"function": "{closure}",
"class": "Illuminate\Routing\RouteFileRegistrar",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 247,
"function": "dispatch",
"class": "Illuminate\Routing\CallableDispatcher",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 218,
"function": "runCallable",
"class": "Illuminate\Routing\Route",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 822,
"function": "run",
"class": "Illuminate\Routing\Route",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 180,
"function": "Illuminate\Routing\{closure}",
"class": "Illuminate\Routing\Router",
"type": "->"
},
{
"file": "/var/www/phpip/app/Http/Middleware/SetLocale.php",
"line": 35,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "App\Http\Middleware\SetLocale",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php",
"line": 52,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\Routing\Middleware\SubstituteBindings",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php",
"line": 63,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\Auth\Middleware\Authenticate",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestForgery.php",
"line": 104,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\Foundation\Http\Middleware\PreventRequestForgery",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php",
"line": 48,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\View\Middleware\ShareErrorsFromSession",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php",
"line": 120,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php",
"line": 63,
"function": "handleStatefulRequest",
"class": "Illuminate\Session\Middleware\StartSession",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\Session\Middleware\StartSession",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php",
"line": 36,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php",
"line": 74,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\Cookie\Middleware\EncryptCookies",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 137,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 821,
"function": "then",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 800,
"function": "runRouteWithinStack",
"class": "Illuminate\Routing\Router",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 764,
"function": "runRoute",
"class": "Illuminate\Routing\Router",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 753,
"function": "dispatchToRoute",
"class": "Illuminate\Routing\Router",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php",
"line": 200,
"function": "dispatch",
"class": "Illuminate\Routing\Router",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 180,
"function": "Illuminate\Foundation\Http\{closure}",
"class": "Illuminate\Foundation\Http\Kernel",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illumi
When in a matter, and trying to recreate tasks:
Unexpected result: {
"message": "SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: phpip,
SQL: CALL recreate_tasks(4458, timothy))",
"exception": "Illuminate\Database\QueryException",
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"line": 841,
"trace": [
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"line": 797,
"function": "runQueryCallback",
"class": "Illuminate\Database\Connection",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"line": 576,
"function": "run",
"class": "Illuminate\Database\Connection",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php",
"line": 496,
"function": "statement",
"class": "Illuminate\Database\Connection",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php",
"line": 363,
"function": "__call",
"class": "Illuminate\Database\DatabaseManager",
"type": "->"
},
{
"file": "/var/www/phpip/routes/web.php",
"line": 136,
"function": "__callStatic",
"class": "Illuminate\Support\Facades\Facade",
"type": "::"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/CallableDispatcher.php",
"line": 39,
"function": "{closure}",
"class": "Illuminate\Routing\RouteFileRegistrar",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 247,
"function": "dispatch",
"class": "Illuminate\Routing\CallableDispatcher",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 218,
"function": "runCallable",
"class": "Illuminate\Routing\Route",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 822,
"function": "run",
"class": "Illuminate\Routing\Route",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 180,
"function": "Illuminate\Routing\{closure}",
"class": "Illuminate\Routing\Router",
"type": "->"
},
{
"file": "/var/www/phpip/app/Http/Middleware/SetLocale.php",
"line": 35,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "App\Http\Middleware\SetLocale",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php",
"line": 52,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\Routing\Middleware\SubstituteBindings",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php",
"line": 63,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\Auth\Middleware\Authenticate",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestForgery.php",
"line": 104,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\Foundation\Http\Middleware\PreventRequestForgery",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php",
"line": 48,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\View\Middleware\ShareErrorsFromSession",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php",
"line": 120,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php",
"line": 63,
"function": "handleStatefulRequest",
"class": "Illuminate\Session\Middleware\StartSession",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\Session\Middleware\StartSession",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php",
"line": 36,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php",
"line": 74,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 219,
"function": "handle",
"class": "Illuminate\Cookie\Middleware\EncryptCookies",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 137,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 821,
"function": "then",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 800,
"function": "runRouteWithinStack",
"class": "Illuminate\Routing\Router",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 764,
"function": "runRoute",
"class": "Illuminate\Routing\Router",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 753,
"function": "dispatchToRoute",
"class": "Illuminate\Routing\Router",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php",
"line": 200,
"function": "dispatch",
"class": "Illuminate\Routing\Router",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 180,
"function": "Illuminate\Foundation\Http\{closure}",
"class": "Illuminate\Foundation\Http\Kernel",
"type": "->"
},
{
"file": "/var/www/phpip/vendor/laravel/framework/src/Illumi