id summary reporter owner description type status priority component severity resolution keywords cc release 1863 Error: columns ticket, time, field are not unique dilshod@… Noah Kantrowitz "I am trying to move tickets across trac environments and I get the following error: {{{ IntegrityError: columns ticket, time, field are not unique }}} I have a guess at what the problem might be. Lets say A is the originating env. and B is the destination. The ids of the tickets in A also exist in B. I think the datamover plug in does not created new ids that's why it is failing. Here is more debugging info: {{{ 2007-07-26 12:25:32,010 Trac[ticket] DEBUG: DatamoverTicketModule: Source is None (all) 2007-07-26 12:25:32,011 Trac[ticket] DEBUG: DatamoverTicketModule: Running query 'id!=0' 2007-07-26 12:25:32,016 Trac[query] DEBUG: Query SQL: SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value FROM ticket AS t LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority) WHERE COALESCE(t.id,'')!='0' ORDER BY COALESCE(t.priority,'')='',priority.value,t.id 2007-07-26 12:25:32,021 Trac[ticket] DEBUG: DatamoverTicketModule: Results: [1, 2, 3, 4, 5, 9, 11, 13, 14, 15, 16, 17, 18, 19, 6, 7, 8, 10, 12] 2007-07-26 12:25:32,042 Trac[main] ERROR: columns ticket, time, field are not unique Traceback (most recent call last): File ""/usr/lib/python2.4/site-packages/trac/web/main.py"", line 387, in dispatch_request dispatcher.dispatch(req) File ""/usr/lib/python2.4/site-packages/trac/web/main.py"", line 237, in dispatch resp = chosen_handler.process_request(req) File ""/usr/lib/python2.4/site-packages/TracWebAdmin-0.1.2dev_r4429-py2.4.egg/webadmin/web_ui.py"", line 109, in process_request path_info) File ""build/bdist.linux-i686/egg/datamover/ticket.py"", line 69, in process_admin_request File ""build/bdist.linux-i686/egg/datamover/util.py"", line 52, in copy_ticket 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 }}} " defect closed normal DatamoverPlugin major wontfix 0.10