id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,branch,changelog,apichanges,internalchanges 6975,error on adding comment to ticket,gimre@…,Christian Boos,"I'm helping the guys over at lighttpd to debug something, and i'm updating one of the tickets i opened (without logging in, i only provided the email address), and when i'm trying to add a new comment, i get the following error: {{{ ""Trac detected an internal error:"" Traceback (most recent call last): File ""/usr/lib/python2.4/site-packages/trac/web/main.py"", line 408, in dispatch_request dispatcher.dispatch(req) File ""/usr/lib/python2.4/site-packages/trac/web/main.py"", line 239, in dispatch resp = chosen_handler.process_request(req) File ""/usr/lib/python2.4/site-packages/trac/ticket/web_ui.py"", line 290, in process_request self._do_save(req, db, ticket) File ""/usr/lib/python2.4/site-packages/trac/ticket/web_ui.py"", line 557, in _do_save cnum=internal_cnum): File ""/usr/lib/python2.4/site-packages/trac/ticket/model.py"", line 262, in save_changes listener.ticket_changed(self, comment, author, old_values) File ""build/bdist.linux-i686/egg/removepending/remove_pending.py"", line 27, in ticket_changed File ""/usr/lib/python2.4/site-packages/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/db/sqlite_backend.py"", line 56, in execute args or []) File ""/usr/lib/python2.4/site-packages/trac/db/sqlite_backend.py"", line 48, in _rollback_on_error return function(self, *args, **kwargs) IntegrityError: columns ticket, time, field are not unique }}} The ticket was last updated more than 24 hours ago, now i just want to add my own comment again, and it won't let me. You can check it out at http://trac.lighttpd.net/trac/ticket/1583 . I have the 'Need feedback' option checked too, to receive changes in mail when the ticket changes. Sometimes it works as you can see, because i managed to submit other comments, but this is the second time this error happens. The first time ''i think'' i just left the email field as 'anonymous', and that way my comment was added.",defect,closed,normal,0.11.5,ticket system,0.10.4,normal,fixed,verify,,,,,