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: 1. try: 2. if not env and env_error: 3. raise HTTPInternalError(env_error) 4. try: 5. dispatcher = RequestDispatcher(env) 6. dispatcher.dispatch(req) 7. except RequestDone: 8. pass 9. resp = req._response or [] 10. 11. 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: 1. req.args.get('__FORM_TOKEN') != req.form_token: 2. raise HTTPBadRequest('Missing or invalid form token. ' 3. 'Do you have cookies enabled?') 4. 5. # Process the request and render the template 6. resp = chosen_handler.process_request(req) 7. if resp: 8. if len(resp) == 2: # Clearsilver 9. chrome.populate_hdf(req) 10. template, content_type = \ 11. 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: 1. 2. if format: 3. Mimeview(self.env).send_converted(req, 'trac.ticket.Query', query, 4. format, filename=None) 5. 6. return self.display_html(req, query) 7. 8. # Internal methods 9. 10. def _get_constraints(self, req): 11. 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]']} 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: 1. query_time = int(req.session.get('query_time', 0)) 2. query_time = datetime.fromtimestamp(query_time, utc) 3. query_constraints = unicode(query.constraints) 4. if query_constraints != req.session.get('query_constraints') \ 5. or query_time < orig_time - timedelta(hours=1): 6. tickets = query.execute(req, db) 7. # New or outdated query, (re-)initialize session vars 8. req.session['query_constraints'] = query_constraints 9. req.session['query_tickets'] = ' '.join([str(t['id']) 10. for t in tickets]) 11. 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]']}" 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: 1. if not db: 2. db = self.env.get_db_cnx() 3. cursor = db.cursor() 4. 5. sql, args = self.get_sql(req, cached_ids) 6. self.num_items = self._count(sql, args, db) 7. 8. if self.num_items <= self.max: 9. self.has_more_pages = False 10. 11. if self.has_more_pages: Local variables: Name Value args [u'testing', 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 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: 1. # self.env.log.debug("Count results in Query SQL: " + count_sql % 2. # tuple([repr(a) for a in args])) 3. 4. cnt = 0 5. try: 6. cursor.execute(count_sql, args); 7. except: 8. db.rollback() 9. raise 10. for cnt, in cursor: 11. break Local variables: Name Value args [u'testing', u'[email protected] <u%[email protected]>'] cnt 0 count_sql u"SELECT COUNT(*) FROM (SELECT 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 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: 1. def execute(self, sql, args=None): 2. # -- In case of SQL errors, uncomment the following 'print' statements 3. # print 'execute', repr(sql) 4. if args: 5. # print repr(args) 6. return self.cursor.execute(sql_escape_percent(sql), args) 7. return self.cursor.execute(sql) 8. 9. def executemany(self, sql, args=None): 10. # print 'executemany', repr(sql) 11. if args: Local variables: Name Value args [u'testing', u'[email protected] <u%[email protected]>'] self <trac.db.util.IterableCursor object at 0x83a1014c> sql u"SELECT COUNT(*) FROM (SELECT 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: 1. raise 2. def execute(self, sql, args=None): 3. if args: 4. sql = sql % (('?',) * len(args)) 5. return self._rollback_on_error(sqlite.Cursor.execute, sql, 6. args or []) 7. def executemany(self, sql, args=None): 8. if args: 9. sql = sql % (('?',) * len(args[0])) 10. return self._rollback_on_error(sqlite.Cursor.executemany, sql, 11. args or []) Local variables: Name Value args [u'testing', u'[email protected] <u%[email protected]>'] self <trac.db.sqlite_backend.PyFormatCursor object at 0x83ac21ec> sql u"SELECT COUNT(*) FROM (SELECT 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. Thanks, Vanaja --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
