1054, "Unknown column 'parents' in 'field list

[achape...@gmail.com]

1054, "Unknown column 'parents' in 'field list, the error appears when I modify a ticket. I have added Agilo for Trac.

More detailed  info:

 Internal Server Error: #012Traceback (most recent call last):#012  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/web/main.py", line 497, in _dispatch_request#012    dispatcher.dispatch(req)#012  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/web/main.py", line 214, in dispatch#012    resp = chosen_handler.process_request(req)#012  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/ticket/web_ui.py", line 179, in process_request#012    return self._process_ticket_request(req)#012  File "/usr/local/lib/python2.7/dist-packages/binary_agilo-1.3.11_PRO-py2.7.egg/agilo/ticket/web_ui.py", line 227, in _process_ticket_request#012    template, data, content_type = super(AgiloTicketModule, self)._process_ticket_request(req)#012  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/ticket/web_ui.py", line 614, in _process_ticket_request#012    self._do_save(req, ticket, action)#012  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/ticket/web_ui.py", line 1328, in _do_save#012    replyto=req.args.get('replyto'))#012  File "/usr/local/lib/python2.7/dist-packages/binary_agilo-1.3.11_PRO-py2.7.egg/agilo/ticket/model.py", line 855, in save_changes#012    res = super(AgiloTicket, self).save_changes(author, comment, when, db, cnum, replyto=replyto)#012  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/ticket/model.py", line 346, in save_changes#012    % name, (self[name], self.id))#012  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/db/util.py", line 121, in execute#012    cursor.execute(query, params)#012  File "/usr/local/lib/python2.7/dist-packages/Trac-1.0.1-py2.7.egg/trac/db/util.py", line 65, in execute#012    return self.cursor.execute(sql_escape_percent(sql), args)#012  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute#012    self.errorhandler(self, exc, value)#012  File "/usr/lib/python2.7/dist-packages/MySQLdb/con

[Steffen Hoffmann]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 30.10.2013 09:12, achape...@gmail.com wrote:
> 1054, "Unknown column 'parents' in 'field list, the error appears when I
> modify a ticket. I have added Agilo for Trac.
>
> More detailed info:
> Internal Server Error:

What a mess without proper line breaks.

Anyway, it looks like Agilo requires, but does not help with setting
appropriate configuration for a custom field [1] 'parents'. I don't know
much about Agilo, so I can't see, if it is Agilo's fault, or yours (not)
reading the relevant documentation.

In short: Create that field in trac.ini (likely a plain-text field with
that name will do), and the error should go away.

Steffen Hoffmann


[1] http://trac.edgewall.org/wiki/TracTicketsCustomFields
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAlJxO7sACgkQ31DJeiZFuHcUxQCgjVDDNlhCS9+9niCxIZSR9lQi
OyYAn3UxfVAuWcwFDpkiQL9MTef7CPqJ
=Bjur
-----END PGP SIGNATURE-----