Hi everyone,
I have installed Agilo egg on a Trac environment (version 0.11.4), but
when I try to modify an existing ticket I obtain the following error:
"OperationalError: no such column: i_links".
My Trac environments has a lot of tickets already present in it and we
are trying to migrate our process of development to Scrum.
I'm attaching to this email also the Python Traceback:
Python Traceback
Most recent call last:
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/web/main.py", line 435, in _dispatch_request
Code fragment:
430. try:
431. if not env and env_error:
432. raise HTTPInternalError(env_error)
433. try:
434. dispatcher = RequestDispatcher(env)
435. dispatcher.dispatch(req)
436. except RequestDone:
437. pass
438. resp = req._response or []
439.
440. 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
0xa1c124c>
e OperationalError('no such column: i_links',)
env <trac.env.Environment object at 0x991184c>
env_error None
exc_info (<class 'pysqlite2.dbapi2.OperationalError'>,
OperationalError('no such ...
filename '/usr/lib/python2.5/site-packages/Trac-0.11.4-
py2.5.egg/trac/web/main.py'
frames [{'function': '_dispatch_request', 'lines_before': [u'
try:', u' ...
has_admin True
line u' dispatcher.dispatch(req)'
lineno 434
message u'OperationalError: no such column: i_links'
req <Request "POST u'/ticket/2862'">
resp []
tb <traceback object at 0xa31a8ec>
tb_hide None
traceback u'Traceback (most recent call last):\n File ...
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/web/main.py", line 205, in dispatch
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 <agilo.ticket.web_ui.AgiloTicketModule object at
0xa1de8ec>
chrome <trac.web.chrome.Chrome object at 0xa1c118c>
ctype 'application/x-www-form-urlencoded'
err (<class 'pysqlite2.dbapi2.OperationalError'>,
OperationalError('no such ...
handler <agilo.ticket.web_ui.AgiloTicketModule object at
0xa1de8ec>
options {}
req <Request "POST u'/ticket/2862'">
self <trac.web.main.RequestDispatcher object at 0xa1c124c>
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/ticket/web_ui.py", line 182, in process_request
Code fragment:
177.
178. def process_request(self, req):
179. if 'id' in req.args:
180. if req.path_info == '/newticket':
181. raise TracError(_("id can't be set for a new ticket
request."))
182. return self._process_ticket_request(req)
183. return self._process_newticket_request(req)
184.
185. # ITemplateProvider methods
186.
187. def get_htdocs_dirs(self):
Local variables:
Name Value
req <Request "POST u'/ticket/2862'">
self <agilo.ticket.web_ui.AgiloTicketModule object at
0xa1de8ec>
* File "/srv/trac/testagilo/plugins/binary_agilo-1.1.0_PRO-
py2.5.egg/agilo/ticket/web_ui.py", line 200, in
_process_ticket_request
Local variables:
Name Value
RuleValidationException <class
'agilo.scrum.workflow.api.RuleValidationException'>
content_type None
data None
req <Request "POST u'/ticket/2862'">
self <agilo.ticket.web_ui.AgiloTicketModule object at
0xa1de8ec>
template None
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/ticket/web_ui.py", line 508, in _process_ticket_request
Code fragment:
503. # things.
504. valid = self._validate_ticket(req, ticket) and not
problems
505. if 'preview' not in req.args:
506. if valid:
507. # redirected if successful
508. self._do_save(req, ticket, action)
509. # else fall through in a preview
510. req.args['preview'] = True
511.
512. # Preview an existing ticket (after a Preview or a failed
Save)
513. data.update({
Local variables:
Name Value
action u'reassign'
actions ['leave', 'resolve', 'request_info', 'reassign']
data {'comment': None, 'preserve_newlines': True, 'ticket': ...
field_changes {'i_links': {'new': u'', 'old': None, 'by':
'user'}, 'businessvalue': ...
id 2862
problems []
req <Request "POST u'/ticket/2862'">
self <agilo.ticket.web_ui.AgiloTicketModule object at
0xa1de8ec>
ticket <agilotic...@163184556 #2862 (u'bug')>
valid True
version None
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/ticket/web_ui.py", line 1014, in _do_save
Code fragment:
1009. # -- Save changes
1010.
1011. now = datetime.now(utc)
1012. if ticket.save_changes(get_reporter_id(req, 'author'),
1013. req.args.get('comment'), when=now,
1014. cnum=internal_cnum):
1015. try:
1016. tn = TicketNotifyEmail(self.env)
1017. tn.notify(ticket, newticket=False, modtime=now)
1018. except Exception, e:
1019. self.log.error("Failure sending notification on change to
"
Local variables:
Name Value
action u'reassign'
cnum u'23'
controllers
[<trac.ticket.default_workflow.ConfigurableTicketWorkflow object
at ...
internal_cnum u'23'
now datetime.datetime(2009, 11, 19, 7, 41, 42, 916873,
tzinfo=<FixedOffset ...
replyto u''
req <Request "POST u'/ticket/2862'">
self <agilo.ticket.web_ui.AgiloTicketModule object at
0xa1de8ec>
ticket <agilotic...@163184556 #2862 (u'bug')>
* File "/srv/trac/testagilo/plugins/binary_agilo-1.1.0_PRO-
py2.5.egg/agilo/ticket/model.py", line 756, in save_changes
Local variables:
Name Value
author u'[email protected]'
cnum u'23'
comment u''
db None
self <agilotic...@163184556 #2862 (u'bug')>
when datetime.datetime(2009, 11, 19, 7, 41, 42, 916873,
tzinfo=<FixedOffset ...
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/ticket/model.py", line 273, in save_changes
Code fragment:
268. cursor.execute("INSERT INTO ticket_custom (ticket,name,"
269. "value) VALUES(%s,%s,%s)",
270. (self.id, name, self[name]))
271. else:
272. cursor.execute("UPDATE ticket SET %s=%%s WHERE id=%%s" %
name,
273. (self[name], self.id))
274. cursor.execute("INSERT INTO ticket_change "
275. "(ticket,time,author,field,oldvalue,newvalue) "
276. "VALUES (%s, %s, %s, %s, %s, %s)",
277. (self.id, when_ts, author, name, self._old[name],
278. self[name]))
Local variables:
Name Value
author u'[email protected]'
cc u'[email protected]'
cclist [u'[email protected]']
cnum u'23'
comment u''
cursor <trac.db.util.IterableCursor object at 0xa1ed644>
custom_fields ['sprint']
db <trac.db.pool.PooledConnection object at 0xa61e22c>
f {'name': 'sprint', 'optional': True, 'value': u'', 'custom':
True, ...
handle_ta True
name 'i_links'
self <agilotic...@163184556 #2862 (u'bug')>
when datetime.datetime(2009, 11, 19, 7, 41, 42, 916873,
tzinfo=<FixedOffset ...
when_ts 1258616502
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/db/util.py", line 50, in execute
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'', 2862)
self <trac.db.util.IterableCursor object at 0xa1ed644>
sql 'UPDATE ticket SET i_links=%s WHERE id=%s'
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/db/sqlite_backend.py", line 58, in execute
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'', 2862)
self <trac.db.sqlite_backend.PyFormatCursor object at
0xa443f2c>
sql 'UPDATE ticket SET i_links=? WHERE id=?'
* File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/
trac/db/sqlite_backend.py", line 50, in _rollback_on_error
Code fragment:
45. sqlite_version_string = '%d.%d.%d' % (_ver[0], _ver[1], int
(_ver[2]))
46.
47. class PyFormatCursor(sqlite.Cursor):
48. def _rollback_on_error(self, function, *args, **kwargs):
49. try:
50. return function(self, *args, **kwargs)
51. except sqlite.DatabaseError, e:
52. self.cnx.rollback()
53. raise
54. def execute(self, sql, args=None):
55. if args:
Local variables:
Name Value
args ('UPDATE ticket SET i_links=? WHERE id=?', (u'', 2862))
e OperationalError('no such column: i_links',)
function <method 'execute' of 'pysqlite2.dbapi2.Cursor'
objects>
kwargs {}
self <trac.db.sqlite_backend.PyFormatCursor object at
0xa443f2c>
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/web/
main.py", line 435, in _dispatch_request
dispatcher.dispatch(req)
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/web/
main.py", line 205, in dispatch
resp = chosen_handler.process_request(req)
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/
ticket/web_ui.py", line 182, in process_request
return self._process_ticket_request(req)
File "/srv/trac/testagilo/plugins/binary_agilo-1.1.0_PRO-py2.5.egg/
agilo/ticket/web_ui.py", line 200, in _process_ticket_requestFile "/
usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/ticket/
web_ui.py", line 508, in _process_ticket_request
self._do_save(req, ticket, action)
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/
ticket/web_ui.py", line 1014, in _do_save
cnum=internal_cnum):
File "/srv/trac/testagilo/plugins/binary_agilo-1.1.0_PRO-py2.5.egg/
agilo/ticket/model.py", line 756, in save_changesFile "/usr/lib/
python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/ticket/model.py",
line 273, in save_changes
(self[name], self.id))
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/db/
util.py", line 50, in execute
return self.cursor.execute(sql_escape_percent(sql), args)
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/db/
sqlite_backend.py", line 58, in execute
args or [])
File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/db/
sqlite_backend.py", line 50, in _rollback_on_error
return function(self, *args, **kwargs)
Did anyone has this error before ? Please help me.
Thank you,
Nicu.
--
Follow Agilo on Twitter: http://twitter.com/agiloforscrum
-----
You received this message because you are subscribed to the Google
Groups "Agilo for Scrum" group. This group is moderated by agile42 GmbH
http://www.agile42.com and is focused in supporting Agilo for Scrum users.
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/agilo?hl=en
