Bonjour Samuel,

It seems the category codes you are receiving from your LDAP server doesn't match your patrons' categories defined in Koha.

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. 

Regards,

Eric Bégin

Tél  : 1-888-604-2627
Cell : 514-777-6572
inLibro | pour esprit libre | www.inLibro.com



-------- Message d'origine --------
De : Samuel Desseaux <samuel.desseaux@ecp.fr>
Date : 19/08/2013 10:54 (GMT-05:00)
À : koha@lists.katipo.co.nz, koha-devel@lists.koha-community.org
Objet : [Koha-devel] errors ldap


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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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