Forum GLPI-Project

SomeDude

Member

Registered: 2023-11-22

Posts: 62

Reset Ticket ID´s

Hello,

can I somehow reset Ticket ids via the console?

Thanks

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,809

Website

Re: Reset Ticket ID´s

No. Once a ticket ID is consumed, you cannot start over. Ticket IDs are assigned by the database itself through an AUTO INCREMENT key. Even if you forcibly reset the increment back to 1, you risk overwriting IDs already assigned if tickets still exist or using an ID that is referenced by some orphaned data in GLPI itself or plugins that cause items that were related to old tickets suddenly being attached to new tickets.

---

GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.

mecmav

Member

From: Brasil

Registered: 2019-03-22

Posts: 330

Re: Reset Ticket ID´s

you can reset ticket's ID, but it's not an easy task.
you need to do a truncate in many tables in your database
if you have so many ID's registered in your database, need to review in tables that have these ID's to clean all the tables using the truncate in each of the tables.

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,809

Website

Re: Reset Ticket ID´s

It is really not worth all the potential issues if you miss references in the database, just to reset the ticket ID counter.

---

GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.