jjdejong/phpip

File event

Closed this issue · 0 comments

Bonsoir,
sur une base vierge remplie avec seed, j'obtiens l'erreur suivante lorsque j'essaie de mettre l'évènement "file".. Les autres évenements "publication", "grant" semblent fonctionner...
Alexandre

Unexpected result:{
"message": "SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' (SQL: insert into event (matter_id, code, event_date, detail, notes, alt_matter_id, creator, updated_at, created_at) values (11, FIL, 2020-06-14 20:06:00, ?, ?, ?, phpipuser, 2020-06-14 20:06:00, 2020-06-14 20:06:00))",
"exception": "Illuminate\Database\QueryException",
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"line": 671,
"trace": [
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"line": 631,
"function": "runQueryCallback",
"class": "Illuminate\Database\Connection",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"line": 465,
"function": "run",
"class": "Illuminate\Database\Connection",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Connection.php",
"line": 417,
"function": "statement",
"class": "Illuminate\Database\Connection",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/Processor.php",
"line": 32,
"function": "insert",
"class": "Illuminate\Database\Connection",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php",
"line": 2771,
"function": "processInsertGetId",
"class": "Illuminate\Database\Query\Processors\Processor",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php",
"line": 1403,
"function": "insertGetId",
"class": "Illuminate\Database\Query\Builder",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php",
"line": 900,
"function": "__call",
"class": "Illuminate\Database\Eloquent\Builder",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php",
"line": 865,
"function": "insertAndSetId",
"class": "Illuminate\Database\Eloquent\Model",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php",
"line": 728,
"function": "performInsert",
"class": "Illuminate\Database\Eloquent\Model",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php",
"line": 767,
"function": "save",
"class": "Illuminate\Database\Eloquent\Model",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Support/helpers.php",
"line": 433,
"function": "Illuminate\Database\Eloquent\{closure}",
"class": "Illuminate\Database\Eloquent\Builder",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php",
"line": 768,
"function": "tap"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php",
"line": 23,
"function": "create",
"class": "Illuminate\Database\Eloquent\Builder",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php",
"line": 1728,
"function": "forwardCallTo",
"class": "Illuminate\Database\Eloquent\Model",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php",
"line": 1740,
"function": "__call",
"class": "Illuminate\Database\Eloquent\Model",
"type": "->"
},
{
"file": "/var/www/html/phpipf/app/Http/Controllers/EventController.php",
"line": 31,
"function": "__callStatic",
"class": "Illuminate\Database\Eloquent\Model",
"type": "::"
},
{
"function": "store",
"class": "App\Http\Controllers\EventController",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Routing/Controller.php",
"line": 54,
"function": "call_user_func_array"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php",
"line": 45,
"function": "callAction",
"class": "Illuminate\Routing\Controller",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 239,
"function": "dispatch",
"class": "Illuminate\Routing\ControllerDispatcher",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Routing/Route.php",
"line": 196,
"function": "runController",
"class": "Illuminate\Routing\Route",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 685,
"function": "run",
"class": "Illuminate\Routing\Route",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 128,
"function": "Illuminate\Routing\{closure}",
"class": "Illuminate\Routing\Router",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php",
"line": 41,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\Routing\Middleware\SubstituteBindings",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php",
"line": 44,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\Auth\Middleware\Authenticate",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php",
"line": 76,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\Foundation\Http\Middleware\VerifyCsrfToken",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php",
"line": 49,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\View\Middleware\ShareErrorsFromSession",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php",
"line": 116,
"function": "Illuminate\Pipeline\{closure}",
"class": "Illuminate\Pipeline\Pipeline",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php",
"line": 62,
"function": "handleStatefulRequest",
"class": "Illuminate\Session\Middleware\StartSession",
"type": "->"
},
{
"file": "/var/www/html/phpipf/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\Session\Middleware\StartSession",