Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

API inaccessible au lancement de l'application

guiguix

bonjour a tous je me sert de loxya pour mon asso mais je rencontre un bug qui dit l'api n'est pas accessible (a distance ou en local)
je suis sous windows 2022 standard je tourne avec wamp je vérifie mes fichier de config je ne trouve pas se qui cloche

Donovan

Bonsoir,

Il va nous falloir plus d'informations car en l'état il va être difficile de vous aider.

Merci de fournir:

Le contenu de vos logs, surtout s'il y a des erreurs, récupérables dans le dossier src/var/logs de l'application.
Merci de suivre la vidéo suivante pour nous retourner le détails de l'erreur "Api inaccessible": https://www.youtube.com/watch?v=-Ri4ocjBqc4

Si vous souhaitez un support personnalisé pour solutionner votre problème, sachez qu'un développeur Loxya peut aussi vous aider avec tout ceci via un appel avec partage d'écran, cette prestation est toutefois payante et nous vous invitons à nous contacter à l'adresse contact@robert2.org (ou vous pouvez prendre rendez-vous directement via cette page: https://calendly.com/loxya/support-rapide-loxya) si vous préférez faire ainsi.

guiguix

[2024-07-28T13:57:48.002123+02:00] error.ERROR: Slim Application Error
Type: Illuminate\Database\QueryException
Code: 23000
Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ &#039;43-13&#039; pour la clef &#039;event_id_2&#039; (SQL: insert into `event_materials` (`quantity_returned`, `quantity_returned_broken`, `material_id`, `event_id`, `quantity`) values (?, ?, 13, 43, 1))
File: C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php
Line: 760
Trace: #0 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback('insert into `ev...', Array, Object(Closure))
#1 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(534): Illuminate\Database\Connection->run('insert into `ev...', Array, Object(Closure))
#2 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(498): Illuminate\Database\Connection->statement('insert into `ev...', Array)
#3 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `ev...', Array)
#4 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ev...', Array, 'id')
#5 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1330): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#7 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 C:\wamp64\www\Robert2-0.22.2\src\App\Models\BaseModel.php(178): Illuminate\Database\Eloquent\Model->save(Array)
#10 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(295): Loxya\Models\BaseModel->save()
#11 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(266): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachUsingCustomClass(13, Array)
#12 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(178): Illuminate\Database\Eloquent\Relations\BelongsToMany->attach(13, Array, false)
#13 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(114): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachNew(Array, Array, false)
#14 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(862): Illuminate\Database\Eloquent\Relations\BelongsToMany->sync(Array)
#15 C:\wamp64\www\Robert2-0.22.2\src\App\Config\functions.php(129): Loxya\Models\Event->Loxya\Models\{closure}()
#16 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(860): dbTransaction(Object(Closure))
#17 C:\wamp64\www\Robert2-0.22.2\src\App\Controllers\BookingController.php(129): Loxya\Models\Event->syncMaterials(Array)
#18 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(38): Loxya\Controllers\BookingController->updateMaterials(Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#19 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#20 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\Routing\Route->handle(Object(Loxya\Http\Request))
#21 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#22 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(315): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#23 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\RouteRunner.php(68): Slim\Routing\Route->run(Object(Loxya\Http\Request))
#24 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\BodyParser.php(62): Slim\Routing\RouteRunner->handle(Object(Loxya\Http\Request))
#25 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Loxya\Middlewares\BodyParser->process(Object(Loxya\Http\Request), Object(Slim\Routing\RouteRunner))
#26 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#27 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Acl->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#28 C:\wamp64\www\Robert2-0.22.2\src\App\Services\Auth.php(43): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#29 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Services\Auth->middleware(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#30 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#31 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Pagination->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#32 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#33 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#34 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#35 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#36 C:\wamp64\www\Robert2-0.22.2\vendors\slim\http-cache\src\Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#37 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\HttpCache\Cache->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#38 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#39 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(199): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#40 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(183): Slim\App->handle(Object(Loxya\Http\Request))
#41 C:\wamp64\www\Robert2-0.22.2\src\App\App.php(54): Slim\App->run(Object(Loxya\Http\Request))
#42 C:\wamp64\www\Robert2-0.22.2\src\public\index.php(17): Loxya\App->run()
#43 {main}
Previous Error:
Type: PDOException
Code: 23000
Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ &#039;43-13&#039; pour la clef &#039;event_id_2&#039;
File: C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php
Line: 545
Trace: #0 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(545): PDOStatement->execute()
#1 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert into `ev...', Array)
#2 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback('insert into `ev...', Array, Object(Closure))
#3 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(534): Illuminate\Database\Connection->run('insert into `ev...', Array, Object(Closure))
#4 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(498): Illuminate\Database\Connection->statement('insert into `ev...', Array)
#5 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `ev...', Array)
#6 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ev...', Array, 'id')
#7 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#8 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1330): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#9 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#11 C:\wamp64\www\Robert2-0.22.2\src\App\Models\BaseModel.php(178): Illuminate\Database\Eloquent\Model->save(Array)
#12 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(295): Loxya\Models\BaseModel->save()
#13 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(266): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachUsingCustomClass(13, Array)
#14 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(178): Illuminate\Database\Eloquent\Relations\BelongsToMany->attach(13, Array, false)
#15 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(114): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachNew(Array, Array, false)
#16 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(862): Illuminate\Database\Eloquent\Relations\BelongsToMany->sync(Array)
#17 C:\wamp64\www\Robert2-0.22.2\src\App\Config\functions.php(129): Loxya\Models\Event->Loxya\Models\{closure}()
#18 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(860): dbTransaction(Object(Closure))
#19 C:\wamp64\www\Robert2-0.22.2\src\App\Controllers\BookingController.php(129): Loxya\Models\Event->syncMaterials(Array)
#20 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(38): Loxya\Controllers\BookingController->updateMaterials(Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#21 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#22 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\Routing\Route->handle(Object(Loxya\Http\Request))
#23 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#24 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(315): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#25 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\RouteRunner.php(68): Slim\Routing\Route->run(Object(Loxya\Http\Request))
#26 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\BodyParser.php(62): Slim\Routing\RouteRunner->handle(Object(Loxya\Http\Request))
#27 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Loxya\Middlewares\BodyParser->process(Object(Loxya\Http\Request), Object(Slim\Routing\RouteRunner))
#28 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#29 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Acl->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#30 C:\wamp64\www\Robert2-0.22.2\src\App\Services\Auth.php(43): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#31 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Services\Auth->middleware(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#32 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#33 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Pagination->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#34 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#35 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#36 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#37 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#38 C:\wamp64\www\Robert2-0.22.2\vendors\slim\http-cache\src\Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#39 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\HttpCache\Cache->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#40 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#41 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(199): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#42 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(183): Slim\App->handle(Object(Loxya\Http\Request))
#43 C:\wamp64\www\Robert2-0.22.2\src\App\App.php(54): Slim\App->run(Object(Loxya\Http\Request))
#44 C:\wamp64\www\Robert2-0.22.2\src\public\index.php(17): Loxya\App->run()
#45 {main}  
[2024-06-29T13:58:05.049132+02:00] error.ERROR: Slim Application Error
Type: Illuminate\Database\QueryException
Code: 23000
Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ &#039;43-25&#039; pour la clef &#039;event_id_2&#039; (SQL: insert into `event_materials` (`quantity_returned`, `quantity_returned_broken`, `material_id`, `event_id`, `quantity`) values (?, ?, 25, 43, 1))
File: C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php
Line: 760
Trace: #0 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback('insert into `ev...', Array, Object(Closure))
#1 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(534): Illuminate\Database\Connection->run('insert into `ev...', Array, Object(Closure))
#2 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(498): Illuminate\Database\Connection->statement('insert into `ev...', Array)
#3 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `ev...', Array)
#4 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ev...', Array, 'id')
#5 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1330): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#7 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 C:\wamp64\www\Robert2-0.22.2\src\App\Models\BaseModel.php(178): Illuminate\Database\Eloquent\Model->save(Array)
#10 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(295): Loxya\Models\BaseModel->save()
#11 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(266): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachUsingCustomClass(25, Array)
#12 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(178): Illuminate\Database\Eloquent\Relations\BelongsToMany->attach(25, Array, false)
#13 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(114): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachNew(Array, Array, false)
#14 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(862): Illuminate\Database\Eloquent\Relations\BelongsToMany->sync(Array)
#15 C:\wamp64\www\Robert2-0.22.2\src\App\Config\functions.php(129): Loxya\Models\Event->Loxya\Models\{closure}()
#16 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(860): dbTransaction(Object(Closure))
#17 C:\wamp64\www\Robert2-0.22.2\src\App\Controllers\BookingController.php(129): Loxya\Models\Event->syncMaterials(Array)
#18 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(38): Loxya\Controllers\BookingController->updateMaterials(Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#19 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#20 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\Routing\Route->handle(Object(Loxya\Http\Request))
#21 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#22 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(315): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#23 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\RouteRunner.php(68): Slim\Routing\Route->run(Object(Loxya\Http\Request))
#24 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\BodyParser.php(62): Slim\Routing\RouteRunner->handle(Object(Loxya\Http\Request))
#25 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Loxya\Middlewares\BodyParser->process(Object(Loxya\Http\Request), Object(Slim\Routing\RouteRunner))
#26 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#27 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Acl->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#28 C:\wamp64\www\Robert2-0.22.2\src\App\Services\Auth.php(43): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#29 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Services\Auth->middleware(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#30 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#31 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Pagination->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#32 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#33 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#34 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#35 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#36 C:\wamp64\www\Robert2-0.22.2\vendors\slim\http-cache\src\Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#37 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\HttpCache\Cache->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#38 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#39 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(199): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#40 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(183): Slim\App->handle(Object(Loxya\Http\Request))
#41 C:\wamp64\www\Robert2-0.22.2\src\App\App.php(54): Slim\App->run(Object(Loxya\Http\Request))
#42 C:\wamp64\www\Robert2-0.22.2\src\public\index.php(17): Loxya\App->run()
#43 {main}
Previous Error:
Type: PDOException
Code: 23000
Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ &#039;43-25&#039; pour la clef &#039;event_id_2&#039;
File: C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php
Line: 545
Trace: #0 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(545): PDOStatement->execute()
#1 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert into `ev...', Array)
#2 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback('insert into `ev...', Array, Object(Closure))
#3 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(534): Illuminate\Database\Connection->run('insert into `ev...', Array, Object(Closure))
#4 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(498): Illuminate\Database\Connection->statement('insert into `ev...', Array)
#5 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `ev...', Array)
#6 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ev...', Array, 'id')
#7 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#8 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1330): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#9 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#11 C:\wamp64\www\Robert2-0.22.2\src\App\Models\BaseModel.php(178): Illuminate\Database\Eloquent\Model->save(Array)
#12 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(295): Loxya\Models\BaseModel->save()
#13 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(266): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachUsingCustomClass(25, Array)
#14 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(178): Illuminate\Database\Eloquent\Relations\BelongsToMany->attach(25, Array, false)
#15 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(114): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachNew(Array, Array, false)
#16 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(862): Illuminate\Database\Eloquent\Relations\BelongsToMany->sync(Array)
#17 C:\wamp64\www\Robert2-0.22.2\src\App\Config\functions.php(129): Loxya\Models\Event->Loxya\Models\{closure}()
#18 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(860): dbTransaction(Object(Closure))
#19 C:\wamp64\www\Robert2-0.22.2\src\App\Controllers\BookingController.php(129): Loxya\Models\Event->syncMaterials(Array)
#20 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(38): Loxya\Controllers\BookingController->updateMaterials(Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#21 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#22 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\Routing\Route->handle(Object(Loxya\Http\Request))
#23 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#24 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(315): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#25 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\RouteRunner.php(68): Slim\Routing\Route->run(Object(Loxya\Http\Request))
#26 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\BodyParser.php(62): Slim\Routing\RouteRunner->handle(Object(Loxya\Http\Request))
#27 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Loxya\Middlewares\BodyParser->process(Object(Loxya\Http\Request), Object(Slim\Routing\RouteRunner))
#28 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#29 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Acl->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#30 C:\wamp64\www\Robert2-0.22.2\src\App\Services\Auth.php(43): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#31 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Services\Auth->middleware(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#32 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#33 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Pagination->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#34 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#35 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#36 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#37 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#38 C:\wamp64\www\Robert2-0.22.2\vendors\slim\http-cache\src\Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#39 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\HttpCache\Cache->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#40 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#41 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(199): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#42 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(183): Slim\App->handle(Object(Loxya\Http\Request))
#43 C:\wamp64\www\Robert2-0.22.2\src\App\App.php(54): Slim\App->run(Object(Loxya\Http\Request))
#44 C:\wamp64\www\Robert2-0.22.2\src\public\index.php(17): Loxya\App->run()
#45 {main}

guiguix

et pour l'autre 🇦

[2024-07-28T13:57:48.002123+02:00] error.ERROR: Slim Application Error
Type: Illuminate\Database\QueryException
Code: 23000
Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ &#039;43-13&#039; pour la clef &#039;event_id_2&#039; (SQL: insert into `event_materials` (`quantity_returned`, `quantity_returned_broken`, `material_id`, `event_id`, `quantity`) values (?, ?, 13, 43, 1))
File: C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php
Line: 760
Trace: #0 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback('insert into `ev...', Array, Object(Closure))
#1 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(534): Illuminate\Database\Connection->run('insert into `ev...', Array, Object(Closure))
#2 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(498): Illuminate\Database\Connection->statement('insert into `ev...', Array)
#3 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `ev...', Array)
#4 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ev...', Array, 'id')
#5 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1330): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#7 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 C:\wamp64\www\Robert2-0.22.2\src\App\Models\BaseModel.php(178): Illuminate\Database\Eloquent\Model->save(Array)
#10 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(295): Loxya\Models\BaseModel->save()
#11 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(266): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachUsingCustomClass(13, Array)
#12 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(178): Illuminate\Database\Eloquent\Relations\BelongsToMany->attach(13, Array, false)
#13 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(114): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachNew(Array, Array, false)
#14 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(862): Illuminate\Database\Eloquent\Relations\BelongsToMany->sync(Array)
#15 C:\wamp64\www\Robert2-0.22.2\src\App\Config\functions.php(129): Loxya\Models\Event->Loxya\Models\{closure}()
#16 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(860): dbTransaction(Object(Closure))
#17 C:\wamp64\www\Robert2-0.22.2\src\App\Controllers\BookingController.php(129): Loxya\Models\Event->syncMaterials(Array)
#18 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(38): Loxya\Controllers\BookingController->updateMaterials(Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#19 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#20 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\Routing\Route->handle(Object(Loxya\Http\Request))
#21 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#22 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(315): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#23 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\RouteRunner.php(68): Slim\Routing\Route->run(Object(Loxya\Http\Request))
#24 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\BodyParser.php(62): Slim\Routing\RouteRunner->handle(Object(Loxya\Http\Request))
#25 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Loxya\Middlewares\BodyParser->process(Object(Loxya\Http\Request), Object(Slim\Routing\RouteRunner))
#26 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#27 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Acl->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#28 C:\wamp64\www\Robert2-0.22.2\src\App\Services\Auth.php(43): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#29 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Services\Auth->middleware(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#30 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#31 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Pagination->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#32 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#33 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#34 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#35 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#36 C:\wamp64\www\Robert2-0.22.2\vendors\slim\http-cache\src\Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#37 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\HttpCache\Cache->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#38 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#39 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(199): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#40 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(183): Slim\App->handle(Object(Loxya\Http\Request))
#41 C:\wamp64\www\Robert2-0.22.2\src\App\App.php(54): Slim\App->run(Object(Loxya\Http\Request))
#42 C:\wamp64\www\Robert2-0.22.2\src\public\index.php(17): Loxya\App->run()
#43 {main}
Previous Error:
Type: PDOException
Code: 23000
Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ &#039;43-13&#039; pour la clef &#039;event_id_2&#039;
File: C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php
Line: 545
Trace: #0 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(545): PDOStatement->execute()
#1 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert into `ev...', Array)
#2 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback('insert into `ev...', Array, Object(Closure))
#3 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(534): Illuminate\Database\Connection->run('insert into `ev...', Array, Object(Closure))
#4 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(498): Illuminate\Database\Connection->statement('insert into `ev...', Array)
#5 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `ev...', Array)
#6 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ev...', Array, 'id')
#7 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#8 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1330): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#9 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#11 C:\wamp64\www\Robert2-0.22.2\src\App\Models\BaseModel.php(178): Illuminate\Database\Eloquent\Model->save(Array)
#12 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(295): Loxya\Models\BaseModel->save()
#13 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(266): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachUsingCustomClass(13, Array)
#14 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(178): Illuminate\Database\Eloquent\Relations\BelongsToMany->attach(13, Array, false)
#15 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(114): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachNew(Array, Array, false)
#16 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(862): Illuminate\Database\Eloquent\Relations\BelongsToMany->sync(Array)
#17 C:\wamp64\www\Robert2-0.22.2\src\App\Config\functions.php(129): Loxya\Models\Event->Loxya\Models\{closure}()
#18 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(860): dbTransaction(Object(Closure))
#19 C:\wamp64\www\Robert2-0.22.2\src\App\Controllers\BookingController.php(129): Loxya\Models\Event->syncMaterials(Array)
#20 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(38): Loxya\Controllers\BookingController->updateMaterials(Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#21 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#22 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\Routing\Route->handle(Object(Loxya\Http\Request))
#23 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#24 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(315): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#25 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\RouteRunner.php(68): Slim\Routing\Route->run(Object(Loxya\Http\Request))
#26 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\BodyParser.php(62): Slim\Routing\RouteRunner->handle(Object(Loxya\Http\Request))
#27 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Loxya\Middlewares\BodyParser->process(Object(Loxya\Http\Request), Object(Slim\Routing\RouteRunner))
#28 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#29 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Acl->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#30 C:\wamp64\www\Robert2-0.22.2\src\App\Services\Auth.php(43): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#31 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Services\Auth->middleware(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#32 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#33 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Pagination->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#34 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#35 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#36 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#37 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#38 C:\wamp64\www\Robert2-0.22.2\vendors\slim\http-cache\src\Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#39 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\HttpCache\Cache->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#40 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#41 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(199): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#42 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(183): Slim\App->handle(Object(Loxya\Http\Request))
#43 C:\wamp64\www\Robert2-0.22.2\src\App\App.php(54): Slim\App->run(Object(Loxya\Http\Request))
#44 C:\wamp64\www\Robert2-0.22.2\src\public\index.php(17): Loxya\App->run()
#45 {main}  
[2024-06-29T13:58:05.049132+02:00] error.ERROR: Slim Application Error
Type: Illuminate\Database\QueryException
Code: 23000
Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ &#039;43-25&#039; pour la clef &#039;event_id_2&#039; (SQL: insert into `event_materials` (`quantity_returned`, `quantity_returned_broken`, `material_id`, `event_id`, `quantity`) values (?, ?, 25, 43, 1))
File: C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php
Line: 760
Trace: #0 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback('insert into `ev...', Array, Object(Closure))
#1 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(534): Illuminate\Database\Connection->run('insert into `ev...', Array, Object(Closure))
#2 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(498): Illuminate\Database\Connection->statement('insert into `ev...', Array)
#3 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `ev...', Array)
#4 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ev...', Array, 'id')
#5 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1330): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#7 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 C:\wamp64\www\Robert2-0.22.2\src\App\Models\BaseModel.php(178): Illuminate\Database\Eloquent\Model->save(Array)
#10 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(295): Loxya\Models\BaseModel->save()
#11 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(266): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachUsingCustomClass(25, Array)
#12 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(178): Illuminate\Database\Eloquent\Relations\BelongsToMany->attach(25, Array, false)
#13 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(114): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachNew(Array, Array, false)
#14 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(862): Illuminate\Database\Eloquent\Relations\BelongsToMany->sync(Array)
#15 C:\wamp64\www\Robert2-0.22.2\src\App\Config\functions.php(129): Loxya\Models\Event->Loxya\Models\{closure}()
#16 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(860): dbTransaction(Object(Closure))
#17 C:\wamp64\www\Robert2-0.22.2\src\App\Controllers\BookingController.php(129): Loxya\Models\Event->syncMaterials(Array)
#18 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(38): Loxya\Controllers\BookingController->updateMaterials(Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#19 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#20 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\Routing\Route->handle(Object(Loxya\Http\Request))
#21 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#22 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(315): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#23 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\RouteRunner.php(68): Slim\Routing\Route->run(Object(Loxya\Http\Request))
#24 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\BodyParser.php(62): Slim\Routing\RouteRunner->handle(Object(Loxya\Http\Request))
#25 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Loxya\Middlewares\BodyParser->process(Object(Loxya\Http\Request), Object(Slim\Routing\RouteRunner))
#26 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#27 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Acl->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#28 C:\wamp64\www\Robert2-0.22.2\src\App\Services\Auth.php(43): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#29 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Services\Auth->middleware(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#30 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#31 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Pagination->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#32 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#33 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#34 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#35 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#36 C:\wamp64\www\Robert2-0.22.2\vendors\slim\http-cache\src\Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#37 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\HttpCache\Cache->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#38 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#39 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(199): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#40 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(183): Slim\App->handle(Object(Loxya\Http\Request))
#41 C:\wamp64\www\Robert2-0.22.2\src\App\App.php(54): Slim\App->run(Object(Loxya\Http\Request))
#42 C:\wamp64\www\Robert2-0.22.2\src\public\index.php(17): Loxya\App->run()
#43 {main}
Previous Error:
Type: PDOException
Code: 23000
Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ &#039;43-25&#039; pour la clef &#039;event_id_2&#039;
File: C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php
Line: 545
Trace: #0 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(545): PDOStatement->execute()
#1 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert into `ev...', Array)
#2 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback('insert into `ev...', Array, Object(Closure))
#3 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(534): Illuminate\Database\Connection->run('insert into `ev...', Array, Object(Closure))
#4 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(498): Illuminate\Database\Connection->statement('insert into `ev...', Array)
#5 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `ev...', Array)
#6 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ev...', Array, 'id')
#7 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#8 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1330): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#9 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#11 C:\wamp64\www\Robert2-0.22.2\src\App\Models\BaseModel.php(178): Illuminate\Database\Eloquent\Model->save(Array)
#12 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(295): Loxya\Models\BaseModel->save()
#13 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(266): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachUsingCustomClass(25, Array)
#14 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(178): Illuminate\Database\Eloquent\Relations\BelongsToMany->attach(25, Array, false)
#15 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(114): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachNew(Array, Array, false)
#16 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(862): Illuminate\Database\Eloquent\Relations\BelongsToMany->sync(Array)
#17 C:\wamp64\www\Robert2-0.22.2\src\App\Config\functions.php(129): Loxya\Models\Event->Loxya\Models\{closure}()
#18 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(860): dbTransaction(Object(Closure))
#19 C:\wamp64\www\Robert2-0.22.2\src\App\Controllers\BookingController.php(129): Loxya\Models\Event->syncMaterials(Array)
#20 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(38): Loxya\Controllers\BookingController->updateMaterials(Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#21 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#22 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\Routing\Route->handle(Object(Loxya\Http\Request))
#23 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#24 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(315): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#25 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\RouteRunner.php(68): Slim\Routing\Route->run(Object(Loxya\Http\Request))
#26 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\BodyParser.php(62): Slim\Routing\RouteRunner->handle(Object(Loxya\Http\Request))
#27 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Loxya\Middlewares\BodyParser->process(Object(Loxya\Http\Request), Object(Slim\Routing\RouteRunner))
#28 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#29 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Acl->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#30 C:\wamp64\www\Robert2-0.22.2\src\App\Services\Auth.php(43): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#31 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Services\Auth->middleware(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#32 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#33 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Pagination->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#34 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#35 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#36 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#37 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#38 C:\wamp64\www\Robert2-0.22.2\vendors\slim\http-cache\src\Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#39 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\HttpCache\Cache->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#40 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#41 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(199): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#42 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(183): Slim\App->handle(Object(Loxya\Http\Request))
#43 C:\wamp64\www\Robert2-0.22.2\src\App\App.php(54): Slim\App->run(Object(Loxya\Http\Request))
#44 C:\wamp64\www\Robert2-0.22.2\src\public\index.php(17): Loxya\App->run()
#45 {main}

Donovan

Bonjour,

Il manque les informations qui doivent être récupérées en s'aidant de la vidéo que je vous ai donné.

Quoi qu'il en soit:

Je vois dans vos logs des références à "Robert 0.22.2", utilisez-vous bien la dernière version (0.24.4 ?)
A quel moment rencontrez-vous le souci ? Sur quelle page et en faisant quelles actions ?

guiguix

voici le log 🇦 je suis sur la version 0.22

[2024-07-28T13:57:48.002123+02:00] error.ERROR: Slim Application Error
Type: Illuminate\Database\QueryException
Code: 23000
Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ &#039;43-13&#039; pour la clef &#039;event_id_2&#039; (SQL: insert into `event_materials` (`quantity_returned`, `quantity_returned_broken`, `material_id`, `event_id`, `quantity`) values (?, ?, 13, 43, 1))
File: C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php
Line: 760
Trace: #0 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback('insert into `ev...', Array, Object(Closure))
#1 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(534): Illuminate\Database\Connection->run('insert into `ev...', Array, Object(Closure))
#2 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(498): Illuminate\Database\Connection->statement('insert into `ev...', Array)
#3 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `ev...', Array)
#4 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ev...', Array, 'id')
#5 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1330): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#7 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 C:\wamp64\www\Robert2-0.22.2\src\App\Models\BaseModel.php(178): Illuminate\Database\Eloquent\Model->save(Array)
#10 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(295): Loxya\Models\BaseModel->save()
#11 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(266): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachUsingCustomClass(13, Array)
#12 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(178): Illuminate\Database\Eloquent\Relations\BelongsToMany->attach(13, Array, false)
#13 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(114): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachNew(Array, Array, false)
#14 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(862): Illuminate\Database\Eloquent\Relations\BelongsToMany->sync(Array)
#15 C:\wamp64\www\Robert2-0.22.2\src\App\Config\functions.php(129): Loxya\Models\Event->Loxya\Models\{closure}()
#16 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(860): dbTransaction(Object(Closure))
#17 C:\wamp64\www\Robert2-0.22.2\src\App\Controllers\BookingController.php(129): Loxya\Models\Event->syncMaterials(Array)
#18 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(38): Loxya\Controllers\BookingController->updateMaterials(Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#19 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#20 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\Routing\Route->handle(Object(Loxya\Http\Request))
#21 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#22 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(315): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#23 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\RouteRunner.php(68): Slim\Routing\Route->run(Object(Loxya\Http\Request))
#24 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\BodyParser.php(62): Slim\Routing\RouteRunner->handle(Object(Loxya\Http\Request))
#25 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Loxya\Middlewares\BodyParser->process(Object(Loxya\Http\Request), Object(Slim\Routing\RouteRunner))
#26 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#27 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Acl->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#28 C:\wamp64\www\Robert2-0.22.2\src\App\Services\Auth.php(43): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#29 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Services\Auth->middleware(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#30 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#31 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Pagination->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#32 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#33 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#34 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#35 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#36 C:\wamp64\www\Robert2-0.22.2\vendors\slim\http-cache\src\Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#37 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\HttpCache\Cache->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#38 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#39 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(199): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#40 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(183): Slim\App->handle(Object(Loxya\Http\Request))
#41 C:\wamp64\www\Robert2-0.22.2\src\App\App.php(54): Slim\App->run(Object(Loxya\Http\Request))
#42 C:\wamp64\www\Robert2-0.22.2\src\public\index.php(17): Loxya\App->run()
#43 {main}
Previous Error:
Type: PDOException
Code: 23000
Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ &#039;43-13&#039; pour la clef &#039;event_id_2&#039;
File: C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php
Line: 545
Trace: #0 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(545): PDOStatement->execute()
#1 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert into `ev...', Array)
#2 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback('insert into `ev...', Array, Object(Closure))
#3 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(534): Illuminate\Database\Connection->run('insert into `ev...', Array, Object(Closure))
#4 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(498): Illuminate\Database\Connection->statement('insert into `ev...', Array)
#5 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `ev...', Array)
#6 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ev...', Array, 'id')
#7 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#8 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1330): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#9 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#11 C:\wamp64\www\Robert2-0.22.2\src\App\Models\BaseModel.php(178): Illuminate\Database\Eloquent\Model->save(Array)
#12 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(295): Loxya\Models\BaseModel->save()
#13 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(266): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachUsingCustomClass(13, Array)
#14 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(178): Illuminate\Database\Eloquent\Relations\BelongsToMany->attach(13, Array, false)
#15 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(114): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachNew(Array, Array, false)
#16 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(862): Illuminate\Database\Eloquent\Relations\BelongsToMany->sync(Array)
#17 C:\wamp64\www\Robert2-0.22.2\src\App\Config\functions.php(129): Loxya\Models\Event->Loxya\Models\{closure}()
#18 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(860): dbTransaction(Object(Closure))
#19 C:\wamp64\www\Robert2-0.22.2\src\App\Controllers\BookingController.php(129): Loxya\Models\Event->syncMaterials(Array)
#20 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(38): Loxya\Controllers\BookingController->updateMaterials(Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#21 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#22 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\Routing\Route->handle(Object(Loxya\Http\Request))
#23 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#24 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(315): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#25 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\RouteRunner.php(68): Slim\Routing\Route->run(Object(Loxya\Http\Request))
#26 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\BodyParser.php(62): Slim\Routing\RouteRunner->handle(Object(Loxya\Http\Request))
#27 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Loxya\Middlewares\BodyParser->process(Object(Loxya\Http\Request), Object(Slim\Routing\RouteRunner))
#28 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#29 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Acl->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#30 C:\wamp64\www\Robert2-0.22.2\src\App\Services\Auth.php(43): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#31 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Services\Auth->middleware(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#32 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#33 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Pagination->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#34 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#35 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#36 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#37 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#38 C:\wamp64\www\Robert2-0.22.2\vendors\slim\http-cache\src\Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#39 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\HttpCache\Cache->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#40 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#41 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(199): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#42 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(183): Slim\App->handle(Object(Loxya\Http\Request))
#43 C:\wamp64\www\Robert2-0.22.2\src\App\App.php(54): Slim\App->run(Object(Loxya\Http\Request))
#44 C:\wamp64\www\Robert2-0.22.2\src\public\index.php(17): Loxya\App->run()
#45 {main}  
[2024-06-29T13:58:05.049132+02:00] error.ERROR: Slim Application Error
Type: Illuminate\Database\QueryException
Code: 23000
Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ &#039;43-25&#039; pour la clef &#039;event_id_2&#039; (SQL: insert into `event_materials` (`quantity_returned`, `quantity_returned_broken`, `material_id`, `event_id`, `quantity`) values (?, ?, 25, 43, 1))
File: C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php
Line: 760
Trace: #0 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback('insert into `ev...', Array, Object(Closure))
#1 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(534): Illuminate\Database\Connection->run('insert into `ev...', Array, Object(Closure))
#2 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(498): Illuminate\Database\Connection->statement('insert into `ev...', Array)
#3 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `ev...', Array)
#4 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ev...', Array, 'id')
#5 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#6 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1330): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#7 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#8 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#9 C:\wamp64\www\Robert2-0.22.2\src\App\Models\BaseModel.php(178): Illuminate\Database\Eloquent\Model->save(Array)
#10 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(295): Loxya\Models\BaseModel->save()
#11 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(266): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachUsingCustomClass(25, Array)
#12 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(178): Illuminate\Database\Eloquent\Relations\BelongsToMany->attach(25, Array, false)
#13 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(114): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachNew(Array, Array, false)
#14 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(862): Illuminate\Database\Eloquent\Relations\BelongsToMany->sync(Array)
#15 C:\wamp64\www\Robert2-0.22.2\src\App\Config\functions.php(129): Loxya\Models\Event->Loxya\Models\{closure}()
#16 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(860): dbTransaction(Object(Closure))
#17 C:\wamp64\www\Robert2-0.22.2\src\App\Controllers\BookingController.php(129): Loxya\Models\Event->syncMaterials(Array)
#18 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(38): Loxya\Controllers\BookingController->updateMaterials(Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#19 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#20 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\Routing\Route->handle(Object(Loxya\Http\Request))
#21 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#22 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(315): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#23 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\RouteRunner.php(68): Slim\Routing\Route->run(Object(Loxya\Http\Request))
#24 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\BodyParser.php(62): Slim\Routing\RouteRunner->handle(Object(Loxya\Http\Request))
#25 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Loxya\Middlewares\BodyParser->process(Object(Loxya\Http\Request), Object(Slim\Routing\RouteRunner))
#26 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#27 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Acl->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#28 C:\wamp64\www\Robert2-0.22.2\src\App\Services\Auth.php(43): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#29 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Services\Auth->middleware(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#30 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#31 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Pagination->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#32 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#33 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#34 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#35 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#36 C:\wamp64\www\Robert2-0.22.2\vendors\slim\http-cache\src\Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#37 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\HttpCache\Cache->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#38 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#39 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(199): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#40 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(183): Slim\App->handle(Object(Loxya\Http\Request))
#41 C:\wamp64\www\Robert2-0.22.2\src\App\App.php(54): Slim\App->run(Object(Loxya\Http\Request))
#42 C:\wamp64\www\Robert2-0.22.2\src\public\index.php(17): Loxya\App->run()
#43 {main}
Previous Error:
Type: PDOException
Code: 23000
Message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ &#039;43-25&#039; pour la clef &#039;event_id_2&#039;
File: C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php
Line: 545
Trace: #0 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(545): PDOStatement->execute()
#1 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert into `ev...', Array)
#2 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(720): Illuminate\Database\Connection->runQueryCallback('insert into `ev...', Array, Object(Closure))
#3 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(534): Illuminate\Database\Connection->run('insert into `ev...', Array, Object(Closure))
#4 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Connection.php(498): Illuminate\Database\Connection->statement('insert into `ev...', Array)
#5 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Processors\Processor.php(32): Illuminate\Database\Connection->insert('insert into `ev...', Array)
#6 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Query\Builder.php(3322): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `ev...', Array, 'id')
#7 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Builder.php(1869): Illuminate\Database\Query\Builder->insertGetId(Array, 'id')
#8 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1330): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array)
#9 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1295): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array)
#10 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Model.php(1138): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder))
#11 C:\wamp64\www\Robert2-0.22.2\src\App\Models\BaseModel.php(178): Illuminate\Database\Eloquent\Model->save(Array)
#12 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(295): Loxya\Models\BaseModel->save()
#13 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(266): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachUsingCustomClass(25, Array)
#14 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(178): Illuminate\Database\Eloquent\Relations\BelongsToMany->attach(25, Array, false)
#15 C:\wamp64\www\Robert2-0.22.2\vendors\illuminate\database\Eloquent\Relations\Concerns\InteractsWithPivotTable.php(114): Illuminate\Database\Eloquent\Relations\BelongsToMany->attachNew(Array, Array, false)
#16 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(862): Illuminate\Database\Eloquent\Relations\BelongsToMany->sync(Array)
#17 C:\wamp64\www\Robert2-0.22.2\src\App\Config\functions.php(129): Loxya\Models\Event->Loxya\Models\{closure}()
#18 C:\wamp64\www\Robert2-0.22.2\src\App\Models\Event.php(860): dbTransaction(Object(Closure))
#19 C:\wamp64\www\Robert2-0.22.2\src\App\Controllers\BookingController.php(129): Loxya\Models\Event->syncMaterials(Array)
#20 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Handlers\Strategies\RequestResponse.php(38): Loxya\Controllers\BookingController->updateMaterials(Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#21 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(358): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Loxya\Http\Request), Object(Slim\Http\Response), Array)
#22 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\Routing\Route->handle(Object(Loxya\Http\Request))
#23 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#24 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\Route.php(315): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#25 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Routing\RouteRunner.php(68): Slim\Routing\Route->run(Object(Loxya\Http\Request))
#26 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\BodyParser.php(62): Slim\Routing\RouteRunner->handle(Object(Loxya\Http\Request))
#27 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Loxya\Middlewares\BodyParser->process(Object(Loxya\Http\Request), Object(Slim\Routing\RouteRunner))
#28 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#29 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Acl->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#30 C:\wamp64\www\Robert2-0.22.2\src\App\Services\Auth.php(43): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#31 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Services\Auth->middleware(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#32 C:\wamp64\www\Robert2-0.22.2\src\App\Middlewares\Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#33 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(269): Loxya\Middlewares\Pagination->__invoke(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#34 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#35 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#36 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\Middleware\ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#37 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#38 C:\wamp64\www\Robert2-0.22.2\vendors\slim\http-cache\src\Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#39 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(121): Slim\HttpCache\Cache->process(Object(Loxya\Http\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous))
#40 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Loxya\Http\Request))
#41 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(199): Slim\MiddlewareDispatcher->handle(Object(Loxya\Http\Request))
#42 C:\wamp64\www\Robert2-0.22.2\vendors\slim\slim\Slim\App.php(183): Slim\App->handle(Object(Loxya\Http\Request))
#43 C:\wamp64\www\Robert2-0.22.2\src\App\App.php(54): Slim\App->run(Object(Loxya\Http\Request))
#44 C:\wamp64\www\Robert2-0.22.2\src\public\index.php(17): Loxya\App->run()
#45 {main}

Donovan

Bonjour,

Ce n'est malheureusement pas les informations qui nous permettrons de vous aider.

Il faut regarder la vidéo https://www.youtube.com/watch?v=-Ri4ocjBqc4 qui permet de récupérer le détails du message d'erreur retourné lorsque la page vous dit "Api Inaccessible".
A quel moment rencontrez-vous le souci ? Sur quelle page et en faisant quelles actions ?

Quoi qu'il en soit, vous rencontrez peut-être un souci qui a été corrigé depuis, il serait sans doute judicieux de mettre à jour votre application vers la dernière version.

Donovan

Faute de détails, je ferme ce sujet.

Merci de rouvrir un ticket avec les détails demandés si le problème est toujours d'actualité.

Vous avez besoin d'une aide personnalisée de la part de l'un des développeurs du logiciel, pour son installation ou son paramétrage ?

Prenez rendez-vous directement sur la page calendly.com/loxya/support-installation.
Nous vous aiderons avec plaisir !