- Koha - lists.katipo.co.nz

Help with SQL script please
by Carlos Lopez 26 Aug '20

26 Aug '20

Hi everyone I'm trying to produce a list of itemnumbers for a list of bibliographic records with biblionumbers where subfield $9 in the 100 tag is in a list of authids for authorities with the value "Jesuit" in 373$a (where trying to populate a particular ccode with a set of items that we know will be relevant for that ccode). I have the following SQL query which SEEMS to run but brings up no results (even though I know that we have authority records with 373$aJesuit linked from bibliographic records with items attached): ---- SELECT i.itemnumber, b.title, b.author FROM items i LEFT JOIN biblio b ON b.biblionumber = i.biblionumber WHERE i.biblionumber IN (SELECT biblionumber FROM biblio_metadata WHERE ExtractValue(metadata, '//datafield[tag=100]/subfield[@code="9"]') IN (SELECT authid FROM auth_header WHERE ExtractValue(marcxml, '//datafield[@tag="373"]/subfield[@code="a"]') LIKE "Jesuit%")) ---- Can anyone spot where I've gone wrong? Or perhaps point me to an easier way of doing this? With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | library(a)dml.vic.edu.au<mailto:library@dml.vic.edu.au> | library.dmlibrary.org.au

3 3

Internal redirects exceeded on staff and opac interface
by Alvaro Cornejo 26 Aug '20

26 Aug '20

Hi, Doing a check on koha error logs I saw several of this error logs in both interfaces. How/where can I enable debug to check the origin of the error? [Mon Aug 24 07:42:42.636346 2020] [core:error] [pid 18902] [client 134.209.80.26:36734] AH00124: Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace. [Mon Aug 24 12:45:01.343417 2020] [core:error] [pid 5070] [client 34.75.137.220:37887] AH00124: Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace. I´m running 19.11.08.000 under ubuntu 18.04 Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire

1 0

Bulk upload of book cover images
by Vincent Van Gogh 24 Aug '20

24 Aug '20

How to upload images to Koha in bulk. Is there any procedure/technique or any App to take images of book covers and upload them to koha. Vincent Van Gogh

2 1

Re: [Koha] Error in Elasticsearch
by Christian McDonald 24 Aug '20

24 Aug '20

You can’t. You need to install the latest version of 6.x.x branch. 7.x.x will not work. On Mon, Aug 24, 2020 at 12:17 PM Luis Moises Rojas <lmoisesrojas(a)gmail.com> wrote: > version 7.8.1 > So, how do i reindex in this version or rebuild? > > El lun., 24 de ago. de 2020 a la(s) 12:10, Christian McDonald ( > rcmcdonald91(a)gmail.com) escribió: > >> What version of ES? Only ES 5 or 6 can be used, ES7 doesn’t work. >> >> On Mon, Aug 24, 2020 at 11:25 AM Luis Moises Rojas < >> lmoisesrojas(a)gmail.com> wrote: >> >>> After installed Elasticsearch and (at least) the following command: >>> >>> sudo koha-elasticsearch --rebuild -v -a -b library >>> >>> We have the following error: [27435] Checking state of biblios index >>> >>> [request] ** [http://locahost:9200]-[4000 [illegal_argument >>> _exception].... >>> >>> Thanks >>> >>> >>> >>> P.S: We are new using ElasticSearch >>> >>> -- >>> >>> *Luis Moisés Rojas P.* >>> >>> _______________________________________________ >>> >>> >>> >>> Koha mailing list http://koha-community.org >>> >>> Koha(a)lists.katipo.co.nz >>> >>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >>> >>> -- >> *R. Christian McDonald * >> M: (616) 856-9291 >> E: rcmcdonald91(a)gmail.com >> >> >> > > -- > *Luis Moisés Rojas P.* > > > > -- *R. Christian McDonald * M: (616) 856-9291 E: rcmcdonald91(a)gmail.com

1 0

Error in Elasticsearch
by Luis Moises Rojas 24 Aug '20

24 Aug '20

After installed Elasticsearch and (at least) the following command: sudo koha-elasticsearch --rebuild -v -a -b library We have the following error: [27435] Checking state of biblios index [request] ** [http://locahost:9200]-[4000 [illegal_argument _exception].... Thanks P.S: We are new using ElasticSearch -- *Luis Moisés Rojas P.*

1 0

batch_extend_due_dates
by vinod mishra 24 Aug '20

24 Aug '20

Hello Please confirm the " batch_extend_due_dates" option under tool also waive off the files? I mean the fine accumulated due to overdue will be also neglected/Updated after change of bulk due date? Thanks With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 URL: http://vinod.itshelp.co.in/ ORCID ID: http://orcid.org/0000-0003-4666-7874 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*

2 1

ingle-sign-on
by vinod kumar 20 Aug '20

20 Aug '20

1. SAML 2 is an XML-based single-sign-on protocol how to use in koha 2. OpenID not connect

1 0

Error with koha-common : Depende: libmojolicious-plugin-openapi-perl pero no va a instalarse
by Luis Moises Rojas 20 Aug '20

20 Aug '20

I had installed koha 19.11 before using the same procedure. I had installed these also sudo apt-get install cpanminus sudo apt install build-essential cpanm -i Mojolicious::Plugin::OpenAPI And perl. But these have this error. Any Help? -- *Luis Moisés Rojas P.*

2 2

SQL help
by Patricia Dowling 19 Aug '20

19 Aug '20

I wonder if anyone in the community can steer me on this basic SQL query? I am a very novice SQL user so apologies in advance! I want to get a list of bibnumbers for all records with a value of “Irish Office pamphlets” in the 440a tag (series) with title, author and publication date so that I can export this list to excel as a csv file. I have had a look around the Reports Library but got bogged down between the various tables biblio, items, marcxml etc.) Thanks in advance! Patricia Patricia Dowling, Research Librarian, Oireachtas Library & Research Service, Leinster House, Dublin 2, Ireland patricia.dowling(a)oireachtas.ie tel: (01) 6184311 Central Enquiry Desk: Tel. 00 353 1 6184701 Email library.and.research(a)oireachtas.ie<mailto:library.and.research@oireachtas.ie> ________________________________ Oireachtas email policy and disclaimer. http://www.oireachtas.ie/parliament/about/oireachtasemailpolicyanddisclaime… Beartas ríomhphoist an Oireachtais agus séanadh. http://www.oireachtas.ie/parliament/ga/eolas/beartasriomhphoistanoireachtai…

4 5

Zebra version
by Luis Moises Rojas 18 Aug '20

18 Aug '20

We are using koha 19.11 and zebra server is: Zebra 2.0.59 Actually zebra is: 2.1.4. Does Koha works fine with zebra 2.1.4? Do we have to upgrade the version? Any idea? Thanks -- *Luis Moisés Rojas P.*

1 0