id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 3125,installation breaks creation of reports,tekknokrat,Russ Tyndall,"I am using the recent version of Trac (0.11-stable_7092) and TimingEstimation Plugin with postgresql backend. When I activate the timingandestimation plugin and try to customize a ticket report I get this error: {{{ 2008-06-03 18:02:03,980 Trac[main] ERROR: duplicate key value violates unique constraint ""report_pkey"" Traceback (most recent call last): File ""/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/web/main.py"", line 423, in _dispatch_request dispatcher.dispatch(req) File ""/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/web/main.py"", line 197, in dispatch resp = chosen_handler.process_request(req) File ""/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/ticket/report.py"", line 93, in process_request self._do_create(req, db) File ""/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/ticket/report.py"", line 141, in _do_create ""VALUES (%s,%s,%s)"", (title, query, description)) File ""/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-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.11dev_r7182-py2.5.egg/trac/db/util.py"", line 50, in execute return self.cursor.execute(sql_escape_percent(sql), args) IntegrityError: duplicate key value violates unique constraint ""report_pkey"" }}} I tried with 1 sqlite based environment where this error does not occur. Workaround I first had was to manually removing the t&e reports from database. After that creating/modifying of the reports worked. But when trying to restore the reports through trac-admin upgrade it seems this gets broken because of manual deleting reports.",defect,closed,normal,TimingAndEstimationPlugin,normal,fixed,postgresql,,0.11