On 26 Nov 2009, at 15:38, David X. Glover wrote:
> In the end, that's what we did.
One (hopefully minor) problem left over. When attempting to create a
new ticket in the migrated database, I'm getting the SQL error
"Duplicate entry '0' for key 1" when trying to create the new record
in the Tickets table.
Actual errors from the log follows. Any ideas?
Nov 27 10:25:03 servername RT: DBD::mysql::st execute failed:
Duplicate entry '0' for key 1 at /usr/share/perl5/DBIx/SearchBuilder/
Handle.pm line 505. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:505)
Nov 27 10:25:03 servername RT: RT::Handle=HASH(0x2486af0) couldn't
execute the query 'INSERT INTO Tickets (Subject, Status, Queue,
Creator, Owner, LastUpdatedBy, Started, Type, Starts, Resolved,
Created, Priority, Due, LastUpdated) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/share/perl5/DBIx/
SearchBuilder/Handle.pm line 518
^IDBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH
(0x2486af0)', 'INSERT INTO Tickets (Subject, Status, Queue, Creator,
Owner, ...', 'test', 'new', 3, 22, 22, 22, '1970-01-01 00:00:00', ...)
called at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 353
^IDBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x2486af0)',
'Tickets', 'Subject', 'test', 'Status', 'new', 'Queue', 3,
'Creator', ...) called at /usr/share/perl5/DBIx/SearchBuilder/Handle/
mysql.pm line 36 ^IDBIx::SearchBuilder::Handle::mysql::Insert
('RT::Handle=HASH(0x2486af0)', 'Tickets', 'Subject', 'test', 'Status',
'new', 'Queue', 3, 'Creator', ...) called at /usr/share/perl5/DBIx/
SearchBuilder/Record.pm line 129
Nov 27 10:25:03 servername RT: Couldn't create a ticket: Internal
Error: Couldn't execute the query 'INSERT INTO Tickets (Subject,
Status, Queue, Creator, Owner, LastUpdatedBy, Started, Type, Starts,
Resolved, Created, Priority, Due, LastUpdated) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'Duplicate entry '0' for key
1 (/usr/share/request-tracker3.6/lib/RT/Ticket_Overlay.pm:602)
--
David X. Glover - Macintosh IT Support
Physics @ University of Oxford
http://www-astro.physics.ox.ac.uk/~Glover/
Jabber/GTalk: david...@jabber.ox.ac.uk
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
