Printer model dictionnary rule execution fails - SQL error

[SebSept]

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.18 & main branch

Bug description

Replay the dictionnary rules fails with an sql error.

SQL Error "1062": Duplicate entry '3' for key 'PRIMARY' in query "INSERT INTOglpi_printermodels (name, comment, id, date_creation, date_mod) VALUES ('modified name', '', '3', '2025-02-14 15:23:17', '2025-02-14 15:23:17')"

Relevant log output

Page URL

./front/ruledictionnaryprintermodel.php?replay_rule=replay_rule

Steps To reproduce

1. Create a printer, assign a model 'MyModel'
2. On dictionary page, Create a Printer model rule

• criteria 'Model' / is / "MyModel"
• action 'Model' / assign / 'Fixed Model'

3. On Dictionaries / Printer model page : clic the "Replay the dictionary rule"

Error displayed :
SQL Error "1062": Duplicate entry '4' for key 'PRIMARY' in query "INSERT INTO glpi_printermodels (name, comment, id, date_creation, date_mod) VALUES ('fixedModel', '', '4', '2025-02-14 15:53:50', '2025-02-14 15:53:50')"

Then

• the printer is not associated with any model printermodels_id is 0.
• the model is removed from glpi_printermodels database

Your GLPI setup information

Fresh install, reproduced with glpi 10.0.18 and glpi main branch.

Anything else?

glpi 11 stacktrace

MySQL query error: Duplicate entry '1' for key 'PRIMARY' (1062) in SQL query "INSERT INTO `glpi_printermodels` (`name`, `comment`, `id`, `date_creation`, `date_mod`) VALUES ('mod : great', '', '1', '2025-02-14 13:54:02', '2025-02-14 13:54:02')".
In ./src/DBmysql.php(369)
#0 ./src/DBmysql.php(1311): DBmysql->doQuery('INSERT INTO `gl...')
#1 ./src/CommonDBTM.php(770): DBmysql->insert('glpi_printermod...', Array)
#2 ./src/CommonDBTM.php(1401): CommonDBTM->addToDB()
#3 ./src/CommonDropdown.php(752): CommonDBTM->add(Array)
#4 ./src/CommonDropdown.php(820): CommonDropdown->import(Array)
#5 ./src/Dropdown.php(2707): CommonDropdown->importExternal('mymodel is grea...', -1, Array, '', true)
#6 ./src/RuleDictionnaryDropdownCollection.php(209): Dropdown::importExternal('PrinterModel', 'mymodel is grea...', -1, Array, '')
#7 ./src/RuleDictionnaryDropdownCollection.php(57): RuleDictionnaryDropdownCollection->replayRulesOnExistingDBForModel(0, 1739542742.0)