[Trac] Re: Trac Ticket Numbers
Yeah, that good to know. It would have made it more complex if you deleted id #50 and it went back to #1. Then, we'd have to hunt down what was different for the #50 entry that made it unique from the newly created #51. I'm sure Oracle and Sybase do that sort of stuff to prevent masquerading. On Apr 14, 3:04 pm, Ryan J Ollos wrote: > David S-6 wrote: > > > So, when you said you went back and "deleted" the first ticket ID 50, you > > mean you used sqlite manager via firefox? > > Yeah, I deleted ticket ID 50 with SQLite Manager in Firefox. The only reason > I tried that is thinking you might want to have ID 50 be a dummy ticket, and > remove it from the db after your developers start creating tickets. > > It seems like the behavior in Trac is to look at the last row in the table > and +1 to get the next ticket ID. > > -- > View this message in > context:http://old.nabble.com/Trac-Ticket-Numbers-tp31382846p31399880.html > Sent from the Trac Users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
Re: [Trac] Trac Ticket Numbers
David S-6 wrote: > > So, when you said you went back and "deleted" the first ticket ID 50, you > mean you used sqlite manager via firefox? > Yeah, I deleted ticket ID 50 with SQLite Manager in Firefox. The only reason I tried that is thinking you might want to have ID 50 be a dummy ticket, and remove it from the db after your developers start creating tickets. It seems like the behavior in Trac is to look at the last row in the table and +1 to get the next ticket ID. -- View this message in context: http://old.nabble.com/Trac-Ticket-Numbers-tp31382846p31399880.html Sent from the Trac Users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
Re: [Trac] Trac Ticket Numbers
So, when you said you went back and "deleted" the first ticket ID 50, you mean you used sqlite manager via firefox? Nevertheless, this is good info to know. On Wed, Apr 13, 2011 at 8:22 PM, Ryan J Ollos wrote: > > > > David S-6 wrote: > > > > Thanks. I'll try that and post the conclusion here. > > > > I got curious so I tried it out on a new Trac installation. I created > ticket > 1 through the Trac web interface, then went into the db and duplicated that > row with SQLite Manager, changing only the id of the entry to 50. I went > back to the Trac web interface and created a new ticket, which became #51. > I then went back and deleted the ticket with id 50, and create a new ticket > again through the Trac web interface and it became #52. > > -- > View this message in context: > http://old.nabble.com/Trac-Ticket-Numbers-tp31382846p31392949.html > Sent from the Trac Users mailing list archive at Nabble.com. > > -- > You received this message because you are subscribed to the Google Groups > "Trac Users" group. > To post to this group, send email to trac-users@googlegroups.com. > To unsubscribe from this group, send email to > trac-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/trac-users?hl=en. > > -- == David Salinas, PH: (301) 575-2956, Fax: (240) 568-0545 -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
Re: [Trac] Trac Ticket Numbers
David S-6 wrote: > > Thanks. I'll try that and post the conclusion here. > I got curious so I tried it out on a new Trac installation. I created ticket 1 through the Trac web interface, then went into the db and duplicated that row with SQLite Manager, changing only the id of the entry to 50. I went back to the Trac web interface and created a new ticket, which became #51. I then went back and deleted the ticket with id 50, and create a new ticket again through the Trac web interface and it became #52. -- View this message in context: http://old.nabble.com/Trac-Ticket-Numbers-tp31382846p31392949.html Sent from the Trac Users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
[Trac] Re: Trac Ticket Numbers
Thanks. I'll try that and post the conclusion here. On Apr 13, 5:57 am, Ryan J Ollos wrote: > David S-6 wrote: > > > Once I create a new Trac project and get my trac.ini and db settings > > all set. Is there a away for me to edit a config file so that the > > starting "New Ticket" starts with say, #5000 and not #1 before I hand > > it off to the team to start working? > > I don't think this can be done in trac.ini, but you can probably edit the > database directly. This is very simple to do if you are using SQLite, using > SQLite Manager in Firefox. > > I wonder if you could just create an entry with id 4999 in the table, and > the next ticket created might be 5000. > > http://trac.edgewall.org/wiki/TracDev/DatabaseSchema > > -- > View this message in > context:http://old.nabble.com/Trac-Ticket-Numbers-tp31382846p31386399.html > Sent from the Trac Users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
Re: [Trac] Trac Ticket Numbers
David S-6 wrote: > > Once I create a new Trac project and get my trac.ini and db settings > all set. Is there a away for me to edit a config file so that the > starting "New Ticket" starts with say, #5000 and not #1 before I hand > it off to the team to start working? > I don't think this can be done in trac.ini, but you can probably edit the database directly. This is very simple to do if you are using SQLite, using SQLite Manager in Firefox. I wonder if you could just create an entry with id 4999 in the table, and the next ticket created might be 5000. http://trac.edgewall.org/wiki/TracDev/DatabaseSchema -- View this message in context: http://old.nabble.com/Trac-Ticket-Numbers-tp31382846p31386399.html Sent from the Trac Users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
[Trac] Trac Ticket Numbers
Once I create a new Trac project and get my trac.ini and db settings all set. Is there a away for me to edit a config file so that the starting "New Ticket" starts with say, #5000 and not #1 before I hand it off to the team to start working? -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
Re: [Trac] ticket numbers
On 30/07/10 20:31, Noah Kantrowitz wrote:
> Ticket numbers are "allocated" by a SQL auto_increment field.
[...]
The trac database is not changed from the other master mysql, so I can
apply this patch without problems.
Thanks :D
Index: trac/db/mysql_backend.py
===
--- trac/db/mysql_backend.py(revision 9966)
+++ trac/db/mysql_backend.py(working copy)
@@ -93,6 +93,9 @@
self.env.systeminfo.extend([('MySQL', mysql_info),
('MySQLdb', self._version)])
self.required = True
+c = cnx.cursor()
+c.execute("SET @@auto_increment_increment = 1;")
+cnx.commit()
return cnx
def init_db(self, path, log=None, user=None, password=None, host=None,
--
Renato Covarrubias Romero counter.li.org #399677
listas [at] rnt.clhttp://rnt.cl
https://fedoraproject.org/wiki/User:Rcovarru
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to trac-us...@googlegroups.com.
To unsubscribe from this group, send email to
trac-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en.
Re: [Trac] ticket numbers
On 30/07/10 20:31, Noah Kantrowitz wrote: > Ticket numbers are "allocated" by a SQL auto_increment field. By some old replication schema, the auto_increment_increment is set in 10 in the mysqld. Now I'm looking to set this variable to 1 for this database. Thanks a lot! -- Renato Covarrubias Romero counter.li.org #399677 listas [at] rnt.clhttp://rnt.cl https://fedoraproject.org/wiki/User:Rcovarru -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
RE: [Trac] ticket numbers
Ticket numbers are "allocated" by a SQL auto_increment field. --Noah > -Original Message- > From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] > On Behalf Of Roger Oberholtzer > Sent: Friday, July 30, 2010 4:02 PM > To: trac-users@googlegroups.com > Subject: Re: [Trac] ticket numbers > > On Fri, 2010-07-30 at 14:56 -0400, Renato Covarrubias wrote: > > Hi all! > > > > A few days ago I installed version 0.12 of trac. > > Today I started creating tickets, I saw that the tickets are created > > from 1 with increments of 10. > > > > How I can change this? I see no option anywhere. > > > > I want the tickets have increments of 1. > > You seem to have entered the twilight zone > > -- > Roger Oberholtzer > > -- > You received this message because you are subscribed to the Google > Groups "Trac Users" group. > To post to this group, send email to trac-us...@googlegroups.com. > To unsubscribe from this group, send email to trac- > users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/trac-users?hl=en. -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
Re: [Trac] ticket numbers
On Fri, 2010-07-30 at 14:56 -0400, Renato Covarrubias wrote: > Hi all! > > A few days ago I installed version 0.12 of trac. > Today I started creating tickets, I saw that the tickets are created > from 1 with increments of 10. > > How I can change this? I see no option anywhere. > > I want the tickets have increments of 1. You seem to have entered the twilight zone -- Roger Oberholtzer -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
[Trac] ticket numbers
Hi all! A few days ago I installed version 0.12 of trac. Today I started creating tickets, I saw that the tickets are created from 1 with increments of 10. How I can change this? I see no option anywhere. I want the tickets have increments of 1. Thanks. -- Renato Covarrubias Romero counter.li.org #399677 listas [at] rnt.clhttp://rnt.cl https://fedoraproject.org/wiki/User:Rcovarru -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
[Trac] Ticket numbers in descriptions
I remember I used to be able to enter ticket numbers like #123 into descriptions and it would convert to a link to the ticket, but recently this has stopped working and I have to enter them as [ticket: 123]. Does anyone know what might have caused this and how I could fix it? Thanks in advance! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~--~~~~--~~--~--~---
