URGENT... after upgrade ticket # starts at 1

I have upgraded from 1.2.3. to 1.3.2 and now my ticket number starts at 1000001 but I had already counted up to 1012040 So, my old tickets will be overwritten!!! WHAT can I do? And HOW??? Urgent, please help, because my tickets are being overwritten right now!! Please mail me at: info@mercator.net Thanks, Marc

I'm pretty new to otrs, but it seems like you could run this query: SELECT setval ('"ticket_id_seq"', 12041, true); It should update the sequence so that the next ticket will be 12041 (possible 12042). I got this query from a dump of my otrs postgresql database. Ben On Wed, Nov 24, 2004 at 04:09:18AM +0100, Mercator GmbH wrote:
I have upgraded from 1.2.3. to 1.3.2 and now my ticket number starts at 1000001
but I had already counted up to 1012040
So, my old tickets will be overwritten!!!
WHAT can I do? And HOW???
Urgent, please help, because my tickets are being overwritten right now!!
Please mail me at: info@mercator.net
Thanks,
Marc
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting f?r Ihr OTRS System? => http://www.otrs.de/

On Wed, Nov 24, 2004 at 04:09:18AM +0100, Mercator GmbH wrote:
I have upgraded from 1.2.3. to 1.3.2 and now my ticket number starts at 1000001
but I had already counted up to 1012040
So, my old tickets will be overwritten!!!
WHAT can I do? And HOW???
Urgent, please help, because my tickets are being overwritten right now!!
Did you remember to backup and restore var/* after the upgrade? Their is a file (ticket_counter or similar) in var that contains the count of the last ticket. You need this file to pickup where you left off. Hth, Tyler Hepworth
participants (3)
-
Ben Rasmussen
-
Mercator GmbH
-
Tyler Hepworth