[rt-users] Error "no row id returned on row creation at " when creating ticket after backup/restore

[charlycr74 at yahoo.com.ar]

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 at yahoo.com.ar" <charlycr74 at 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
http://bestpractical.com/training