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