Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
koha error when adding new patron
Output from doing apt-get dist-upgrade:
C4::Installed::load_sql returned teh following errors while attempting to load /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/hourlyloans.sql:
ERROR 1060 at line 1: Duplicate column mae lengthunit
Dev atomic update: oai_sets.sql
C4:installer::load_sql ... atomicupdate/oai_ses.sql ERROR 1062 at line 35: Duplicat eentry OAI-PMH:AuoUpdateSts for key 'primary'
[Thu Nov 19 16:43:26 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:43:26 2015] memberentry.pl: Use of uninitialized value $_ in hash element at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 813., referer: http://192.168.0.19:8080/cgi-bin/koha/members/members-home.pl
[Thu Nov 19 16:43:26 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:43:26 2015] memberentry.pl: Use of uninitialized value in anonymous hash ({}) at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 813., referer: http://192.168.0.19:8080/cgi-bin/koha/members/members-home.pl
[Thu Nov 19 16:44:15 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:44:15 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrowers`, CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)) at /usr/share/koha/lib/C4/SQLHelper.pm line 184., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=GST
[Thu Nov 19 16:44:15 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:44:15 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=GST
[Thu Nov 19 16:44:15 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:44:15 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=GST
[Thu Nov 19 16:44:15 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:44:15 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=GST
[Thu Nov 19 16:44:15 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:44:15 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=GST
[Thu Nov 19 16:44:15 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:44:15 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=GST
[Thu Nov 19 16:44:15 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:44:15 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=GST
[Thu Nov 19 16:44:15 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:44:15 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=GST
[Thu Nov 19 16:44:15 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:44:15 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=GST
[Thu Nov 19 16:44:15 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:44:15 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=GST
[Thu Nov 19 16:44:15 2015] [error] [client 192.168.0.30] [Thu Nov 19 16:44:15 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=GST
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.