August 2013 - Koha-devel - lists.koha-community.org

Some patches which need signed off or QA
by Kenza Zaki 27 Aug '13

27 Aug '13

Hi everyone, I am working for Koha for approximately 3 months as a trainee for Biblibre. Currently, I have submitted 24 patches which 7 of them have been pushed to master: Bug 10499 VirtualShelves.t needs a database transaction Bug 10575 GetOrdersbyBiblionumber.t needs a database transaction Bug 10642 Inappropriate uses of finish() in C4/RotatingCollections.pm Bug 10643 Inappropriate uses of finish() in C4/ClassSource.pm Bug 10644 UT : C4/ClassSource.pm needs unit tests Bug 10653 UT: RotatingCollections.pm needs unit tests Bug 10761 UT: saved_report and delete_report in C4::Reports::Report_Guided.pm need unit tests. My internship ends next week (august the 30th) and i would really appreciate if most of my patches could be pushed before i leave Biblibre. Patches which need QA : Bug 10508 UT:C4/Branch.pm needs unit tests Bug 10528 UT: C4/Booksellers.pm needs unit tests Bug 10630 DelBooksellers return values needs to be more explicit in C4/Bookseller.pm Bug 1064 0 ModBookseller needs more explicit return value in C4/Bookseller.pm Bug 10641 GetBooksellerLateOrder has some incoherences in C4/Bookseller.pm Bug 10681 Inappropriate uses of finish() in C4/Circulation.pm Bug 10692 UT: Routines about transfers in Circulation.pm need unit tests Bug 10693 CreateBranchTransferLimit in Circulation.pm need more explicit return values Bug 10699 DeleteBranchTransferLimits in C4/Circulation.pm needs return value Patches which need Signed off: Bug 10682 Inappropriate uses of finish() in C4/Reserves.pm Bug 10685 Inappropriate uses of finish() in C4/Account.pm Bug 10698 DeleteTransfer in C4::Circulation.pm needs return value Bug 10710 UT : OfflineOperation's routines in C4/Circulation.t need unit tests Bug 10711 GetOfflineOperation in C4/Circulation.pm should returns $sth->fetchrow_hashref instead of $result Bug 10767 UT: Routines which interact with the table issuingrules in C4/Circulation need unit test Patch which needs to be push to master: Bug 10629 Inappropriate uses of finish() in C4/Branch.pm Anyway , working for Koha was a great experience to me! Thanks Kenza

3 3

Re: [Koha-devel] koha live dvd 3.14
by Quoc Uy 27 Aug '13

27 Aug '13

I will take that role at version 3.14 and I am trying keep updating lots of things for this. But I really don't care about name of koha released team. Just do what I think it would be good for community. I think one version should have only 3 live dvd max. For example 3.14.01, 06 and 10 maybe. 1 for testing, 2 for using and updating. See you all on 11 september. Sent from Yahoo! Mail on Android

1 0

Who is Live DVD manager of version 3.12.x?
by Vimal Kumar V. 26 Aug '13

26 Aug '13

Dear Friends, I don't know why Release Maintainer of Koha 3.12.x always forgot to give the exact name of Live DVD manager in release notes!!! http://koha-community.org/koha-3-12-4-released/ I once again request to Release Manager to read once more roles for 3.12 version. http://wiki.koha-community.org/wiki/Roles_for_3.12 I would like to get the reputation as Live DVD Manager. Like any other members in developers community, I had burned lot of my time to create Koha Live DVD for 3.12 version. Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

3 2

Re: [Koha-devel] [Koha] Who is Live DVD manager of version 3.12.x?
by Tomas Cohen Arazi 26 Aug '13

26 Aug '13

Vimal, and list members As I said before, the release team members list is the one from http://wiki.koha-community.org/wiki/Roles_for_3.14. I adjust the Release Manager to acknowledge Jared as 3.12's RM. People on the release announcement is people with current roles, voted 3rd April on the IRC meeting. As of 31 July I have already pushed a patch that acknowledges Vimal as LiveDVD maintainer during the 3.10-3.12 period [1], it appears in the "About" section in Koha, and will continue during the whole 3.12 lifecycle (this should be the patch Jared suggests). On Mon, Aug 26, 2013 at 2:27 PM, Vimal Kumar V. <vimal0212(a)gmail.com> wrote: > Dear Jared, > > Why Nguyen Quoc Uy name appeared in release notes of 3.12.3? > In my knowledge Live DVD of 3.12.3 or 3.12.4 have not released yet. > I think the lack of synergy with the dev community is the root for this problems. Maybe Nguyen and you could be on IRC or arrange an IRC meeting and we could sort this out easily. As of me, your work is acknowledged by my patch. And feel comfortable about that. Regards To+ [1] http://git.koha-community.org/gitweb/?p=koha.git;a=blobdiff;f=koha-tmpl/int… > > > On Mon, Aug 26, 2013 at 10:40 PM, Jared Camins-Esakov < > jcamins(a)cpbibliography.com> wrote: > > > Vimal, et. al., > > > > As Tomas stated last time, the release notes list the current members of > > the release team. As your term as livedvd manager ended several months > ago, > > you are not a member of the current release team. You will notice that D. > > Ruth Bavousett and Elliott Davis are not currently listed either, despite > > having been members of the release team during the 3.12. > > > > I would also note that there was a security release on the Koha 3.12.x > > branch last month. If your argument is not just that you released the > > livedvd for Koha 3.12.0 (which no one -- other than, apparently, you -- > > questions) but rather that you are the current maintainer of the Koha > > 3.12.x livedvd, your argument would be much-strengthened by releasing an > > updated version of the livedvd without the serious security flaw which > was > > addressed in 3.12.3. > > > > That said, I take no particular stance on this question, but I will point > > out that Koha is an open source project, and patches are always accepted. > > If you feel that your name should be listed in the release notes, > > submitting a patch that adds your name (and provides an explanation in > the > > commit message about why this is necessary) would be a good idea. > > > > Regards, > > Jared > > > > > > > > On Mon, Aug 26, 2013 at 12:49 PM, Vimal Kumar V. <vimal0212(a)gmail.com > >wrote: > > > >> Dear Friends, > >> I don't know why Release Maintainer of Koha 3.12.x always forgot to give > >> the exact name of Live DVD manager in release notes!!! > >> http://koha-community.org/koha-3-12-4-released/ > >> > >> I once again request to Release Manager to read once more roles for 3.12 > >> version. > >> http://wiki.koha-community.org/wiki/Roles_for_3.12 > >> > >> I would like to get the reputation as Live DVD Manager. > >> Like any other members in developers community, I had burned lot of my > >> time to create Koha Live DVD for 3.12 version. > >> > >> Regards, > >> -- > >> Vimal Kumar V. > >> Technical Assistant > >> Mahatma Gandhi University Library > >> Kottayam, Kerala- 686 560 > >> Web: http://www.vimalkumar.info > >> Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in > >> > >> > --------------------------------------------------------------------------- > >> "I forget what I was taught. I only remember what I have learnt" > >> -Patrick White > >> > >> _______________________________________________ > >> Koha-devel mailing list > >> Koha-devel(a)lists.koha-community.org > >> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > >> website : http://www.koha-community.org/ > >> git : http://git.koha-community.org/ > >> bugs : http://bugs.koha-community.org/ > >> > > > > > > > > -- > > Jared Camins-Esakov > > Bibliographer, C & P Bibliography Services, LLC > > (phone) +1 (917) 727-3445 > > (e-mail) jcamins(a)cpbibliography.com > > (web) http://www.cpbibliography.com/ > > > > > > -- > Vimal Kumar V. > Technical Assistant > Mahatma Gandhi University Library > Kottayam, Kerala- 686 560 > Web: http://www.vimalkumar.info > Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in > --------------------------------------------------------------------------- > "I forget what I was taught. I only remember what I have learnt" > -Patrick White > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

1 0

Global bug squashing day starts in less than 2 hours!
by Magnus Enger 22 Aug '13

22 Aug '13

(...if you choose to go by Kiribati time). http://wiki.koha-community.org/wiki/2013-08-23_Global_bug_squashing_day Currently the dashboard reports these numbers: Needs Signoff - 166 (56 bugs) Signed Off - 99 (47 bugs) Passed QA - 34 (12 bugs) Failed QA - 142 Patch Doesn't apply - 21 In Discussion - 115 So there is plenty of fun to be had! Come join us! Best regards, Magnus Enger libriotech.no

1 0

Old bugs to check
by MJ Ray 21 Aug '13

21 Aug '13

Would you check some of these rather old bugs to suggest what to do, please? Maybe some can be RESOLVED FIXED by now or need a question. Please leave your reply on the bug web page - I might not see replies to this mail. Ideally, tell irc.oftc.net #koha know that you're looking at a bug. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6324 The upload directory (public) is not writable by the webserver. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3681 No bimonthly frequency option for serials subscriptions http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6607 Guided reports process does not offer correct limit options http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6756 Patron anonymizing tool reports false success http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2838 Checking in an in-transit item to its originating branch causes improper error message(s) http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1289 Bulk/global edit for MARC frameworks http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5276 subscription info shouldn't be required http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6615 Add shelving location option to transfers page http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3873 Gracefully handle errors when item in staff client cart has been deleted http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6864 add a syspref to allow custom text for OPAC user/pass information http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3471 Enhanced borrower history http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5272 can't import just patron attributes http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2693 Tagging: Add filter by name http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5334 add explicit foreign key constraints http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5851 SIP Slips printed in wrong circumstances -- Local hold and no hold items http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5821 Enable cron job for merge_authorities.pl http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3008 Increase 64k text limit for overdue notice file http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5968 News display on opac-main.pl is particular about browser language settings http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6845 Add default date (today) to view log -- Email robot driven by MJ Ray (slef), member of www.software.coop, http://koha-community.org supporter, web and library systems developer. Available for hire (including development) at http://www.software.coop/

1 0

Spinelabel question
by rafael 20 Aug '13

20 Aug '13

Hi everyone, I am working on a small library for a cultural center and we are using koha 3.12.03.000. I am trying to change the Label so that the barcode is aligned to the left and the text information to the right. This way my label can show the location codes on the spine and the bigger barcode on the back. Do I have to edite spinelabel.css to acheive this? Is there a specific tag for the barcode? I also took a look at spinelabel-print.pl, but found no input for the barcode position. Thanks, Rafael

1 0

pending bugs about UNIMARC marc flavor
by Mathieu Saby 20 Aug '13

20 Aug '13

Hello As the RM stressed in his last post (http://koha-community.org/koha-3-14-release-managers-update-2/) "there are a large number of UNIMARC patches that have been awaiting review for a long time". Being the author of some of them, I have been hoping for a long time that somebody could test them, but I know it is not easy, because only a few UNIMARC people have the time and/or the skill to do so (it can't be done in a sandbox...). And MARC21 people often don't have UNIMARC data (with records, frameworks, etc) to make test. Maybe it can help if you want to take a look, here is a zipped dump of my UNIMARC test database: https://www.dropbox.com/s/idw98d7jiy5e5xd/dump_unimarc.zip superlibrarian ID is "msaby" (password "msaby") (in my computer the database is owned by user root / pdw root, but I suppose this is not important) Here are the bugs to sign off about unimarc : 9352 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9352> Zebra indexes useless subfields in UNIMARC 7XX <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9352> 9828 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9828> Zebra indexes useless subfields in UNIMARC 6XX <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9828> 9830 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9830> Some UNIMARC item indexes could be broken whith Queryweightfields syspref <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9830> 10564 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10564> use OPACURLOpenInNewWindow in UNIMARCslim2OPACResults.xsl <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10564> 10331 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10331> Little errors in unimarc_field_4XX.pl (punctuation) <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10331> 10335 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10335> UNIMARC authorities search doesn't display properly information on parallel form <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10335> 10324 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10324> Editorial series do not display correctly in normal view (UNIMARC / no XSLT) <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10324> 8252 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8252> Error in DOM biblio for UNIMARC (no range for fields 1xx) <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8252> 10037 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10037> fix item index in UNIMARC DOM indexing <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10037> 7421 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7421> UNIMARC authorities DOM indexing mode <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7421> 9192 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9192> UNIMARC_sync_date_created_with_marc_biblio.pl field creation <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9192> 9453 <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9453> Update records acording to the new UNIMARCField100Language system preference <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9453> 12 bugs found. Of course I can give you explanation or advice regarding the bugs I wrote. (9352, 9828, 9830, 8252, 10037, 7421). Just comment on bugzilla and I will be glad to help. Regards, M. Saby -- Mathieu Saby Service d'Informatique Documentaire Service Commun de la Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.saby(a)univ-rennes2.fr

1 0

RE : errors ldap
by Eric Bégin 19 Aug '13

19 Aug '13

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(a)ecp.fr> Date : 19/08/2013 10:54 (GMT-05:00) À : koha(a)lists.katipo.co.nz, koha-devel(a)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

1 0

errors ldap
by Samuel Desseaux 19 Aug '13

19 Aug '13

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

1 0