Bonjour à tous,
Lors de la mise à jour de la v0.17.1 vers v0.20.3, j'ai un message d'erreur lors de la migration des données.
using migration paths
- /home/jeunesvideastes/public_html/Robert2-0.20.3/src/migrations
using seed paths
using environment production
using database jeunesvideastes_robert
using table prefix
ordering by creation time
== 20220212093314 AddPublicCalendarSettings: migrating
== 20220212093314 AddPublicCalendarSettings: migrated 0.0118s
== 20220310102047 UpgradeDegressiveRateFields: migrating
== 20220310102047 UpgradeDegressiveRateFields: migrated 0.2052s
== 20220521083508 RemovesTagsFromCompanies: migrating
== 20220521083508 RemovesTagsFromCompanies: migrated 0.0113s
== 20220610135611 RemoveInvalidDatesFromMaterialAttributes: migrating
== 20220610135611 RemoveInvalidDatesFromMaterialAttributes: migrated 0.0031s
== 20220614143500 AllowUncategorizedMaterials: migrating
== 20220614143500 AllowUncategorizedMaterials: migrated 0.1355s
== 20220624221439 MoveUploadedFiles: migrating
== 20220624221439 MoveUploadedFiles: migrated 0.0195s
== 20220719071824 AllowEmptyRentalPrice: migrating
== 20220719071824 AllowEmptyRentalPrice: migrated 0.0612s
== 20220730083854 RemovesGroupsTable: migrating
== 20220730083854 RemovesGroupsTable: migrated 0.1231s
== 20220826113248 CreateGroupsProfile: migrating
PDOException: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'beneficiary_id' at row 1 in /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:192
Stack trace:
#0 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(192): PDO->exec()
#1 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Db/Util/AlterInstructions.php(108): Phinx\Db\Adapter\PdoAdapter->execute()
#2 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(626): Phinx\Db\Util\AlterInstructions->execute()
#3 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(1001): Phinx\Db\Adapter\PdoAdapter->executeAlterSteps()
#4 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(477): Phinx\Db\Adapter\PdoAdapter->executeActions()
#5 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Db/Adapter/TimedOutputAdapter.php(420): Phinx\Db\Adapter\AdapterWrapper->executeActions()
#6 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(477): Phinx\Db\Adapter\TimedOutputAdapter->executeActions()
#7 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Db/Adapter/TablePrefixAdapter.php(492): Phinx\Db\Adapter\AdapterWrapper->executeActions()
#8 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Db/Plan/Plan.php(151): Phinx\Db\Adapter\TablePrefixAdapter->executeActions()
#9 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Db/Table.php(719): Phinx\Db\Plan\Plan->execute()
#10 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Db/Table.php(627): Phinx\Db\Table->executeActions()
#11 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/migrations/20220826113248_create_groups_profile.php(138): Phinx\Db\Table->update()
#12 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(111): CreateGroupsProfile->up()
#13 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Migration/Manager.php(388): Phinx\Migration\Manager\Environment->executeMigration()
#14 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Migration/Manager.php(359): Phinx\Migration\Manager->executeMigration()
#15 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(122): Phinx\Migration\Manager->migrate()
#16 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/App/Console/Command/Migrations/ConfigurationTrait.php(67): Phinx\Console\Command\Migrate->execute()
#17 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/symfony/console/Command/Command.php(291): Robert2\API\Console\Command\Migrations\MigrateCommand->execute()
#18 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/symfony/console/Application.php(1014): Symfony\Component\Console\Command\Command->run()
#19 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/App/Console/App.php(63): Symfony\Component\Console\Application->doRunCommand()
#20 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/symfony/console/Application.php(301): Robert2\API\Console\App->doRunCommand()
#21 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/App/Console/App.php(49): Symfony\Component\Console\Application->doRun()
#22 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/install/Install.php(170): Robert2\API\Console\App->doRun()
#23 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/install/Install.php(119): Robert2\Install\Install::_executePhinxCommand()
#24 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/App/Controllers/SetupController.php(100): Robert2\Install\Install::migrateDatabase()
#25 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(43): Robert2\API\Controllers\SetupController->index()
#26 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/Routing/Route.php(384): Slim\Handlers\Strategies\RequestResponse->__invoke()
#27 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/MiddlewareDispatcher.php(81): Slim\Routing\Route->handle()
#28 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/MiddlewareDispatcher.php(81): Slim\MiddlewareDispatcher->handle()
#29 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/Routing/Route.php(341): Slim\MiddlewareDispatcher->handle()
#30 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/Routing/RouteRunner.php(84): Slim\Routing\Route->run()
#31 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/App/Middlewares/BodyParser.php(62): Slim\Routing\RouteRunner->handle()
#32 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/MiddlewareDispatcher.php(147): Robert2\API\Middlewares\BodyParser->process()
#33 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/App/Middlewares/Acl.php(35): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#34 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/MiddlewareDispatcher.php(313): Robert2\API\Middlewares\Acl->__invoke()
#35 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/App/Services/Auth.php(37): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#36 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/MiddlewareDispatcher.php(313): Robert2\API\Services\Auth->middleware()
#37 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/App/Middlewares/Pagination.php(20): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#38 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/MiddlewareDispatcher.php(313): Robert2\API\Middlewares\Pagination->__invoke()
#39 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/Middleware/RoutingMiddleware.php(59): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#40 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/MiddlewareDispatcher.php(147): Slim\Middleware\RoutingMiddleware->process()
#41 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/Middleware/ErrorMiddleware.php(107): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#42 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/MiddlewareDispatcher.php(147): Slim\Middleware\ErrorMiddleware->process()
#43 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/http-cache/src/Cache.php(67): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#44 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/MiddlewareDispatcher.php(147): Slim\HttpCache\Cache->process()
#45 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/MiddlewareDispatcher.php(81): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#46 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/App.php(215): Slim\MiddlewareDispatcher->handle()
#47 /home/jeunesvideastes/public_html/Robert2-0.20.3/vendors/slim/slim/Slim/App.php(199): Slim\App->handle()
#48 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/App/App.php(51): Slim\App->run()
#49 /home/jeunesvideastes/public_html/Robert2-0.20.3/src/public/index.php(17): Robert2\API\App->run()
#50 {main}
J'ai bien vérifié mes versions mysql (10.5.19-MariaDB) et php (8.1.16).
J'ai également essayé de trouver d'éventuelles corruptions de la DB, sans succès.
Pour info, voici les tables à priori concernées par le problème avant migration :
event_beneficiaries
(`id`, `event_id`, `person_id`)
(1, 1, 5),
(2, 2, 5),
(3, 3, 5),
(4, 4, 10),
(5, 5, 10),
(6, 7, 12),
(8, 9, 13),
(9, 10, 14),
(10, 12, 13),
(11, 13, 14),
(12, 14, 5),
(13, 27, 5),
(14, 30, 10),
(15, 29, 15),
(16, 32, 12),
(17, 33, 14),
(18, 28, 16),
(19, 34, 5),
(20, 35, 5),
(21, 31, 17),
(22, 38, 12),
(23, 39, 14),
(24, 40, 18),
(25, 41, 19),
(26, 42, 19),
(27, 43, 17),
(28, 45, 16),
(29, 46, 17),
(30, 48, 20),
(31, 49, 14),
(32, 50, 14),
(33, 47, 21),
(34, 51, 16),
(35, 52, 19),
(36, 53, 21),
(37, 54, 12),
(38, 55, 19),
(39, 56, 20),
(40, 58, 22),
(41, 59, 22),
(42, 60, 5),
(43, 57, 23),
(44, 61, 23),
(45, 62, 20),
(46, 63, 20),
(47, 64, 19),
(48, 65, 10),
(49, 66, 13),
(50, 67, 21),
(51, 68, 19),
(52, 69, 24),
(53, 71, 25),
(54, 72, 16),
(55, 73, 26),
(56, 74, 16),
(57, 75, 18),
(58, 76, 16),
(59, 77, 23),
(60, 78, 19),
(61, 79, 14),
(62, 80, 5),
(63, 81, 16),
(64, 82, 21),
(65, 83, 21),
(66, 84, 27),
(67, 85, 18),
(68, 87, 27),
(69, 88, 10),
(70, 89, 28),
(71, 90, 16),
(72, 91, 16),
(73, 92, 29),
(74, 93, 16),
(75, 94, 20),
(76, 97, 16),
(77, 95, 30),
(78, 98, 18),
(79, 99, 23),
(80, 100, 5),
(81, 101, 20),
(82, 103, 30),
(83, 104, 14),
(84, 105, 23),
(85, 106, 5),
(86, 107, 5),
(87, 108, 21),
(88, 109, 5),
(89, 111, 16),
(90, 112, 20),
(91, 113, 5),
(92, 114, 14),
(93, 115, 16),
(94, 116, 16),
(95, 117, 16),
(96, 118, 16),
(97, 119, 16),
(98, 120, 31),
(100, 121, 32),
(101, 122, 33),
(102, 123, 32),
(103, 124, 18),
(104, 125, 12),
(105, 126, 12),
(106, 127, 34),
(107, 128, 18),
(108, 129, 31),
(109, 130, 32),
(110, 131, 12),
(111, 132, 12),
(112, 133, 18),
(113, 134, 12),
(114, 135, 12),
(115, 136, 18),
(116, 137, 32),
(117, 138, 33),
(118, 139, 31);
event_technicians
(`id`, `event_id`, `technician_id`, `start_time`, `end_time`, `position`)
(3, 2, 2, '2021-12-16 04:00:00', '2021-12-16 04:15:00', NULL),
(9, 1, 2, '2021-12-07 08:00:00', '2021-12-07 08:15:00', NULL),
(10, 3, 2, '2021-12-16 06:30:00', '2021-12-24 06:45:00', NULL),
(13, 5, 6, '2021-12-09 17:00:00', '2021-12-09 18:00:00', NULL),
(14, 5, 2, '2021-12-14 17:00:00', '2021-12-14 18:00:00', NULL),
(15, 7, 6, '2021-12-16 17:00:00', '2021-12-16 18:00:00', NULL),
(16, 7, 2, '2021-12-21 17:00:00', '2021-12-21 17:00:00', NULL),
(17, 9, 2, '2021-12-16 17:00:00', '2021-12-16 18:00:00', NULL),
(18, 9, 2, '2021-12-19 16:00:00', '2021-12-19 16:15:00', NULL),
(37, 13, 2, '2021-12-21 17:00:00', '2021-12-21 18:00:00', NULL),
(38, 13, 6, '2021-12-28 17:00:00', '2021-12-28 18:00:00', NULL),
(39, 29, 6, '2022-01-06 17:00:00', '2022-01-06 18:00:00', NULL),
(40, 29, 2, '2022-01-11 17:00:00', '2022-01-11 18:00:00', NULL),
(41, 30, 6, '2022-01-13 17:00:00', '2022-01-13 18:00:00', NULL),
(42, 30, 2, '2022-01-18 17:00:00', '2022-01-18 18:00:00', NULL),
(44, 12, 6, '2022-01-03 08:30:00', '2022-01-03 09:30:00', NULL),
(45, 12, 2, '2022-01-11 17:00:00', '2022-01-11 18:00:00', NULL),
(46, 4, 6, '2022-01-06 23:00:00', '2022-01-07 00:00:00', NULL),
(53, 28, 2, '2022-01-13 17:00:00', '2022-01-13 18:00:00', NULL),
(54, 28, 2, '2022-01-18 17:00:00', '2022-01-18 18:00:00', NULL),
(55, 32, 2, '2022-01-13 17:00:00', '2022-01-13 18:00:00', NULL),
(56, 32, 2, '2022-01-18 17:00:00', '2022-01-18 23:45:00', NULL),
(57, 33, 2, '2022-01-13 17:00:00', '2022-01-13 18:00:00', NULL),
(58, 38, 6, '2022-02-03 17:00:00', '2022-02-03 18:00:00', NULL),
(59, 38, 2, '2022-02-08 17:00:00', '2022-02-08 18:00:00', NULL),
(60, 39, 6, '2022-02-03 17:00:00', '2022-02-03 18:00:00', NULL),
(61, 39, 2, '2022-02-08 17:00:00', '2022-02-08 18:00:00', NULL),
(62, 40, 2, '2022-02-04 16:30:00', '2022-02-04 17:00:00', NULL),
(63, 40, 2, '2022-02-08 17:00:00', '2022-02-08 18:00:00', NULL),
(64, 41, 6, '2022-02-10 17:00:00', '2022-02-10 18:00:00', NULL),
(67, 42, 6, '2022-02-17 17:00:00', '2022-02-17 23:45:00', NULL),
(68, 50, 2, '2022-03-15 17:45:00', '2022-03-15 18:00:00', NULL),
(69, 50, 6, '2022-03-17 06:00:00', '2022-03-17 06:15:00', NULL),
(70, 55, 6, '2022-03-24 21:15:00', '2022-03-24 21:30:00', NULL),
(71, 55, 2, '2022-03-29 06:30:00', '2022-03-29 06:45:00', NULL),
(72, 71, 6, '2022-05-05 16:00:00', '2022-05-05 17:00:00', NULL),
(73, 71, 2, '2022-05-10 16:00:00', '2022-05-10 17:00:00', NULL),
(74, 74, 6, '2022-05-24 04:00:00', '2022-05-24 04:15:00', NULL),
(75, 91, 6, '2022-07-26 16:00:00', '2022-07-28 17:00:00', NULL),
(76, 94, 6, '2022-09-15 16:30:00', '2022-09-15 17:00:00', NULL),
(77, 94, 6, '2022-09-20 16:00:00', '2022-09-20 16:30:00', NULL),
(80, 97, 6, '2022-09-13 19:45:00', '2022-09-13 20:00:00', NULL),
(81, 97, 6, '2022-09-20 09:30:00', '2022-09-20 09:45:00', NULL),
(82, 105, 6, '2022-10-14 19:30:00', '2022-10-14 19:45:00', NULL),
(83, 105, 6, '2022-10-17 23:30:00', '2022-10-17 23:45:00', NULL),
(84, 114, 6, '2022-11-17 19:15:00', '2022-11-17 19:30:00', NULL),
(85, 114, 6, '2022-11-22 10:45:00', '2022-11-22 11:00:00', NULL);
taggables
(1, 'Robert2\\API\\Models\\Company', 1),
(1, 'Robert2\\API\\Models\\Person', 5),
(1, 'Robert2\\API\\Models\\Person', 10),
(1, 'Robert2\\API\\Models\\Person', 12),
(1, 'Robert2\\API\\Models\\Person', 13),
(1, 'Robert2\\API\\Models\\Person', 14),
(1, 'Robert2\\API\\Models\\Person', 15),
(1, 'Robert2\\API\\Models\\Person', 16),
(1, 'Robert2\\API\\Models\\Person', 17),
(1, 'Robert2\\API\\Models\\Person', 18),
(1, 'Robert2\\API\\Models\\Person', 19),
(1, 'Robert2\\API\\Models\\Person', 20),
(1, 'Robert2\\API\\Models\\Person', 21),
(1, 'Robert2\\API\\Models\\Person', 22),
(1, 'Robert2\\API\\Models\\Person', 23),
(1, 'Robert2\\API\\Models\\Person', 24),
(1, 'Robert2\\API\\Models\\Person', 25),
(1, 'Robert2\\API\\Models\\Person', 26),
(1, 'Robert2\\API\\Models\\Person', 27),
(1, 'Robert2\\API\\Models\\Person', 28),
(1, 'Robert2\\API\\Models\\Person', 29),
(1, 'Robert2\\API\\Models\\Person', 30),
(1, 'Robert2\\API\\Models\\Person', 31),
(1, 'Robert2\\API\\Models\\Person', 32),
(1, 'Robert2\\API\\Models\\Person', 33),
(1, 'Robert2\\API\\Models\\Person', 34),
(2, 'Robert2\\API\\Models\\Person', 2),
(2, 'Robert2\\API\\Models\\Person', 6);
tags
(1, 'Membre', '2021-11-20 02:27:40', '2021-11-20 02:27:40', NULL),
(2, 'Loueur', '2021-11-20 02:27:40', '2021-11-20 02:27:40', NULL);
Et les tables après que l'erreur soit survenue (je remarque que tous les beneficiary_id
sont à NULL
) :
event_beneficiaries
(1, 1, NULL, 5),
(2, 2, NULL, 5),
(3, 3, NULL, 5),
(4, 4, NULL, 10),
(5, 5, NULL, 10),
(6, 7, NULL, 12),
(8, 9, NULL, 13),
(9, 10, NULL, 14),
(10, 12, NULL, 13),
(11, 13, NULL, 14),
(12, 14, NULL, 5),
(13, 27, NULL, 5),
(14, 30, NULL, 10),
(15, 29, NULL, 15),
(16, 32, NULL, 12),
(17, 33, NULL, 14),
(18, 28, NULL, 16),
(19, 34, NULL, 5),
(20, 35, NULL, 5),
(21, 31, NULL, 17),
(22, 38, NULL, 12),
(23, 39, NULL, 14),
(24, 40, NULL, 18),
(25, 41, NULL, 19),
(26, 42, NULL, 19),
(27, 43, NULL, 17),
(28, 45, NULL, 16),
(29, 46, NULL, 17),
(30, 48, NULL, 20),
(31, 49, NULL, 14),
(32, 50, NULL, 14),
(33, 47, NULL, 21),
(34, 51, NULL, 16),
(35, 52, NULL, 19),
(36, 53, NULL, 21),
(37, 54, NULL, 12),
(38, 55, NULL, 19),
(39, 56, NULL, 20),
(40, 58, NULL, 22),
(41, 59, NULL, 22),
(42, 60, NULL, 5),
(43, 57, NULL, 23),
(44, 61, NULL, 23),
(45, 62, NULL, 20),
(46, 63, NULL, 20),
(47, 64, NULL, 19),
(48, 65, NULL, 10),
(49, 66, NULL, 13),
(50, 67, NULL, 21),
(51, 68, NULL, 19),
(52, 69, NULL, 24),
(53, 71, NULL, 25),
(54, 72, NULL, 16),
(55, 73, NULL, 26),
(56, 74, NULL, 16),
(57, 75, NULL, 18),
(58, 76, NULL, 16),
(59, 77, NULL, 23),
(60, 78, NULL, 19),
(61, 79, NULL, 14),
(62, 80, NULL, 5),
(63, 81, NULL, 16),
(64, 82, NULL, 21),
(65, 83, NULL, 21),
(66, 84, NULL, 27),
(67, 85, NULL, 18),
(68, 87, NULL, 27),
(69, 88, NULL, 10),
(70, 89, NULL, 28),
(71, 90, NULL, 16),
(72, 91, NULL, 16),
(73, 92, NULL, 29),
(74, 93, NULL, 16),
(75, 94, NULL, 20),
(76, 97, NULL, 16),
(77, 95, NULL, 30),
(78, 98, NULL, 18),
(79, 99, NULL, 23),
(80, 100, NULL, 5),
(81, 101, NULL, 20),
(82, 103, NULL, 30),
(83, 104, NULL, 14),
(84, 105, NULL, 23),
(85, 106, NULL, 5),
(86, 107, NULL, 5),
(87, 108, NULL, 21),
(88, 109, NULL, 5),
(89, 111, NULL, 16),
(90, 112, NULL, 20),
(91, 113, NULL, 5),
(92, 114, NULL, 14),
(93, 115, NULL, 16),
(94, 116, NULL, 16),
(95, 117, NULL, 16),
(96, 118, NULL, 16),
(97, 119, NULL, 16),
(98, 120, NULL, 31),
(100, 121, NULL, 32),
(101, 122, NULL, 33),
(102, 123, NULL, 32),
(103, 124, NULL, 18),
(104, 125, NULL, 12),
(105, 126, NULL, 12),
(106, 127, NULL, 34),
(107, 128, NULL, 18),
(108, 129, NULL, 31),
(109, 130, NULL, 32),
(110, 131, NULL, 12),
(111, 132, NULL, 12),
(112, 133, NULL, 18),
(113, 134, NULL, 12),
(114, 135, NULL, 12),
(115, 136, NULL, 18),
(116, 137, NULL, 32),
(117, 138, NULL, 33),
(118, 139, NULL, 31);
event_technicians
(3, 2, 2, '2021-12-16 04:00:00', '2021-12-16 04:15:00', NULL),
(9, 1, 2, '2021-12-07 08:00:00', '2021-12-07 08:15:00', NULL),
(10, 3, 2, '2021-12-16 06:30:00', '2021-12-24 06:45:00', NULL),
(13, 5, 6, '2021-12-09 17:00:00', '2021-12-09 18:00:00', NULL),
(14, 5, 2, '2021-12-14 17:00:00', '2021-12-14 18:00:00', NULL),
(15, 7, 6, '2021-12-16 17:00:00', '2021-12-16 18:00:00', NULL),
(16, 7, 2, '2021-12-21 17:00:00', '2021-12-21 17:00:00', NULL),
(17, 9, 2, '2021-12-16 17:00:00', '2021-12-16 18:00:00', NULL),
(18, 9, 2, '2021-12-19 16:00:00', '2021-12-19 16:15:00', NULL),
(37, 13, 2, '2021-12-21 17:00:00', '2021-12-21 18:00:00', NULL),
(38, 13, 6, '2021-12-28 17:00:00', '2021-12-28 18:00:00', NULL),
(39, 29, 6, '2022-01-06 17:00:00', '2022-01-06 18:00:00', NULL),
(40, 29, 2, '2022-01-11 17:00:00', '2022-01-11 18:00:00', NULL),
(41, 30, 6, '2022-01-13 17:00:00', '2022-01-13 18:00:00', NULL),
(42, 30, 2, '2022-01-18 17:00:00', '2022-01-18 18:00:00', NULL),
(44, 12, 6, '2022-01-03 08:30:00', '2022-01-03 09:30:00', NULL),
(45, 12, 2, '2022-01-11 17:00:00', '2022-01-11 18:00:00', NULL),
(46, 4, 6, '2022-01-06 23:00:00', '2022-01-07 00:00:00', NULL),
(53, 28, 2, '2022-01-13 17:00:00', '2022-01-13 18:00:00', NULL),
(54, 28, 2, '2022-01-18 17:00:00', '2022-01-18 18:00:00', NULL),
(55, 32, 2, '2022-01-13 17:00:00', '2022-01-13 18:00:00', NULL),
(56, 32, 2, '2022-01-18 17:00:00', '2022-01-18 23:45:00', NULL),
(57, 33, 2, '2022-01-13 17:00:00', '2022-01-13 18:00:00', NULL),
(58, 38, 6, '2022-02-03 17:00:00', '2022-02-03 18:00:00', NULL),
(59, 38, 2, '2022-02-08 17:00:00', '2022-02-08 18:00:00', NULL),
(60, 39, 6, '2022-02-03 17:00:00', '2022-02-03 18:00:00', NULL),
(61, 39, 2, '2022-02-08 17:00:00', '2022-02-08 18:00:00', NULL),
(62, 40, 2, '2022-02-04 16:30:00', '2022-02-04 17:00:00', NULL),
(63, 40, 2, '2022-02-08 17:00:00', '2022-02-08 18:00:00', NULL),
(64, 41, 6, '2022-02-10 17:00:00', '2022-02-10 18:00:00', NULL),
(67, 42, 6, '2022-02-17 17:00:00', '2022-02-17 23:45:00', NULL),
(68, 50, 2, '2022-03-15 17:45:00', '2022-03-15 18:00:00', NULL),
(69, 50, 6, '2022-03-17 06:00:00', '2022-03-17 06:15:00', NULL),
(70, 55, 6, '2022-03-24 21:15:00', '2022-03-24 21:30:00', NULL),
(71, 55, 2, '2022-03-29 06:30:00', '2022-03-29 06:45:00', NULL),
(72, 71, 6, '2022-05-05 16:00:00', '2022-05-05 17:00:00', NULL),
(73, 71, 2, '2022-05-10 16:00:00', '2022-05-10 17:00:00', NULL),
(74, 74, 6, '2022-05-24 04:00:00', '2022-05-24 04:15:00', NULL),
(75, 91, 6, '2022-07-26 16:00:00', '2022-07-28 17:00:00', NULL),
(76, 94, 6, '2022-09-15 16:30:00', '2022-09-15 17:00:00', NULL),
(77, 94, 6, '2022-09-20 16:00:00', '2022-09-20 16:30:00', NULL),
(80, 97, 6, '2022-09-13 19:45:00', '2022-09-13 20:00:00', NULL),
(81, 97, 6, '2022-09-20 09:30:00', '2022-09-20 09:45:00', NULL),
(82, 105, 6, '2022-10-14 19:30:00', '2022-10-14 19:45:00', NULL),
(83, 105, 6, '2022-10-17 23:30:00', '2022-10-17 23:45:00', NULL),
(84, 114, 6, '2022-11-17 19:15:00', '2022-11-17 19:30:00', NULL),
(85, 114, 6, '2022-11-22 10:45:00', '2022-11-22 11:00:00', NULL);
taggables
(1, 'Robert2\\API\\Models\\Person', 5),
(1, 'Robert2\\API\\Models\\Person', 10),
(1, 'Robert2\\API\\Models\\Person', 12),
(1, 'Robert2\\API\\Models\\Person', 13),
(1, 'Robert2\\API\\Models\\Person', 14),
(1, 'Robert2\\API\\Models\\Person', 15),
(1, 'Robert2\\API\\Models\\Person', 16),
(1, 'Robert2\\API\\Models\\Person', 17),
(1, 'Robert2\\API\\Models\\Person', 18),
(1, 'Robert2\\API\\Models\\Person', 19),
(1, 'Robert2\\API\\Models\\Person', 20),
(1, 'Robert2\\API\\Models\\Person', 21),
(1, 'Robert2\\API\\Models\\Person', 22),
(1, 'Robert2\\API\\Models\\Person', 23),
(1, 'Robert2\\API\\Models\\Person', 24),
(1, 'Robert2\\API\\Models\\Person', 25),
(1, 'Robert2\\API\\Models\\Person', 26),
(1, 'Robert2\\API\\Models\\Person', 27),
(1, 'Robert2\\API\\Models\\Person', 28),
(1, 'Robert2\\API\\Models\\Person', 29),
(1, 'Robert2\\API\\Models\\Person', 30),
(1, 'Robert2\\API\\Models\\Person', 31),
(1, 'Robert2\\API\\Models\\Person', 32),
(1, 'Robert2\\API\\Models\\Person', 33),
(1, 'Robert2\\API\\Models\\Person', 34),
(2, 'Robert2\\API\\Models\\Person', 2),
(2, 'Robert2\\API\\Models\\Person', 6);
tags
(1, 'Membre', '2021-11-20 02:27:40', '2021-11-20 02:27:40', NULL),
(2, 'Loueur', '2021-11-20 02:27:40', '2021-11-20 02:27:40', NULL);
Mes default tags sont :
"defaultTags": {
"beneficiary": "Membre",
"technician": "Loueur"
}
Merci d'avance !