id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
3125,installation breaks creation of reports,tekknokrat,bobbysmith007,I am using the recent version of Trac (0.11-stable_7092) and TimingEstimation Plugin with postgresql backend.\r\n\r\nWhen I activate the timingandestimation plugin and try to customize a ticket report I get this error:\r\n\r\n{{{\r\n2008-06-03 18:02:03_980 Trac[main] ERROR: duplicate key value violates unique constraint "report_pkey"\r\nTraceback (most recent call last):\r\n  File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/web/main.py"_ line 423_ in _dispatch_request\r\n    dispatcher.dispatch(req)\r\n  File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/web/main.py"_ line 197_ in dispatch\r\n    resp = chosen_handler.process_request(req)\r\n  File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/ticket/report.py"_ line 93_ in process_request\r\n    self._do_create(req_ db)\r\n  File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/ticket/report.py"_ line 141_ in _do_create\r\n    "VALUES (%s_%s_%s)"_ (title_ query_ description))\r\n  File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/db/util.py"_ line 50_ in execute\r\n    return self.cursor.execute(sql_escape_percent(sql)_ args)\r\n  File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r7182-py2.5.egg/trac/db/util.py"_ line 50_ in execute\r\n    return self.cursor.execute(sql_escape_percent(sql)_ args)\r\nIntegrityError: duplicate key value violates unique constraint "report_pkey"\r\n}}}\r\n\r\nI tried with 1 sqlite based environment where this error does not occur.\r\nWorkaround I first had was to manually removing the t&e reports from database. After that creating/modifying of the reports worked. \r\nBut 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