[Koha] errors ldap

Samuel Desseaux samuel.desseaux at ecp.fr
Tue Aug 20 02:54:57 NZST 2013 

Hi,

Our koha is connected to our ldap now. During tests, we have some problems.
We have added 2 members the first time and it worked but we have this error

opac-user.pl <http://opac-user.pl>: DBD::mysql::st execute failed: 
Cannot add or update a child row: a foreign key constraint fails 
(`bibecp`.`borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY 
(`categorycode`) REFERENCES `categories` (`categorycode`)) at 
/home/koha/kohaclone/C4/Auth_with_ldap.pm line 296, <DATA> line 581., 
referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1

Now, we can't add members any more

These are the logs

tail -f koha-opac-error_log
[Mon Aug 19 15:20:06 2013] [error] [client 138.195.48.28] File does not 
exist: /home/koha/kohaclone/koha-tmpl/images, referer: 
http://tst-koha.ecp.fr/
[Mon Aug 19 15:20:08 2013] [error] [client 138.195.48.28] client denied 
by server configuration: 
/home/koha/kohaclone/koha-tmpl/opac-tmpl/prog/fr-FR/includes/favicon.ico
[Mon Aug 19 15:20:10 2013] [error] [client 138.195.48.28] File does not 
exist: /home/koha/kohaclone/koha-tmpl/images, referer: 
http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 
15:20:22 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized 
value in string ne at /home/koha/kohaclone/C4/Auth.pm line 670, <DATA> 
line 581., referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 
15:20:22 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized 
value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 
780, <DATA> line 581., referer: 
http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 
15:20:22 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized 
value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 
780, <DATA> line 581., referer: 
http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 
15:20:22 2013] opac-user.pl <http://opac-user.pl>: Illegal Date ' ' does 
not match 'metric' format: dd/mm/yyyy at 
/home/koha/kohaclone/C4/SQLHelper.pm line 407., referer: 
http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 
15:20:22 2013] opac-user.pl <http://opac-user.pl>: Illegal Date ' ' does 
not match 'metric' format: dd/mm/yyyy at 
/home/koha/kohaclone/C4/SQLHelper.pm line 407., referer: 
http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 
15:20:22 2013] opac-user.pl <http://opac-user.pl>: DBD::mysql::st 
execute failed: Column 'categorycode' cannot be null at 
/home/koha/kohaclone/C4/SQLHelper.pm line 184, <DATA> line 581., 
referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug 19 
15:20:22 2013] opac-user.pl <http://opac-user.pl>: AddMember failed at 
/home/koha/kohaclone/C4/Auth_with_ldap.pm line 156., referer: 
http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl
[Mon Aug 19 16:43:57 2013] [error] [client 138.195.30.33] client denied 
by server configuration: 
/home/koha/kohaclone/koha-tmpl/opac-tmpl/prog/fr-FR/includes/favicon.ico
[Mon Aug 19 16:43:57 2013] [error] [client 138.195.30.33] File does not 
exist: /home/koha/kohaclone/koha-tmpl/images, referer: 
http://tst-koha.ecp.fr/
[Mon Aug 19 16:43:58 2013] [error] [client 138.195.30.33] client denied 
by server configuration: 
/home/koha/kohaclone/koha-tmpl/opac-tmpl/prog/fr-FR/includes/favicon.ico
[Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug 19 
16:44:13 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized 
value in string ne at /home/koha/kohaclone/C4/Auth.pm line 670, <DATA> 
line 581., referer: http://tst-koha.ecp.fr/
[Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug 19 
16:44:13 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized 
value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 
780, <DATA> line 581., referer: http://tst-koha.ecp.fr/
[Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug 19 
16:44:13 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized 
value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 
780, <DATA> line 581., referer: http://tst-koha.ecp.fr/
[Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug 19 
16:44:13 2013] opac-user.pl <http://opac-user.pl>: DBD::mysql::st 
execute failed: Cannot add or update a child row: a foreign key 
constraint fails (`bibecp`.`borrowers`, CONSTRAINT `borrowers_ibfk_1` 
FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) 
at /home/koha/kohaclone/C4/Auth_with_ldap.pm line 296, <DATA> line 581., 
referer: http://tst-koha.ecp.fr/
[Mon Aug 19 16:44:15 2013] [error] [client 138.195.30.33] File does not 
exist: /home/koha/kohaclone/koha-tmpl/images, referer: 
http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl
[Mon Aug 19 16:44:52 2013] [error] [client 138.195.30.33] File does not 
exist: /home/koha/kohaclone/koha-tmpl/images, referer: 
http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1
[Mon Aug 19 16:44:54 2013] [error] [client 138.195.30.33] [Mon Aug 19 
16:44:54 2013] 404.pl <http://404.pl>: Use of uninitialized value 
$lasttime in numeric lt (<) at /home/koha/kohaclone/C4/Auth.pm line 694, 
<DATA> line 581., referer: 
http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1
[Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug 19 
16:45:05 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized 
value in string ne at /home/koha/kohaclone/C4/Auth.pm line 670, <DATA> 
line 581., referer: 
http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1
[Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug 19 
16:45:05 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized 
value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 
780, <DATA> line 581., referer: 
http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1
[Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug 19 
16:45:05 2013] opac-user.pl <http://opac-user.pl>: Use of uninitialized 
value $pki_field in string eq at /home/koha/kohaclone/C4/Auth.pm line 
780, <DATA> line 581., referer: 
http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1
[Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug 19 
16:45:05 2013] opac-user.pl <http://opac-user.pl>: DBD::mysql::st 
execute failed: Cannot add or update a child row: a foreign key 
constraint fails (`bibecp`.`borrowers`, CONSTRAINT `borrowers_ibfk_1` 
FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) 
at /home/koha/kohaclone/C4/Auth_with_ldap.pm line 296, <DATA> line 581., 
referer: http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1

An idea?

Best regards

samuel

More information about the Koha mailing list