Reports returns no rows in RSS format

[ipa@…]

Short example:
http://trac.edgewall.org/report/1?format=rss&USER=anonymous

returns no rows at all against:

http://trac.edgewall.org/report/1

which returns lots of rows.

I'm not sure it is expected behaviour or bug, because i.e. Custom query report works ok.

[osimons]

Hmm. Strange. Something must have happened at some stage, because there really isn't anything there. And, of course there should be. The t.e.o site runs on 0.11.5rc1 - we should have a 'version' tag for it, but bumping version to 0.11-stable as it occurs in currently latest code.

The raw RSS body I get back looks like this:

<?xml version="1.0"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>The Trac Project: {1} All Active Tickets</title>
    <link>http://trac.edgewall.org/report/1</link>
    <description>Trac Report - </description>
    <language>en-us</language>
    <image>
      <title>The Trac Project</title>
      <url>http://www.edgewall.org/gfx/trac_logo.png</url>
      <link>http://trac.edgewall.org/report/1</link>
    </image>
    <generator>Trac v0.11.5stable-r8335</generator>
  </channel>
</rss>

Anyone got a clue? A regression following some recent changes?

[rblank]

Even stranger, I cannot reproduce this in my 0.11-stable checkout, using the exact same report as on t.e.o. But then again, I don't have 931 tickets in that report.

[rblank]

The number of tickets doesn't seem to have an influence, though. Even {12}, in my case with 37 matches, doesn't show anything in the RSS feed. I wonder if there's anything in the logs about this...

[anonymous]

For me that problem appears in 0.11.4 build

[rblank]

I really cannot reproduce this, so it might be an InstallationIssue on t.e.o. Do we have a custom report.rss template here?

[rblank]

Replying to anonymous:

For me that problem appears in 0.11.4 build

Mmh, works fine here with 0.11.4 as well. Do you have a site-specific report.rss template? Any errors in your log (crank it up to DEBUG level, if possible)?

[ipa@…]

There are no special templates.
After debug I've got something like that:

2009-07-03 13:57:46,581 Trac[main] DEBUG: Dispatching <Request "GET u'/report/1'">
2009-07-03 13:57:46,581 Trac[chrome] DEBUG: Prepare chrome data for request
2009-07-03 13:57:46,596 Trac[report] DEBUG: Executing report with SQL "

SELECT p.value AS __color__,

   id AS ticket, summary, component, reporter, t.type AS type, 

   owner, status,

   time AS created,

   changetime AS _changetime, description AS _description,

   reporter AS _reporter

  FROM ticket t

  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'

  WHERE status <> 'closed'

  ORDER BY CAST(p.value AS int), milestone, t.type, time

"
2009-07-03 13:57:46,596 Trac[report] DEBUG: Request args: {'id': u'1', 'USER': u'ipa', 'format': u'rss'}
2009-07-03 13:57:46,612 Trac[session] DEBUG: Retrieving session for ID u'ipa'
2009-07-03 13:57:46,658 Trac[tande_filters] DEBUG: self.billing_reports= Set([9, 10, 11, 12, 13, 14, 15, 16, 17])
2009-07-03 13:57:46,674 Trac[ticket_webui] DEBUG: TicketWebUiAddon executing
2009-07-03 13:57:46,674 Trac[ticket_webui] DEBUG: TicketWebUiAddon not the correct template
2009-07-03 13:57:46,753 Trac[main] DEBUG: 626 unreachable objects found.

[cboos]

I can reproduce this and it seems to be a regression in Genshi 0.6dev (t.e.o is using 0.6dev-r999 and I'm using advanced-i18n ​[G1060]).

I have a workaround, which also makes the code cleaner.

[cboos]

Fixed in r8452. The Genshi regression is tracked in ​#G327.

There seem to be no other places where this expression construction is used in the templates.