Forum GLPI-Project

repentandliveholy

Member

Registered: 2023-09-18

Posts: 49

Ticket ID crashed (reseted) after plugin installation

Hello!

I installed a plugin called BEHAVIOURS

Here is an issue:

There is an option in plugin to change a form om ticket ID - to YYMMDD00001 (like this). I tried it, but didn't liked because it reseted ID's (started from 1) and IDs became very long. I want to return it but I can't even if I change this option to --- and uninstall a plugin IDs comes from begining on form of YYMMDD0001... How can I return previous default glpi IDs?

Thanks

Rafumel1774

Member

Registered: 2019-05-11

Posts: 131

Re: Ticket ID crashed (reseted) after plugin installation

Duplicate: https://forum.glpi-project.org/viewtopic.php?id=288357

repentandliveholy

Member

Registered: 2023-09-18

Posts: 49

Re: Ticket ID crashed (reseted) after plugin installation

Thanks!!

So, the algorithm of dealing this issue is:

1. Change order IDs to normal ones in order
2. Find the max ID of the application yourself or SELECT MAX(id) FROM glpi_tickets;
3. ALTER TABLE glpi_tickets;
4. AUTO_INCREMENT = number above + 1;