Edgewall Software
Modify

Opened 11 years ago

Closed 11 years ago

Last modified 11 years ago

#9160 closed defect (cantfix)

Error when clicking "Calculate Story Points / Time" in Agilo on the old sprint page

Reported by: anonymous Owned by:
Priority: normal Milestone:
Component: general Version:
Severity: normal Keywords:
Cc: support@… Branch:
Release Notes:
API Changes:
Internal Changes:

Description (last modified by Remy Blank)

UnableToLoadObjectError: An error occurred while getting ticket from the database: invalid input syntax for integer: "in ()"

Python Traceback
Most recent call last:

    * File "/var/ableton/trac/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 450, in _dispatch_request
      Code fragment:
       445. try:
       446. if not env and env_error:
       447. raise HTTPInternalError(env_error)
       448. try:
       449. dispatcher = RequestDispatcher(env)
       450. dispatcher.dispatch(req)
       451. except RequestDone:
       452. pass
       453. resp = req._response or []
       454.  
       455. 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 0xa26aa0c>
      e 	UnableToLoadObjectError(u'An error occurred while getting ticket from the ...
      env 	<trac.env.Environment object at 0x9dfc94c>
      env_error 	None
      exc_info 	(<class 'agilo.core.model.UnableToLoadObjectError'>, ...
      filename 	'/var/ableton/trac/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/w ...
      frames 	[{'function': '_dispatch_request', 'lines_before': [u' try:', u' ...
      has_admin 	True
      line 	u' dispatcher.dispatch(req)'
      lineno 	449
      message 	u'UnableToLoadObjectError: An error occurred while getting ticket from the ...
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      resp 	[]
      tb 	<traceback object at 0xa28b644>
      tb_hide 	None
      traceback 	u'Traceback (most recent call last):\n File ...
    * File "/var/ableton/trac/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 206, in dispatch
      Code fragment:
       201. req.args.get('__FORM_TOKEN') != req.form_token:
       202. raise HTTPBadRequest('Missing or invalid form token. '
       203. 'Do you have cookies enabled?')
       204.  
       205. # Process the request and render the template
       206. resp = chosen_handler.process_request(req)
       207. if resp:
       208. if len(resp) == 2: # Clearsilver
       209. chrome.populate_hdf(req)
       210. template, content_type = \
       211. self._post_process_request(req, *resp)
      Local variables:
      Name	Value
      chosen_handler 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
      chrome 	<trac.web.chrome.Chrome object at 0x9fb9a4c>
      ctype 	'application/x-www-form-urlencoded'
      e 	InternalError('current transaction is aborted, commands ignored until end ...
      err 	(<class 'agilo.core.model.UnableToLoadObjectError'>, ...
      handler 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
      options 	{}
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      self 	<trac.web.main.RequestDispatcher object at 0xa26aa0c>
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/api/view.py", line 155, in process_request
      Code fragment:
       150. basically, than send a Command Request to a Controller. The
       151. response has to be rendered according to the view needs."""
       152. try:
       153. handler = self.get_handler(req)
       154. if handler is not None:
       155. return self._call_filters_and_handler(req, handler)
       156. else:
       157. raise TracError('No handler found for method %s' % req.method)
       158. except ICommand.NotValidError, e:
       159. chrome.add_warning(req, unicode(e))
       160. # not that we update the data, so that the set value are
      Local variables:
      Name	Value
      handler 	<bound method BacklogDetailView.do_post of ...
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      self 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/api/view.py", line 143, in _call_filters_and_handler
      Code fragment:
       138. return True
       139.
       140. def _call_filters_and_handler(self, req, handler):
       141. for filter in self.filters:
       142. filter.pre_process_request(req)
       143. data = handler(req) or {}
       144. for filter in self.filters:
       145. filter.post_process_request(req)
       146. return self.respond(data)
       147.
       148. def process_request(self, req):
      Local variables:
      Name	Value
      filter 	<agilo_pro.backlog_in_place_editing.OldBacklogInPlaceEditingInjector ...
      handler 	<bound method BacklogDetailView.do_post of ...
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      self 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 834, in do_post
      Code fragment:
       829. elif req.args.has_key('remove'):
       830. self._perform_action(req, backlog, 'remove', data)
       831. elif req.args.has_key('delete'):
       832. self._perform_action(req, backlog, 'delete', data)
       833. elif req.args.has_key('calculate'):
       834. self._perform_action(req, backlog, 'calculate', data)
       835. elif req.args.has_key('confirm'):
       836. self._perform_action(req, backlog, 'confirm', data)
       837.
       838. # Send data
       839. self._do_show(req, data, backlog)
      Local variables:
      Name	Value
      backlog 	<agilo.scrum.backlog.model.Backlog object at 0xa7e914c>
      data 	{'closed_tickets': 0, 'my_tickets': 0}
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      self 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 658, in _perform_action
      Code fragment:
       653. def _perform_action(self, req, backlog, action, data):
       654. """Perform the given do_method action, if allowed, or reload with a
       655. warning if not allowed"""
       656. if self.is_allowed_to(req, backlog, action):
       657. do_action = getattr(self, '_do_' + action)
       658. do_action(req, backlog)
       659. # To make it REST we redirect after the save
       660. params = {'name': backlog.name}
       661. if backlog.scope is not None:
       662. params['scope'] = backlog.scope
       663. self.redirect(req, BacklogDetailView, backlog.name, backlog.scope)
      Local variables:
      Name	Value
      action 	'calculate'
      backlog 	<agilo.scrum.backlog.model.Backlog object at 0xa7e914c>
      data 	{'closed_tickets': 0, 'my_tickets': 0}
      do_action 	<bound method BacklogDetailView._do_calculate of ...
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      self 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 485, in _do_calculate
      Code fragment:
       480. def _do_calculate(self, req, backlog):
       481. sprint = BacklogModule(self.env)._get_sprint(req, backlog.scope)
       482. if sprint.team == None:
       483. raise TracError(_('No team selected for this sprint'))
       484. story_ids = self._extract_selected_ticket_ids(req)
       485. stories = self._storylike_tickets_for_ids(story_ids)
       486. if len(stories) == 0:
       487. # TODO: verify this as I submitted a patch... and could be in :-)
       488. # we can't use add_warning here because we do a redirect
       489. # at the end of the request and trac does not provide a
       490. # mechanism to preserve the message for the next page to be
      Local variables:
      Name	Value
      backlog 	<agilo.scrum.backlog.model.Backlog object at 0xa7e914c>
      req 	<Request "POST u'/oldbacklog/Sprint Backlog/2010-03-22 Incredibles'">
      self 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
      sprint 	ValueObject({'end': u'04/01/10 23:00:00', 'description': None, 'exists': ...
      story_ids 	[]
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 410, in _storylike_tickets_for_ids
      Code fragment:
       405.
       406. def _storylike_tickets_for_ids(self, story_ids):
       407. storylike_tickets = []
       408. criteria = {
       409. 'id': 'in (%s)' % ', '.join([str(st_id) for st_id in story_ids])}
       410. for ticket in AgiloTicketModelManager(self.env).select(criteria=criteria):
       411. if ticket.is_readable_field(Key.STORY_POINTS):
       412. storylike_tickets.append(ticket)
       413. return storylike_tickets
       414.
       415. def _display_options(self, req):
      Local variables:
      Name	Value
      criteria 	{'id': 'in ()'}
      self 	<agilo.scrum.backlog.web_ui.BacklogDetailView object at 0x9fa7f2c>
      story_ids 	[]
      storylike_tickets 	[]
    * File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/ticket/model.py", line 1227, in select
      Code fragment:
      1222. tickets.append(self.get(**params))
      1223.
      1224. except Exception, e:
      1225. raise UnableToLoadObjectError(_("An error occurred while " \
      1226. "getting ticket from the " \
      1227. "database: %s" % to_unicode(e)))
      1228. return tickets
      1229.
      1230. def select_tickets_having_properties(self, properties,
      1231. criteria=None, order_by=None,
      1232. limit=None, db=None):
      Local variables:
      Name	Value
      criteria 	{'id': 'in ()'}
      cursor 	<trac.db.util.IterableCursor object at 0x9fb922c>
      db 	<trac.db.pool.PooledConnection object at 0xa768414>
      e 	DataError('invalid input syntax for integer: "in ()"\n',)
      filter 	' WHERE ticket.id=%(id)s'
      handle_ta 	True
      limit 	None
      order_by 	None
      self 	<agilo.ticket.model.AgiloTicketModelManager object at 0xa2719ac>
      sql 	'SELECT DISTINCT id, type FROM ticket LEFT OUTER JOIN ticket_custom ON ...
      tickets 	[]
      values 	{'id': 'in ()'}

File "/var/ableton/trac/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 450, in _dispatch_request
  dispatcher.dispatch(req)
File "/var/ableton/trac/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 206, in dispatch
  resp = chosen_handler.process_request(req)
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/api/view.py", line 155, in process_request
  return self._call_filters_and_handler(req, handler)
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/api/view.py", line 143, in _call_filters_and_handler
  data = handler(req) or {}
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 834, in do_post
  self._perform_action(req, backlog, 'calculate', data)
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 658, in _perform_action
  do_action(req, backlog)
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 485, in _do_calculate
  stories = self._storylike_tickets_for_ids(story_ids)
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/scrum/backlog/web_ui.py", line 410, in _storylike_tickets_for_ids
  for ticket in AgiloTicketModelManager(self.env).select(criteria=criteria):
File "/var/ableton/trac/lib/python2.5/site-packages/binary_agilo-1.2.1_PRO-py2.5.egg/agilo/ticket/model.py", line 1227, in select
  "database: %s" % to_unicode(e)))

Attachments (0)

Change History (2)

comment:1 by Remy Blank, 11 years ago

Cc: support@… added
Description: modified (diff)
Resolution: cantfix
Status: newclosed

comment:2 by Martin Häcker <martin.haecker@…>, 11 years ago

@reporter: We need more information on your environemnt to help you debug this. Please contact our support google group to help us debug this. For details see AgiloForScrum.

Thanks!

@rblank: thanks for the heads up! :)

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.