Hello everybody, I have just upgrade from Koha 3.20.07 to the last one release 16.05.03. I'm on Centos 6, all the Perl modules are ok, I have entered Koha and it seems that I can use all the Koha functions. However during the update of the database structure I got may errors, as you can see below. Is there anything troubling? Or can I go ahead using Koha? Thanks for you help Sandro ............. ............. Update errors : [Sat Sep 3 13:17:39 2016] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`kohadb`.`letter`, CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`)) [for Statement " [Sat Sep 3 13:17:39 2016] updatedatabase.pl: INSERT INTO letter (module, code, name, title, content, message_transport_type) Koha › Web installer › Step 3 https://catalogue-url.com/cgi-bin/koha/installer/install.pl... 4 di 6 03/09/2016 12:19 [Sat Sep 3 13:17:39 2016] updatedatabase.pl: VALUES [Sat Sep 3 13:17:39 2016] updatedatabase.pl: ('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.autho r>>.\n \nThank you,\n\n<<branches.branchname>>', 'email') [Sat Sep 3 13:17:39 2016] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer /data/mysql/updatedatabase.pl line 10639. [Sat Sep 3 13:17:40 2016] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`kohadb`.`letter`, CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`)) [for Statement " [Sat Sep 3 13:17:40 2016] updatedatabase.pl: INSERT IGNORE INTO letter (module, code, branchcode, name, title, content, message_transport_type) [Sat Sep 3 13:17:40 2016] updatedatabase.pl: VALUES('members','MEMBERSHIP_EXPIRY','','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian\r\n\r \n<<branches.branchname>>', 'email') [Sat Sep 3 13:17:40 2016] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer /data/mysql/updatedatabase.pl line 11063. [Sat Sep 3 13:17:40 2016] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`kohadb`.`letter`, CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`)) [for Statement " [Sat Sep 3 13:17:40 2016] updatedatabase.pl: INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) [Sat Sep 3 13:17:40 2016] updatedatabase.pl: VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues Slip', '0', 'OVERDUES_SLIP', 'The following item(s) is/are currently overdue: [Sat Sep 3 13:17:40 2016] updatedatabase.pl: [Sat Sep 3 13:17:40 2016] updatedatabase.pl: <item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item> [Sat Sep 3 13:17:40 2016] updatedatabase.pl: ', 'print' ) [Sat Sep 3 13:17:40 2016] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer /data/mysql/updatedatabase.pl line 11303. [Sat Sep 3 13:17:41 2016] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`kohadb`.`letter`, CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`)) [for Statement " [Sat Sep 3 13:17:41 2016] updatedatabase.pl: UPDATE letter SET code = "HOLD_SLIP" WHERE code = "RESERVESLIP"; [Sat Sep 3 13:17:41 2016] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer /data/mysql/updatedatabase.pl line 11675. [Sat Sep 3 13:17:41 2016] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`kohadb`.`letter`, CONSTRAINT `message_transport_type_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`)) [for Statement " [Sat Sep 3 13:17:41 2016] updatedatabase.pl: INSERT IGNORE INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) [Sat Sep 3 13:17:41 2016] updatedatabase.pl: VALUES ('members','PASSWORD_RESET','','Online password reset',1,'Koha password recovery','<html>\r\n<p>This email has been sent in response to your password recovery request for the account <strong><<user>></strong>.\r\n</p>\r\n<p>\r\nYou Koha › Web installer › Step 3 https://catalogue-url/cgi-bin/koha/installer/install.pl... 5 di 6 03/09/2016 12:19 can now create your new password using the following link:\r\n<br/> >\">< <\"> <passwordreseturl>> \r\n</p>\r\n<p>This link will be valid for 2 days from this email\'s reception, then you must reapply if you do not change your password.</p>\r \n<p>Thank you.</p>\r\n</html>\r\n','email'); [Sat Sep 3 13:17:41 2016] updatedatabase.pl: [Sat Sep 3 13:17:41 2016] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer /data/mysql/updatedatabase.pl line 11698. [Sat Sep 3 13:18:14 2016] updatedatabase.pl: At least one authorised value has an icon defined (imageurl) [Sat Sep 3 13:18:14 2016] updatedatabase.pl: The system preference AuthorisedValueImages or StaffAuthorisedValueImages could be turned off if you are not aware of this feature [Sat Sep 3 13:18:34 2016] updatedatabase.pl: C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate /hourlyloans.sql: [Sat Sep 3 13:18:34 2016] updatedatabase.pl: C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate /oai_sets.sql: ............. ............. -- View this message in context: http://koha.1045719.n5.nabble.com/Errors-in-updating-database-structure-from... Sent from the Koha-general mailing list archive at Nabble.com.