[rt-users] Migrating from SQLite to MySQL

[David X. Glover]

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: davidcwg at jabber.ox.ac.uk