<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body ><div>Bonjour Samuel,</div><div><br></div><div>It seems the category codes you are receiving from your LDAP server doesn't match your patrons' categories defined in Koha.</div><div><br></div><div>Double check also your date formats. You have some warning related to this too. I think they must be formatted as specified in you system preferences. </div><div><br></div><div>Regards,</div><div><br></div><span class="Apple-style-span" style="font-size: 10px; ">Eric Bégin</span><div><span class="Apple-style-span" style="font-size: 10px;"><br></span></div><div><span class="Apple-style-span" style="font-size: 10px; color: rgb(33, 124, 255);">Tél : 1-888-604-2627</span></div><div><span class="Apple-style-span" style="font-size: 10px;"><span class="Apple-style-span" style="color: rgb(33, 124, 255);">Cell : 514-777-6572</span><br></span><div><span class="Apple-style-span" style="font-size: 10px;">inLibro | pour esprit libre | www.inLibro.com</span></div></div><br><br><br>-------- Message d'origine --------<br>De : Samuel Desseaux <samuel.desseaux@ecp.fr> <br>Date : 19/08/2013 10:54 (GMT-05:00) <br>À : koha@lists.katipo.co.nz, koha-devel@lists.koha-community.org <br>Objet : [Koha-devel] errors ldap <br> <br><br>
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>