Type mismatch between glpi_itils_validationsteps items_id and glpi_tickets id

[tograss]

Code of Conduct

• I agree to follow this project's Code of Conduct

Is there an existing issue for this?

• I have searched the existing issues

Version

10.0.22 / 11.0.4

Bug description

Migrating with a ticket id above the signed int limit leads to the errors in the log, when the mysql default is to use signed primary keys

Relevant log output

[2025-12-05 08:42:11] glpi.WARNING:   *** User Warning: MySQL query warnings:
  SQL: INSERT INTO `glpi_itils_validationsteps` (`itemtype`, `items_id`, `validationsteps_id`, `minimal_required_validation_percent`) VALUES ('Ticket', '2202030027', '1', '0')
  Warnings: 
1264: Out of range value for column 'items_id' at row 1 at DBmysql.php line 420
  Backtrace :
  ./src/DBmysql.php:420                              
  ./src/DBmysql.php:1350                             DBmysql->doQuery()
  ./src/Migration.php:784                            DBmysql->insert()
  ...update_10.0.x_to_11.0.0/validationsteps.php:233 Migration->insertInTable()
  .../update_10.0.x_to_11.0.0/validationsteps.php:51 add_itils_validationstep_to_existings_itils()
  ...stall/migrations/update_10.0.x_to_11.0.0.php:64 require()
  ./src/Update.php:256                               update100xto1100()
  ./src/Glpi/Controller/InstallController.php:123    Update->doUpdates()
  ...ts/AsyncOperationProgressControllerTrait.php:83 Glpi\Controller\InstallController->Glpi\Controller\{closure}()
  ./vendor/symfony/http-kernel/HttpKernel.php:101    Glpi\Controller\InstallController->Glpi\Controller\Traits\{closure}()
  ...ymfony/http-foundation/StreamedResponse.php:106 Symfony\Component\HttpKernel\HttpKernel::Symfony\Component\HttpKernel\{closure}()
  ./vendor/symfony/http-foundation/Response.php:423  Symfony\Component\HttpFoundation\StreamedResponse->sendContent()
  ./src/Glpi/Kernel/Kernel.php:295                   Symfony\Component\HttpFoundation\Response->send()
  ./public/index.php:72                              Glpi\Kernel\Kernel->sendResponse()

[2025-12-05 08:42:11] glpi.ERROR:   *** MySQL query error: Duplicate entry 'Ticket-2147483647-1' for key 'unicity' (1062) in SQL query "INSERT INTO `glpi_itils_validationsteps` (`itemtype`, `items_id`, `validationsteps_id`, `minimal_required_validation_percent`) VALUES ('Ticket', '2202080032', '1', '0')".
  Backtrace :
  ./src/DBmysql.php:392                              
  ./src/DBmysql.php:1350                             DBmysql->doQuery()
  ./src/Migration.php:784                            DBmysql->insert()
  ...update_10.0.x_to_11.0.0/validationsteps.php:233 Migration->insertInTable()
  .../update_10.0.x_to_11.0.0/validationsteps.php:51 add_itils_validationstep_to_existings_itils()
  ...stall/migrations/update_10.0.x_to_11.0.0.php:64 require()
  ./src/Update.php:256                               update100xto1100()
  ./src/Glpi/Controller/InstallController.php:123    Update->doUpdates()
  ...ts/AsyncOperationProgressControllerTrait.php:83 Glpi\Controller\InstallController->Glpi\Controller\{closure}()
  ./vendor/symfony/http-kernel/HttpKernel.php:101    Glpi\Controller\InstallController->Glpi\Controller\Traits\{closure}()
  ...ymfony/http-foundation/StreamedResponse.php:106 Symfony\Component\HttpKernel\HttpKernel::Symfony\Component\HttpKernel\{closure}()
  ./vendor/symfony/http-foundation/Response.php:423  Symfony\Component\HttpFoundation\StreamedResponse->sendContent()
  ./src/Glpi/Kernel/Kernel.php:295                   Symfony\Component\HttpFoundation\Response->send()
  ./public/index.php:72                              Glpi\Kernel\Kernel->sendResponse()

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

No response

Anything else?

No response

[tograss]

Adding public $allow_signed_keys = false; to config_db.php fixes this. Maybe the default can be changed ? Or a note can be added to the migration documentation