hangetime, 'unixepoch')) as days
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE ((julianday('now') - julianday(changetime, 'unixepoch')) > 30)
AND status = 'assigned'
ORDER BY changetime, p.value, o
Pierre
I don't know about Trac 0.11, I've only used 0.10.4.
I don't think the owner of the component gets notified in 0.10.4, only the
updater, reporter and owner of the ticket or ticket change, and then only if
the corresponding entries in trac.ini are set to true.
I think the owner of a new t
Pierre
There is a bug in Trac 0.10.4 that prevents notification of a new ticket.
See ticket #3654.
The second patch mentioned in the ticklet cured the problem for me.
Cheers
Steve McCusker
> Date: Thurs, Feb 14 2008 4:21 am
> From: "[EMAIL PROTECTED]"
>
>
>
and it
looks OK.
Hope this is of some help.
Steve McCusker
PS I did send these to you direct earlier but maybe they didn't get through.
generate_user_change_digest.py
--
# Generate a new Apache digest file with old users names replaced by new
ones
# and new
these if you like BUT all of these scripts are
untested as I haven't got to the point when I want to make the changes. So
you might prefer not to use the scripts or to wait until I have tested them,
probably in a week or two.
Cheers
Steve McCusker
PS I am using Trac 0.10.4
No virus found in
Hi Andy
Just using trac-admin upgrade should be enough.
Before you do it make sure you have the plugin enabled in trac.ini.
After you have enabled the plugin in trac.ini you need to restart Apache or
tracd or whatever web server you are using. Then trac-admin upgrade should
work.
If the databa
Hi Andy
Yes the database should have those two tables, and four custom fields should
have been added to tickets. These should have been added to the
[ticket-custom] section of the trac.ini file by the plugin (or the database
upgrade? I am not sure). Once tickets have used them, rows with these fi
Andy
Are you running the report from the View tickets page or from the Management
page?
They only work from the management page.
Steve McCusker
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.488 / Virus Database: 269.13.28/1021 - Release Date: 21/09/2007
14:02
We have been using this, on Trac 0.10.4 running on Windows 2000 Pro.
Title:
Active, Visible Tickets Unchanged for More Than 30 Days, by Time Unchanged
Description:
List tickets that haven't been changed in the last 30 days, sorted by length
of time unchanged.
Only tickets that you have premiss
Jen
Maybe the problem with your SQL is that you have used as a column name
(c.value AS "Workflow State")
and as a text string (AND c.name = "Workflow State").
Maybe it will work if you change the column name to something slightly
different.
But I am no SQL expert.
Cheers
10 matches
Mail list logo
