[rt-users] How to reset ticket # counter
Is there any one who can help me to reset the ticket counter to 0. as i have deleted all test mails from dB so i also want to reset the thicket counter. which table contains information about ticket counter? -- View this message in context: http://old.nabble.com/How-to-reset-ticket---counter-tp27520320p27520320.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] How to reset ticket # counter
Hi, What database are you using? MySQL: truncate table Tickets; truncate table Transactions; truncate table ObjectCustomFieldValues; truncate table Attachments. Other Databeses, I don't know. Please note that truncate is a dangerous command, and literally deletes all information in the tables selected, and resets the cardinality to 0. On Tue, Feb 9, 2010 at 11:01, softouch wrote: > > Is there any one who can help me to reset the ticket counter to 0. as i > have > deleted all test mails from dB so i also want to reset the thicket counter. > which table contains information about ticket counter? > -- > View this message in context: > http://old.nabble.com/How-to-reset-ticket---counter-tp27520320p27520320.html > Sent from the Request Tracker - User mailing list archive at Nabble.com. > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > 2010 RT Training Sessions! > San Francisco, CA, USA - Feb 22 & 23 > Dublin, Ireland - Mar 15 & 16 > Boston, MA, USA - April 5 & 6 > Washington DC, USA - Oct 25 & 26 > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Bill Graboyes On Assignment At: Toyota Motor Sales, USA, Inc. Consumer Portal Delivery Office: (310) 468-6754 Cell: (714) 515-8312 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] How to reset ticket # counter
>> Is there any one who can help me to reset the ticket counter to 0. as i have >> deleted all test mails from dB so i also want to reset the thicket counter. >> which table contains information about ticket counter? Other than being fussy, there's really no reason to do this. The ticket ID is what it is. Are you going to reset it whenever you get SPAM? Indeed, one could argue that having your tickets not start at one, and having SPAM randomly inserted is a minor gain for "security;" most notably if you have to allow anyone write-access to any ticket as a means of coping with people using their half-dozen addresses interchangeably**. ** MergeUsers presumes you know of the alternate addresses beforehand, or can afford to reject otherwise legitimate messages until you are aware of them. -- Cambridge Energy Alliance: Save money. Save the planet. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com