[SOLVED] Reset ticket id

[zip]

Hello,

if i delete all tickets and then create a new one the id does not start again from 1. It's possible to reset the id somehow?

ticketid.png

[Eggllo]

You could try checking out TicketCounter.log, but you might have to do some extra config in Config.pm...

Check out this article from one of the mailing lists:
http://otrs.otrs.narkive.com/7vaZnHDC/i ... the-config

<OTRS_HOME>/var/log/TicketCounter.log is the last ticket allocated.
Which you need to set 0 for next ticket to be 1

I haven't tested this myself, but I have also seen quite a few people saying you might run into some issues if you try to do this the wrong way so I would make sure to test this thoroughly beforehand...

[jojo]

as the ticket ID is only used intern there is no need to reset it. The Ticket# is the one used to the outside world...

[zip]

You could try checking out TicketCounter.log, but you might have to do some extra config in Config.pm...

Check out this article from one of the mailing lists:
http://otrs.otrs.narkive.com/7vaZnHDC/i ... the-config

<OTRS_HOME>/var/log/TicketCounter.log is the last ticket allocated.
Which you need to set 0 for next ticket to be 1

I haven't tested this myself, but I have also seen quite a few people saying you might run into some issues if you try to do this the wrong way so I would make sure to test this thoroughly beforehand...

thanks but this affects the ticket number and not the ticket id

[Eggllo]

Why would you want to change the ID? I'd have to agree with jojo here.

[crythias]

DISCLAIMER: The following is not recommended, may not work, depends on multiple variables, but in general:
Your data is your responsibility.
Make and verify backups.

http://stackoverflow.com/questions/8923 ... t-in-mysql
Summary:
DO NOT DO THIS
you shouldn't ever need to do it.
If you need to do it, you can either use an ALTER TABLE or recreate the table.

Why not do this? If there are any Articles or other entries that rely on a previously used index *anywhere*, they will now be attached to the reused ticket ID.

If you want to start your numbering of IDs over, it is likely best to build a new database.

[zip]

thanks crythias, it's working fine.

I am migrating tickets and i made some tests and i thougt i had to set the id to 1 before i do so. But now i still get this error if i want to open some of the migrated tickets:

otrs_noperm.png

[jojo]

If you want to migrate you need the Full database and to follow the documentation.

You can not insert ticket directly in the database. You should never write directly to the database

[zip]

ok thanks for your help!