Hi,
the predefined reports have been changed in eg. Rev 4357, 4358.
The new db_defaults.py is published in our
../lib/python/site-packages/trac. But I see the old reports (without
the join). Using trac-admin <PATH_TO_TRACENV> update, returns
everything is up to date. This seems to be because the value of
db_version has not changed.
So my first question would be: How can I import the newer versions into
my environment?
As a workaround, I edited the reports, so that they had the same
contents, as the newer versions.
Not nice but works ... for most reports. The last three standard
reports still do not work. We use MySQL as a database backend.
It seems that the replacement of the USER variable doesn't work.
The LogFile shows:
2006-12-13 14:11:10,705 Trac[report] DEBUG: Executing report with SQL
"SELECT p.value AS __color__,
t.milestone AS __group__,
(CASE status
WHEN 'closed' THEN 'color: #777; background: #ddd; border-color:
#ccc;'
ELSE
(CASE owner WHEN 'concat(', %s, ')' THEN 'font-weight: bold'
END)
END) AS __style__,
id AS ticket, summary, component, status,
resolution,version, t.type AS type, priority, owner,
changetime AS modified,
time AS _time,reporter AS _reporter
FROM ticket t
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'),
(CASE status WHEN 'closed' THEN modified ELSE (-1)*p.value END)
DESC
" ([u'maxbernhardt'])
After that no error is generated, but the resultset seems to be empty.
Ah, I forgot to mention, we don't use the priority field, so there are
no priorities in the database. But seeing that the other reports work,
I don't think that this is the problem.
CU
Max
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Trac Development" 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-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
