Roger Oberholtzer wrote:
> On Tue, 2011-02-08 at 11:31 -0500, Chris Nelson wrote:
>
>>> Any idea how I could remove this value from the problem ticket? I am
>>> guessing I need to use some SQL. And here is where my knowledge
>>> ends.
>>
>> The subtickets relation (table) is much like the mastertickets
>> relation. Remove any row where the parent and child are the same ID.
>
> I understand what you have written. But I do not know how to do this.
> In the past I have looked at the basic db and changed some values.
> But I suspect there is more to it in this case.
>
> Is all this in trac.db?
Yes, the table is in trac.db. In the plugin's db_default.py you can
find:
from trac.db import Table, Column
name = 'subtickets'
version = 1
tables = [
Table(name, key=('parent','child'))[
Column('parent', type='int'),
Column('child', type='int'),
],
]
If you open the Trac database (which will depend on various
installation-specific settings), you can do:
DELETE FROM subtickets WHERE parent=child;
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected].
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.
