defect #57 (closed: DONE)
roadmap page throws error after install
Test Complete Size: | 1 | Test Complete Date: | 01/19/2009 |
---|---|---|---|
Documentation Complete Size: | 1 | Documentation Complete Date: | 01/19/2009 |
Acceptance Complete Size: | 0 | Acceptance Complete Date: | |
Reported by: | achmed | Owned by: | ja11sop |
Milestone: | Clean up of Plugin with Patch | Component: | agiletrac patch to core |
Version: | Keywords: | ||
Cc: | achmed@… | Blocked By: | |
Blocking: | Patch SVN Revision: | ||
Patch Trac Version: | |||
In Iterations: | 15 17 |
Description
Roadmap page produces this error after patch and install:
Trac detected an internal error: ProgrammingError?: non-integer constant in ORDER BY
- File "/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/web/main.py", line 423, in _dispatch_request
Code fragment:
- try:
- if not env and env_error:
- raise HTTPInternalError(env_error)
- try:
- dispatcher = RequestDispatcher?(env)
- dispatcher.dispatch(req)
- except RequestDone?:
- pass
- resp = req._response or []
- 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 0xb74145cc> e <psycopg2.ProgrammingError? instance at 0xb6dcb82c> env <trac.env.Environment object at 0xb7cc5fac> env_error None exc_info (<class psycopg2.ProgrammingError? at 0xb75a683c>, ... filename '/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/web/main.py' frames [{'function': '_dispatch_request', 'lines_before': [u' try:', u' ... has_admin True line u' dispatcher.dispatch(req)' lineno 422 message u'ProgrammingError?: non-integer constant in ORDER BY\n' req <Request "GET u'/roadmap'"> resp [] tb <traceback object at 0xb6dd016c> tb_hide None traceback 'Traceback (most recent call last):\n File ...
- File "/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/web/main.py", line 197, in dispatch
Code fragment:
- req.args.get('FORM_TOKEN') != req.form_token:
- raise HTTPBadRequest('Missing or invalid form token. '
- 'Do you have cookies enabled?')
- # Process the request and render the template
- resp = chosen_handler.process_request(req)
- if resp:
- if len(resp) == 2: # Clearsilver
- chrome.populate_hdf(req)
- template, content_type = \
- self._post_process_request(req, *resp)
- Local variables: Name Value chosen_handler <trac.ticket.roadmap.RoadmapModule? object at 0xb74149ec> chrome <trac.web.chrome.Chrome object at 0xb75aba6c> err (<class psycopg2.ProgrammingError? at 0xb75a683c>, ... handler <trac.ticket.roadmap.RoadmapModule? object at 0xb74149ec> req <Request "GET u'/roadmap'"> self <trac.web.main.RequestDispatcher? object at 0xb74145cc>
- File "/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/ticket/roadmap.py", line 756, in process_request
Code fragment:
- # range
- expected_completion_dates = []
- for milestone in milestones:
- tickets = get_tickets_for_milestone(self.env, db, milestone.name,
- 'owner')
- tickets = TicketSystem?(self.env).apply_ticket_permissions(req, tickets)
- milestone_sizing_stats = TicketSystem?(self.env).get_sizing_statistics_for_milestones([milestone.name])
- stat = get_ticket_stats(self.stats_provider, tickets, milestone_sizing_stats, None)
- stats.append(milestone_stats_data(req, stat, milestone.name))
- Local variables: Name Value db <trac.db.pool.PooledConnection? object at 0xb7414e2c> expected_completion_dates [] m <trac.ticket.model.Milestone object at 0xb6dcb8cc> milestone <trac.ticket.model.Milestone object at 0xb6dcb7ec> milestone_realm <Resource 'milestone'> milestones [<trac.ticket.model.Milestone object at 0xb6dcb7ec>, ... now datetime.datetime(2008, 10, 15, 4, 54, 28, 205430, tzinfo=<FixedOffset? ... points_per_period {'points': 0, 'period': datetime.timedelta(0)} queries [] req <Request "GET u'/roadmap'"> rolling_date datetime.datetime(2008, 10, 15, 4, 54, 28, 205430, tzinfo=<FixedOffset? ... self <trac.ticket.roadmap.RoadmapModule? object at 0xb74149ec> showall False stats [] ticket_infos []
- File "/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/ticket/roadmap.py", line 309, in get_tickets_for_milestone
Code fragment:
- def get_tickets_for_milestone(env, db, milestone, field='component'):
- from trac.ticket import Ticket
- tickets = []
- cursor = db.cursor()
- cursor.execute("SELECT id FROM ticket WHERE milestone=%s "
- "ORDER BY %s", (milestone,field))
- ticket_ids = [str(row[0]) for row in cursor]
- for ticket_id in ticket_ids:
- ticket = Ticket(env, ticket_id, db)
- if ticket.exists:
- tickets.append(ticket)
- Local variables: Name Value Ticket <class 'trac.ticket.model.Ticket'> cursor <trac.db.util.IterableCursor? object at 0xb77ae50c> db <trac.db.pool.PooledConnection? object at 0xb7414e2c> env <trac.env.Environment object at 0xb7cc5fac> field 'owner' milestone u'milestone1' tickets []
- File "/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/db/util.py", line 50, in execute
Code fragment:
- def execute(self, sql, args=None):
- # -- In case of SQL errors, uncomment the following 'print' statements
- # print 'execute', repr(sql)
- if args:
- # print repr(args)
- return self.cursor.execute(sql_escape_percent(sql), args)
- return self.cursor.execute(sql)
- def executemany(self, sql, args=None):
- # print 'executemany', repr(sql)
- if args:
- Local variables: Name Value args (u'milestone1', 'owner') self <trac.db.util.IterableCursor? object at 0xb77ae50c> sql 'SELECT id FROM ticket WHERE milestone=%s ORDER BY %s'
- File "/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/db/util.py", line 50, in execute
Code fragment:
- def execute(self, sql, args=None):
- # -- In case of SQL errors, uncomment the following 'print' statements
- # print 'execute', repr(sql)
- if args:
- # print repr(args)
- return self.cursor.execute(sql_escape_percent(sql), args)
- return self.cursor.execute(sql)
- def executemany(self, sql, args=None):
- # print 'executemany', repr(sql)
- if args:
- Local variables: Name Value args (u'milestone1', 'owner') self <trac.db.util.IterableCursor? object at 0xb77ae05c> sql 'SELECT id FROM ticket WHERE milestone=%s ORDER BY %s'
File "/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/web/main.py", line 423, in _dispatch_request
dispatcher.dispatch(req)
File "/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/web/main.py", line 197, in dispatch
resp = chosen_handler.process_request(req)
File "/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/ticket/roadmap.py", line 756, in process_request
'owner')
File "/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/ticket/roadmap.py", line 309, in get_tickets_for_milestone
"ORDER BY %s", (milestone,field))
File "/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/db/util.py", line 50, in execute
return self.cursor.execute(sql_escape_percent(sql), args)
File "/usr/lib/python2.4/site-packages/Trac-0.11.1-py2.4.egg/trac/db/util.py", line 50, in execute
return self.cursor.execute(sql_escape_percent(sql), args)
Change History
Have a look at the list of modified files related to this ticket.