Edgewall Software
Modify

Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#11732 closed defect (cantfix)

OperationalError: no such column: estimatedhours

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

Description

How to Reproduce

While doing a POST operation on /ticket/1, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'__EDITOR__1': u'wysiwyg',
 '__FORM_TOKEN': u'1b99146bc9da56fd5cb4221f',
 'action': u'leave',
 'cnum': u'1',
 'comment': u'',
 'id': u'1',
 'replyto': u'',
 'submit': u'Conferma le modifiche',
 'ts': u'2014-08-25 19:12:34.499595+00:00'}

User agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.78.2 (KHTML, like Gecko) Version/7.0.6 Safari/537.78.2

System Information

Trac 0.12.3
Trac 0.12.3
Agilo 0.9.7
Babel 0.9.6
Docutils 0.8.1
Genshi 0.6
GIT 1.7.10.5
mod_wsgi 3.3 (WSGIProcessGroup traclocal WSGIApplicationGroup %{GLOBAL})
Pygments 1.4
pysqlite 2.6.0
Python 2.7.3 (default, Feb 27 2014, 20:09:21)
[GCC 4.6.3]
Python 2.7.3 (default, Feb 27 2014, 20:09:21)
[GCC 4.6.3]
RPC 1.1.2
setuptools 0.6
setuptools 0.6
SQLite 3.7.9
Subversion 1.7.5 (r1336830)
jQuery 1.4.4

Enabled Plugins

agilo 0.9.7
ComponentDependencyPlugin 0.1
TicketSidebarProvider 0.0
timingandestimationplugin 1.2.7
Tracchildtickets 2.4.5
TracGit 0.12.0.5dev
TracHoursPlugin 0.5.2
TracMasterTickets 3.0.2
TracWysiwyg 0.12.0.4
TracXMLRPC 1.1.2
TracXPDev 1.0

Python Traceback

Traceback (most recent call last):
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/web/main.py", line 522, in _dispatch_request
    dispatcher.dispatch(req)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/web/main.py", line 243, in dispatch
    resp = chosen_handler.process_request(req)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/ticket/web_ui.py", line 169, in process_request
    return self._process_ticket_request(req)
  File "build/bdist.linux-x86_64/egg/agilo/ticket/web_ui.py", line 225, in _process_ticket_request
    template, data, content_type = super(AgiloTicketModule, self)._process_ticket_request(req)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/ticket/web_ui.py", line 541, in _process_ticket_request
    self._do_save(req, ticket, action)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/ticket/web_ui.py", line 1238, in _do_save
    cnum=internal_cnum):
  File "build/bdist.linux-x86_64/egg/agilo/ticket/model.py", line 808, in save_changes
    res = super(AgiloTicket, self).save_changes(author, comment, when, db, cnum)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/ticket/model.py", line 289, in save_changes
    @self.env.with_transaction(db)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/ticket/model.py", line 335, in do_save
    % name, (self[name], self.id))
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such column: estimatedhours

Attachments (0)

Change History (2)

comment:1 by Ryan J Ollos, 5 years ago

Cc: ​support@… added
Resolution: cantfix
Status: newclosed

comment:2 by stefano.rago@…, 5 years ago

@rjollos thanks for the cc
@reporter please write to support@…

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 as closed 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.