Nope - it was easy fix. http://stackoverflow.com/questions/244243/how-to-reset-postgres-primary-key-sequence-when-it-falls-out-of-sync
On Thu, Jun 20, 2013 at 5:05 PM, Steffen Hoffmann <[email protected]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 20.06.2013 14:28, Oblio Leitch wrote: > > I recently moved over a couple of projects to a new environment, and now > > when I create a ticket, I get: "IntegrityError: duplicate key value > > violates unique constraint "ticket_pkey" DETAIL: Key (id)=(1) already > > exists." > > > > I /can/ see and modify all the tickets, just not add one. How can I get > > trac "caught up" with the current ticket id? > > Sounds pretty much like an issue related to that 'moving' of Trac db > content. The last/next row pointer for the (ticket?) db table is not > offset correctly. > > Probably this could be fixed by a simple db maintenance action? (What db > backend do you use?) Did you move the whole db or actually re-import db > content into a new db at the new location? Did you already try > alternative ways to import db data, if applicable? > > Steffen Hoffmann > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.10 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAlHDboYACgkQ31DJeiZFuHfmDgCfcQ8k28jFTuwjAEB+t7cOcT/m > JnsAoKccwzk/y/zdPaFX5P8CYMWDX/fD > =DOaL > -----END PGP SIGNATURE----- > > -- > You received this message because you are subscribed to the Google Groups > "Trac Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/trac-users. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/groups/opt_out.
