id summary reporter owner description type status priority component severity resolution keywords cc release 7383 trac-admin $ENV ticket_changesets commands fail w/ Trac 0.12 Dennis McRitchie Mikael Relbe "When running any of the trac-admin $ENV ticket_changesets commands, the results are always: {{{ trac-admin $ENV ticket_changesets diff diff ticket commit messages to be reformatted OperationalError: (1054, ""Unknown column 'rowid' in 'field list'"") }}} The column 'rowid' is no longer present in the ticket_change table. The patch below is a suggested fix: {{{ diff admin.py.orig admin.py 195c195 < cursor.execute('SELECT rowid,ticket,oldvalue,newvalue ' --- > cursor.execute('SELECT ticket,time,oldvalue,newvalue ' 198c198 < rowid, ticket, oldvalue, oldmessage = row --- > ticket, time, oldvalue, oldmessage = row 210,211c210,211 < 'SET newvalue=%s WHERE rowid=%s', < [newmessage, rowid]) --- > 'SET newvalue=%s WHERE ticket=%d AND time=%d', > [newmessage, ticket, time]) 213c213 < printout('@@ comment:%s:ticket:%s (db rowid %s) @@' --- > printout('@@ comment:%s:ticket:%d (db time %d) @@' }}}" defect closed normal TracTicketChangesetsPlugin normal fixed 0.12