[Trac] ViewTickets->MyTickets bug?

[Emmanuel Blot]

Hi,

I do not know if the bug is related, but I think so.

Here is one of my custom report, as a SQL request:

{{{
SELECT p.value AS __color__,
       t.milestone AS __group__,
       id AS ticket, summary, component, status,
       resolution,version, severity, priority, owner,
       changetime AS modified,
       time AS _time,reporter AS _reporter
       FROM ticket t,enum p
       WHERE p.name=t.priority AND p.type='priority' AND t.status='closed' 
       AND component='Camera'
       AND date(modified, 'unixepoch') BETWEEN '2005-07-01' AND '2005-07-31'
       ORDER BY (milestone IS NULL), milestone DESC
}}}

it works fine.

Now, if I replace the component= value with a component which has no
matching ticket in the DB (in this case, no ticket closed for this
component in the specified time frame), I get the same error.

This is fully reproducible.

Even if the SQL is not available (I'm not sure about it), I think
there is some room for enhancement over here: once the report has been
created, it is stored in the DB. There seems to be no way to EDIT (or
even DELETE) the report without executing it first: the
Edit/Copy/Delete Report buttons only appear on the report result page.

As the SQL request badly fails, there no way (other than to dig into
the SQLite internal DB) to remove or fix up the SQL request.

I guess I should log a RFE for this point, at least, shouldn't I ?

Cheers,
Manu


On 8/3/05, Matthew Good <matt at matt-good.net> wrote:
> On Wed, 2005-08-03 at 18:00 +0200, Christian Parpart wrote:
> > Hi,
> >
> > when I click this way, I see the expected results;
> >
> > But when another guy (having an account on this trac, btw) does so, it comes
> > to an error like loosely quoted below:
> >
> > -----------------------------------------------------
> > Oops... Trac detected an internal error:
> >
> > iteration over non-sequence
> 
> Which database and which wrapper library is installed for it (check for
> pysqlite vs. pysqlite2)?  It's trying to loop over the list of column
> names from the result, which the DB wrapper looks like it returned
> "None" instead of the list.
> 
> _______________________________________________
> Trac mailing list
> Trac at lists.edgewall.com
> http://lists.edgewall.com/mailman/listinfo/trac
> 


-- 
Manu