[Koha] Errors in updating database structure: from Koha 3.20.7 to 16.05.03

Sun Sep 4 00:12:30 NZST 2016

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\nThis email has been sent in response to your
password recovery request for the account
<<user>>.\r\n\r\n\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 >\"><
<\"> <passwordreseturl>> \r\n\r\nThis link will be valid for 2 days
from this email\'s reception, then you must reapply if you do not change
your password.\r \nThank you.\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-Koha-3-20-7-to-16-05-03-tp5902319.html
Sent from the Koha-general mailing list archive at Nabble.com.