Error "no row id returned on row creation at " when creating ticket after backup/restore

Hello,

After moving my database from one server to another using mysqldump I get the following error when trying to create a new ticket:

Aug 3 23:40:36 server RT: RT::Handle=HASH(0x7fcd09354c10) no row id returned on row creation at /usr/local/share/perl5/DBIx/SearchBuilder/Handle/mysql.pm line 47. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle/mysql.pm:47)
Aug 3 23:40:36 server RT: Couldn’t create a ticket: Object could not be created (/sites/rt4/sbin/…/lib/RT/Ticket.pm:500)
Aug 3 23:40:36 server RT: WebRT: Ticket could not be created due to an internal error (/sites/rt4/share/html/Elements/Error:85)

Do you know why this could be happening?

mysql 5.1.73
httpd 2.2.15-30
RT 4.0.10

Thank you, Charly

This is fixed, the problem was on the dump of mysql that was not including the “AUTO_INCREMENT” option when creating the tables.

Standard mysqldump should be fine.El día domingo, 3 de agosto de 2014 17:47, “charlycr74@yahoo.com.ar” charlycr74@yahoo.com.ar escribió:
Hello,

After moving my database from one server to another using mysqldump I get the following error when trying to create a new ticket:

Aug 3 23:40:36 server RT: RT::Handle=HASH(0x7fcd09354c10) no row id returned on row creation at /usr/local/share/perl5/DBIx/SearchBuilder/Handle/mysql.pm line 47. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle/mysql.pm:47)
Aug 3 23:40:36 server RT: Couldn’t create a ticket: Object could not be created (/sites/rt4/sbin/…/lib/RT/Ticket.pm:500)
Aug 3 23:40:36 server RT: WebRT: Ticket could not be created due to an internal error (/sites/rt4/share/html/Elements/Error:85)

Do you know why this could be happening?

mysql 5.1.73
httpd 2.2.15-30
RT 4.0.10

Thank you, Charly

RT Training - Boston, September 9-10