<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi,<br>
<br>
Our koha is connected to our ldap now. During tests, we have some
problems.<br>
We have added 2 members the first time and it worked but we have
this error<br>
<br>
<a href="http://opac-user.pl">opac-user.pl</a>: 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: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1">http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1</a><br>
<br>
Now, we can't add members any more<br>
<br>
These are the logs<br>
<br>
tail -f koha-opac-error_log<br>
[Mon Aug 19 15:20:06 2013] [error] [client 138.195.48.28] File does
not exist: /home/koha/kohaclone/koha-tmpl/images, referer: <a
href="http://tst-koha.ecp.fr/">http://tst-koha.ecp.fr/</a><br>
[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<br>
[Mon Aug 19 15:20:10 2013] [error] [client 138.195.48.28] File does
not exist: /home/koha/kohaclone/koha-tmpl/images, referer: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl">http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl</a><br>
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug
19 15:20:22 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
Use of uninitialized value in string ne at
/home/koha/kohaclone/C4/Auth.pm line 670, <DATA> line 581.,
referer: <a href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl">http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl</a><br>
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug
19 15:20:22 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
Use of uninitialized value $pki_field in string eq at
/home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581.,
referer: <a href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl">http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl</a><br>
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug
19 15:20:22 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
Use of uninitialized value $pki_field in string eq at
/home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581.,
referer: <a href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl">http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl</a><br>
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug
19 15:20:22 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
Illegal Date ' ' does not match 'metric' format: dd/mm/yyyy at
/home/koha/kohaclone/C4/SQLHelper.pm line 407., referer: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl">http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl</a><br>
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug
19 15:20:22 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
Illegal Date ' ' does not match 'metric' format: dd/mm/yyyy at
/home/koha/kohaclone/C4/SQLHelper.pm line 407., referer: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl">http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl</a><br>
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug
19 15:20:22 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
DBD::mysql::st execute failed: Column 'categorycode' cannot be null
at /home/koha/kohaclone/C4/SQLHelper.pm line 184, <DATA> line
581., referer: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl">http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl</a><br>
[Mon Aug 19 15:20:22 2013] [error] [client 138.195.48.28] [Mon Aug
19 15:20:22 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
AddMember failed at /home/koha/kohaclone/C4/Auth_with_ldap.pm line
156., referer: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl">http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl</a><br>
[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<br>
[Mon Aug 19 16:43:57 2013] [error] [client 138.195.30.33] File does
not exist: /home/koha/kohaclone/koha-tmpl/images, referer: <a
href="http://tst-koha.ecp.fr/">http://tst-koha.ecp.fr/</a><br>
[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<br>
[Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug
19 16:44:13 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
Use of uninitialized value in string ne at
/home/koha/kohaclone/C4/Auth.pm line 670, <DATA> line 581.,
referer: <a href="http://tst-koha.ecp.fr/">http://tst-koha.ecp.fr/</a><br>
[Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug
19 16:44:13 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
Use of uninitialized value $pki_field in string eq at
/home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581.,
referer: <a href="http://tst-koha.ecp.fr/">http://tst-koha.ecp.fr/</a><br>
[Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug
19 16:44:13 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
Use of uninitialized value $pki_field in string eq at
/home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581.,
referer: <a href="http://tst-koha.ecp.fr/">http://tst-koha.ecp.fr/</a><br>
[Mon Aug 19 16:44:13 2013] [error] [client 138.195.30.33] [Mon Aug
19 16:44:13 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
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: <a href="http://tst-koha.ecp.fr/">http://tst-koha.ecp.fr/</a><br>
[Mon Aug 19 16:44:15 2013] [error] [client 138.195.30.33] File does
not exist: /home/koha/kohaclone/koha-tmpl/images, referer: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl">http://tst-koha.ecp.fr/cgi-bin/koha/opac-user.pl</a><br>
[Mon Aug 19 16:44:52 2013] [error] [client 138.195.30.33] File does
not exist: /home/koha/kohaclone/koha-tmpl/images, referer: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1">http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1</a><br>
[Mon Aug 19 16:44:54 2013] [error] [client 138.195.30.33] [Mon Aug
19 16:44:54 2013] <a href="http://404.pl">404.pl</a>: Use of
uninitialized value $lasttime in numeric lt (<) at
/home/koha/kohaclone/C4/Auth.pm line 694, <DATA> line 581.,
referer: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1">http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1</a><br>
[Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug
19 16:45:05 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
Use of uninitialized value in string ne at
/home/koha/kohaclone/C4/Auth.pm line 670, <DATA> line 581.,
referer: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1">http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1</a><br>
[Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug
19 16:45:05 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
Use of uninitialized value $pki_field in string eq at
/home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581.,
referer: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1">http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1</a><br>
[Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug
19 16:45:05 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
Use of uninitialized value $pki_field in string eq at
/home/koha/kohaclone/C4/Auth.pm line 780, <DATA> line 581.,
referer: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1">http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1</a><br>
[Mon Aug 19 16:45:05 2013] [error] [client 138.195.30.33] [Mon Aug
19 16:45:05 2013] <a href="http://opac-user.pl">opac-user.pl</a>:
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: <a
href="http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1">http://tst-koha.ecp.fr/cgi-bin/koha/opac-main.pl?logout.x=1</a><br>
<br>
An idea?<br>
<br>
Best regards<br>
<br>
samuel<br>
<br>
<br>
<br>
</body>
</html>