Hi Christian, I only created the ticket http://trac.edgewall.org/ticket/8312. Did any body update trac to new version?
Thanks, Vanaja. On Sun, May 24, 2009 at 1:43 PM, Christian Boos <[email protected]> wrote: > > vanaja Jagini wrote: > > Hi All, > > > > All my ticket reports were working fine in trac .11 version. I > > updated to 0.11.5stable-r8210 version, Now i see issues for reports > > which are grouped by milestone. Please can you help me to solve this > > issue. Here is the issue: > > > > Trac detected an internal error: > > > > OperationalError: ambiguous column name: priority > > > > > > Python Traceback > > > > Most recent call last: > > > > * File > > > "/usr/lib/python2.5/site-packages/Trac-0.11.5stable_r8210-py2.5.egg/trac/web/main.py", > > line *444*, in _dispatch_request > > < > http://75.101.188.24/trac/repos/query?status=testing&group=milestone&order=priority&report=22&col=id&col=summary&col=type&col=priority&col=component&owner=%21ilya.gelle%40ahamobile.com#frame0 > > > > > > > > > > Code fragment: > > > > 439. | try:| > > > > 440. | if not env and env_error:| > > > > 441. | raise HTTPInternalError(env_error)| > > > > 442. | try:| > > > > 443. | dispatcher = RequestDispatcher(env)| > > > > 444. | dispatcher.dispatch(req)| > > > > 445. | except RequestDone:| > > > > 446. | pass| > > > > 447. | resp = req._response or []| > > > > 448. | | > > > > 449. | except HTTPException, e:| > > > > > > Local variables: > > > > Name > > > > Value > > > > after > > > > |[u' except RequestDone:', u' pass', u' resp = ...| > > > > before > > > > |[u' try:', u' if not env and env_error:', u' raise ...| > > > > dispatcher > > > > |<trac.web.main.RequestDispatcher object at 0x834077ec>| > > > > e > > > > |OperationalError('ambiguous column name: priority',)| > > > > env > > > > |<trac.env.Environment object at 0x82d327ec>| > > > > env_error > > > > |None| > > > > exc_info > > > > |(<class 'pysqlite2.dbapi2.OperationalError'>, > > OperationalError('ambiguous ...| > > > > filename > > > > > |'/usr/lib/python2.5/site-packages/Trac-0.11.5stable_r8210-py2.5.egg/trac/we > > ...| > > > > frames > > > > |[{'function': '_dispatch_request', 'lines_before': [u' > try:', > > u' ...| > > > > has_admin > > > > |True| > > > > line > > > > |u' dispatcher.dispatch(req)'| > > > > lineno > > > > |443| > > > > message > > > > |u'OperationalError: ambiguous column name: priority'| > > > > req > > > > |<Request "GET u'/query'">| > > > > resp > > > > |[]| > > > > tb > > > > |<traceback object at 0x83bd748c>| > > > > tb_hide > > > > |None| > > > > traceback > > > > |u'Traceback (most recent call last):\n File ...| > > > > * File > > > "/usr/lib/python2.5/site-packages/Trac-0.11.5stable_r8210-py2.5.egg/trac/web/main.py", > > line *205*, in dispatch > > < > http://75.101.188.24/trac/repos/query?status=testing&group=milestone&order=priority&report=22&col=id&col=summary&col=type&col=priority&col=component&owner=%21ilya.gelle%40ahamobile.com#frame1 > > > > > > > > > > Code fragment: > > > > 200. | req.args.get('__FORM_TOKEN') != req.form_token:| > > > > 201. | raise HTTPBadRequest('Missing or invalid form token. '| > > > > 202. | 'Do you have cookies enabled?')| > > > > 203. | | > > > > 204. | # Process the request and render the template| > > > > 205. | resp = chosen_handler.process_request(req)| > > > > 206. | if resp:| > > > > 207. | if len(resp) == 2: # Clearsilver| > > > > 208. | chrome.populate_hdf(req)| > > > > 209. | template, content_type = \| > > > > 210. | self._post_process_request(req, *resp)| > > > > > > Local variables: > > > > Name > > > > Value > > > > chosen_handler > > > > |<trac.ticket.query.QueryModule object at 0x834078cc>| > > > > chrome > > > > |<trac.web.chrome.Chrome object at 0x833722ec>| > > > > err > > > > |(<class 'pysqlite2.dbapi2.OperationalError'>, > > OperationalError('ambiguous ...| > > > > handler > > > > |<trac.ticket.query.QueryModule object at 0x834078cc>| > > > > req > > > > |<Request "GET u'/query'">| > > > > self > > > > |<trac.web.main.RequestDispatcher object at 0x834077ec>| > > > > * File > > > "/usr/lib/python2.5/site-packages/Trac-0.11.5stable_r8210-py2.5.egg/trac/ticket/query.py", > > line *834*, in process_request > > < > http://75.101.188.24/trac/repos/query?status=testing&group=milestone&order=priority&report=22&col=id&col=summary&col=type&col=priority&col=component&owner=%21ilya.gelle%40ahamobile.com#frame2 > > > > > > > > > > Code fragment: > > > > 829. | | > > > > 830. | if format:| > > > > 831. | Mimeview(self.env).send_converted(req, > > 'trac.ticket.Query', query,| > > > > 832. | format, filename=None)| > > > > 833. | | > > > > 834. | return self.display_html(req, query)| > > > > 835. | | > > > > 836. | # Internal methods| > > > > 837. | | > > > > 838. | def _get_constraints(self, req):| > > > > 839. | constraints = {}| > > > > > > Local variables: > > > > Name > > > > Value > > > > args > > > > |{'status': u'testing', 'group': u'milestone', 'col': > [u'id', > > u'summary', ...| > > > > cols > > > > |[u'id', u'summary', u'type', u'priority', u'component']| > > > > constraints > > > > |{'status': [u'testing'], 'owner': [u'! > [email protected] > > <mailto:[email protected]>']}| > > > > conversion > > > > |('tab', 'Tab-delimited Text', 'tsv', 'trac.ticket.Query', > ...| > > > > format > > > > |None| > > > > max > > > > |None| > > > > query > > > > |<trac.ticket.query.Query object at 0x83787c4c>| > > > > req > > > > |<Request "GET u'/query'">| > > > > rows > > > > |[]| > > > > self > > > > |<trac.ticket.query.QueryModule object at 0x834078cc>| > > > > * File > > > "/usr/lib/python2.5/site-packages/Trac-0.11.5stable_r8210-py2.5.egg/trac/ticket/query.py", > > line *887*, in display_html > > < > http://75.101.188.24/trac/repos/query?status=testing&group=milestone&order=priority&report=22&col=id&col=summary&col=type&col=priority&col=component&owner=%21ilya.gelle%40ahamobile.com#frame3 > > > > > > > > > > Code fragment: > > > > 882. | query_time = int(req.session.get('query_time', 0))| > > > > 883. | query_time = datetime.fromtimestamp(query_time, utc)| > > > > 884. | query_constraints = unicode(query.constraints)| > > > > 885. | if query_constraints != > > req.session.get('query_constraints') \| > > > > 886. | or query_time < orig_time - timedelta(hours=1):| > > > > 887. | tickets = query.execute(req, db)| > > > > 888. | # New or outdated query, (re-)initialize session vars| > > > > 889. | req.session['query_constraints'] = query_constraints| > > > > 890. | req.session['query_tickets'] = ' '.join([str(t['id'])| > > > > 891. | for t in tickets])| > > > > 892. | else:| > > > > > > Local variables: > > > > Name > > > > Value > > > > db > > > > |<trac.db.pool.PooledConnection object at 0x83aa2ecc>| > > > > orig_list > > > > |None| > > > > orig_time > > > > |datetime.datetime(2009, 5, 21, 21, 31, 56, 116967, > > tzinfo=<FixedOffset ...| > > > > query > > > > |<trac.ticket.query.Query object at 0x83787c4c>| > > > > query_constraints > > > > |u"{'status': [u'testing'], 'owner': > > [u'[email protected] <mailto:[email protected] > >']}"| > > > > query_time > > > > |datetime.datetime(2009, 5, 21, 21, 24, 8, > tzinfo=<FixedOffset > > "UTC" ...| > > > > req > > > > |<Request "GET u'/query'">| > > > > self > > > > |<trac.ticket.query.QueryModule object at 0x834078cc>| > > > > * File > > > "/usr/lib/python2.5/site-packages/Trac-0.11.5stable_r8210-py2.5.egg/trac/ticket/query.py", > > line *264*, in execute > > < > http://75.101.188.24/trac/repos/query?status=testing&group=milestone&order=priority&report=22&col=id&col=summary&col=type&col=priority&col=component&owner=%21ilya.gelle%40ahamobile.com#frame4 > > > > > > > > > > Code fragment: > > > > 259. | if not db:| > > > > 260. | db = self.env.get_db_cnx()| > > > > 261. | cursor = db.cursor()| > > > > 262. | | > > > > 263. | sql, args = self.get_sql(req, cached_ids)| > > > > 264. | self.num_items = self._count(sql, args, db)| > > > > 265. | | > > > > 266. | if self.num_items <= self.max:| > > > > 267. | self.has_more_pages = False| > > > > 268. | | > > > > 269. | if self.has_more_pages:| > > > > > > Local variables: > > > > Name > > > > Value > > > > args > > > > |[u'testing', > > u'[email protected]<u%[email protected]> > > <mailto:u%[email protected]<u%[email protected]> > >']| > > > > cached_ids > > > > |None| > > > > cursor > > > > |<trac.db.util.IterableCursor object at 0x83ba32fc>| > > > > db > > > > |<trac.db.pool.PooledConnection object at 0x83aa2ecc>| > > > > req > > > > |<Request "GET u'/query'">| > > > > self > > > > |<trac.ticket.query.Query object at 0x83787c4c>| > > > > sql > > > > |u"SELECT t.id <http://t.id> AS id,t.summary AS > summary,t.type > > AS type,t.priority AS ...| > > > > * File > > > "/usr/lib/python2.5/site-packages/Trac-0.11.5stable_r8210-py2.5.egg/trac/ticket/query.py", > > line *249*, in _count > > < > http://75.101.188.24/trac/repos/query?status=testing&group=milestone&order=priority&report=22&col=id&col=summary&col=type&col=priority&col=component&owner=%21ilya.gelle%40ahamobile.com#frame5 > > > > > > > > > > Code fragment: > > > > 244. | # self.env.log.debug("Count results in Query SQL: " + > > count_sql % | > > > > 245. | # tuple([repr(a) for a in args]))| > > > > 246. | | > > > > 247. | cnt = 0| > > > > 248. | try:| > > > > 249. | cursor.execute(count_sql, args);| > > > > 250. | except:| > > > > 251. | db.rollback()| > > > > 252. | raise| > > > > 253. | for cnt, in cursor:| > > > > 254. | break| > > > > > > Local variables: > > > > Name > > > > Value > > > > args > > > > |[u'testing', > > u'[email protected]<u%[email protected]> > > <mailto:u%[email protected]<u%[email protected]> > >']| > > > > cnt > > > > |0| > > > > count_sql > > > > |u"SELECT COUNT(*) FROM (SELECT t.id <http://t.id> AS > > id,t.summary AS summary,t.type AS ...| > > > > cursor > > > > |<trac.db.util.IterableCursor object at 0x83a1014c>| > > > > db > > > > |<trac.db.pool.PooledConnection object at 0x83aa2ecc>| > > > > self > > > > |<trac.ticket.query.Query object at 0x83787c4c>| > > > > sql > > > > |u"SELECT t.id <http://t.id> AS id,t.summary AS > summary,t.type > > AS type,t.priority AS ...| > > > > * File > > > "/usr/lib/python2.5/site-packages/Trac-0.11.5stable_r8210-py2.5.egg/trac/db/util.py", > > line *50*, in execute > > < > http://75.101.188.24/trac/repos/query?status=testing&group=milestone&order=priority&report=22&col=id&col=summary&col=type&col=priority&col=component&owner=%21ilya.gelle%40ahamobile.com#frame6 > > > > > > > > > > Code fragment: > > > > 45. | def execute(self, sql, args=None):| > > > > 46. | # -- In case of SQL errors, uncomment the following > > 'print' statements| > > > > 47. | # print 'execute', repr(sql)| > > > > 48. | if args:| > > > > 49. | # print repr(args)| > > > > 50. | return self.cursor.execute(sql_escape_percent(sql), args)| > > > > 51. | return self.cursor.execute(sql)| > > > > 52. | | > > > > 53. | def executemany(self, sql, args=None):| > > > > 54. | # print 'executemany', repr(sql)| > > > > 55. | if args:| > > > > > > Local variables: > > > > Name > > > > Value > > > > args > > > > |[u'testing', > > u'[email protected]<u%[email protected]> > > <mailto:u%[email protected]<u%[email protected]> > >']| > > > > self > > > > |<trac.db.util.IterableCursor object at 0x83a1014c>| > > > > sql > > > > |u"SELECT COUNT(*) FROM (SELECT t.id <http://t.id> AS > > id,t.summary AS summary,t.type AS ...| > > > > * File > > > "/usr/lib/python2.5/site-packages/Trac-0.11.5stable_r8210-py2.5.egg/trac/db/sqlite_backend.py", > > line *58*, in execute > > < > http://75.101.188.24/trac/repos/query?status=testing&group=milestone&order=priority&report=22&col=id&col=summary&col=type&col=priority&col=component&owner=%21ilya.gelle%40ahamobile.com#frame7 > > > > > > > > > > Code fragment: > > > > 53. | raise| > > > > 54. | def execute(self, sql, args=None):| > > > > 55. | if args:| > > > > 56. | sql = sql % (('?',) * len(args))| > > > > 57. | return self._rollback_on_error(sqlite.Cursor.execute, sql,| > > > > 58. | args or [])| > > > > 59. | def executemany(self, sql, args=None):| > > > > 60. | if args:| > > > > 61. | sql = sql % (('?',) * len(args[0]))| > > > > 62. | return > > self._rollback_on_error(sqlite.Cursor.executemany, sql,| > > > > 63. | args or [])| > > > > > > Local variables: > > > > Name > > > > Value > > > > args > > > > |[u'testing', > > u'[email protected]<u%[email protected]> > > <mailto:u%[email protected]<u%[email protected]> > >']| > > > > self > > > > |<trac.db.sqlite_backend.PyFormatCursor object at > 0x83ac21ec>| > > > > sql > > > > |u"SELECT COUNT(*) FROM (SELECT t.id <http://t.id> AS > > id,t.summary AS summary,t.type AS ...| > > > > * File > > > "/usr/lib/python2.5/site-packages/Trac-0.11.5stable_r8210-py2.5.egg/trac/db/sqlite_backend.py", > > line *50*, in _rollback_on_error > > < > http://75.101.188.24/trac/repos/query?status=testing&group=milestone&order=priority&report=22&col=id&col=summary&col=type&col=priority&col=component&owner=%21ilya.gelle%40ahamobile.com#frame8 > > > > < > http://75.101.188.24/trac/repos/query?status=testing&group=milestone&order=priority&report=22&col=id&col=summary&col=type&col=priority&col=component&owner=%21ilya.gelle%40ahamobile.com#frame8 > > > > > > > > I appreciate your help. > > > > See http://trac.edgewall.org/ticket/8312 > > -- Christian > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
