Edgewall Software

Changes between Initial Version and Version 1 of Ticket #11140, comment 8


Ignore:
Timestamp:
Dec 4, 2013, 10:51:26 AM (10 years ago)
Author:
Jun Omae

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #11140, comment 8

    initial v1  
    44}}}
    55{{{
    6 2013-12-04 17:28:52,972 Trac[formatter] DEBUG: Executing Wiki macro TicketQuery by provider <trac.ticket.query.TicketQueryMacro object at 0x8a9086c>
    7 2013-12-04 17:28:53,014 Trac[util] DEBUG: SQL: u'SELECT COUNT(*) FROM (SELECT t.status AS status,t.summary AS summary,t.id AS id,t.summary AS summary,t.component AS component,t.status AS status,t.version AS version,t.milestone AS milestone,t.priority AS priority,t.time AS time,t.reporter AS reporter,t.changetime AS changetime,priority.value AS priority_value,t."col1" AS "col1"\nFROM (\n  SELECT t.status AS status,t.summary AS summary,t.id AS id,t.summary AS summary,t.component AS component,t.status AS status,t.version AS version,t.milestone AS milestone,t.priority AS priority,t.time AS time,t.reporter AS reporter,t.changetime AS changetime,\n  (SELECT c.value FROM ticket_custom c WHERE c.ticket=t.id AND c.name=\'col1\') AS "col1"\n  FROM ticket AS t) AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type=\'priority\' AND priority.name=priority)\nWHERE ((CAST(t.time AS bigint)>=%s))\nORDER BY COALESCE(t.time,0)=0,t.time,t.id) AS foo'
    8 2013-12-04 17:28:53,014 Trac[util] DEBUG: args: [1386082800000000L]
    9 2013-12-04 17:28:53,016 Trac[util] DEBUG: execute exception: ProgrammingError('column reference "status" is ambiguous\n',)
    10 2013-12-04 17:28:53,019 Trac[formatter] ERROR: Macro TicketQuery(order=time,time=today..,col=id|summary|component|status|version|milestone|priority|time|reporter|col1) failed:
     62013-12-04 18:50:49,140 Trac[util] DEBUG: SQL: u'SELECT COUNT(*) FROM (SELECT t.status AS status,t.summary AS summary,t.id AS id,t.status AS status,t.priority AS priority,t.time AS time,t.changetime AS changetime,priority.value AS priority_value,t."col1" AS "col1"\nFROM (\n  SELECT t.status AS status,t.summary AS summary,t.id AS id,t.status AS status,t.priority AS priority,t.time AS time,t.changetime AS changetime,\n  (SELECT c.value FROM ticket_custom c WHERE c.ticket=t.id AND c.name=\'col1\') AS "col1"\n  FROM ticket AS t) AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type=\'priority\' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id) AS foo'
     72013-12-04 18:50:49,143 Trac[util] DEBUG: execute exception: <psycopg2.ProgrammingError instance at 0xa4ce38c>
     82013-12-04 18:50:49,148 Trac[formatter] ERROR: Macro TicketQuery(col=id|status|col1) failed:
    119Traceback (most recent call last):
    1210  File "/home/jun66j5/src/trac/edgewall/git/trac/wiki/formatter.py", line 720, in _macro_formatter
    … …  
    2220  File "/home/jun66j5/src/trac/edgewall/git/trac/ticket/query.py", line 283, in _count
    2321    cursor.execute(count_sql, args)
    24   File "/home/jun66j5/src/trac/edgewall/git/trac/db/util.py", line 54, in execute
    25     r = self.cursor.execute(sql_escape_percent(sql), args)
     22  File "/home/jun66j5/src/trac/edgewall/git/trac/db/util.py", line 56, in execute
     23    r = self.cursor.execute(sql)
    2624ProgrammingError: column reference "status" is ambiguous
    2725}}}