- Koha - lists.katipo.co.nz

Guided Reports Throwing 500 Error
by Jesse Stallings 03 Aug '21

03 Aug '21

In the past, running an SQL report with an error would yield an error page with the problem syntax highlighted. Now, I only get a 500 error. Possibly relevant lines of plack-intranet-error.log here <https://pastebin.com/0UCYkU46>. Is this expected behavior? Jesse Stallings

3 3

Re: [Koha] Missing bibliographic details.
by muiru james 03 Aug '21

03 Aug '21

Hi Aleisha and all, Thank you so much for your help. It helped my problem. Thanks a million. Very Warm Regards James On Tue, 3 Aug 2021 00:07 Aleisha Amohia, <aleisha(a)catalyst.net.nz> wrote: > Hi Muiru > > Your query is almost there! I think your error is happening because of the > columns you're joining the tables on. The joining column should be equal > (or represent the same data) in both tables to be accurate. You should > amend the query to look more like: > > SELECT items.itemcallnumber, items.barcode, biblio.author,biblio.title, > biblioitems.publishercode AS ISBN, items.price > FROM items > LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber) > LEFT JOIN biblioitems ON (biblioitems.biblionumber=items.biblionumber) > LEFT JOIN biblio_metadata ON > (items.biblionumber=biblio_metadata.biblionumber) > > Hopefully that gives you some data in your results. > > Also just noticed that you're using biblioitems.publishercode as ISBN, I'm > sure you know this, but there is also a biblioitems.isbn field that might > be mapped more accurately for you to use for this purpose. > > Hope that helps! > > Aleisha > On 2/08/21 9:40 pm, muiru james wrote: > > Hello team, > > I recently reinstalled koha 20.05 on Ubuntu 20. I'm running a complete > shelflist report with columns biblio.author, biblio.title. However for new > items added to the records, columns for author and title are blank. I have > tried to use the extractvalue from biblio_metadata and the result is the > same. > > The query is as below: > > SELECT > items.itemcallnumber, items.barcode, biblio.author,biblio.title, > biblioitems.publishercode AS ISBN, items.price. > From items > LEFT JOIN biblio ON (biblio.biblionumber=items.itemnumber) > LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=biblionumber) > LEFT JOIN biblio_metadata ON (items.itemnumber=biblio_metadata.biblionumber) > > Records staged after installation has the details but new items added ti > the existing records has only data from the items table- callnumber, > barcode and price. > > During the installation process, i could not install mariadb directly n had > to install the mariadbserver10.03 then mariadbclient-10.03 then > mariadbserver. > > I have tried rebuilding zebra and also rebuilding the tables from therebuildtables.pl without success. > > Any help will be greatly appreciated. > > Regards > James > _______________________________________________ > > Koha mailing list http://koha-community.orgKoha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > -- > *Aleisha Amohia*(she/her) > Koha Developer > > Catalyst IT - Expert Open Source Solutions > Tel: +64 4 499 2267 | www.catalyst.net.nz > > [image: Catalyst Logo] > > CONFIDENTIALITY NOTICE: This email is intended for the named recipients > only. It may contain privileged, confidential or copyright information. If > you are not the named recipient, any use, reliance upon, disclosure or > copying of this email or its attachments is unauthorised. If you have > received this email in error, please reply via email or call +64 4 499 2267. >

1 0

gmail account in koha 3.22.21
by George Mikuchadze 03 Aug '21

03 Aug '21

Dear colleagues, I have Koha v3.22.21 (the last one in the 3rd branch) and I have a Gmail account to send overdue notes to patrons. Ubuntu 16.04 was OS for the koha server (till the end of Apr 2021, and now I upgraded to Ubuntu v 18.04). I used the "CONFIGURE.gmail" document to configure xinetd service to send overdue messages to koha OPAC users through my Gmail account. But there was some trouble(I don't know what) and koha didn't send any overdue notes since Apr 2020. I tried to use postfix for the purpose but without success. Can anybody give me advice on this issue? Best regards George Mikuchadze

1 0

[koha] Missing bibliographic details.
by Aleisha Amohia 02 Aug '21

02 Aug '21

Hi Muiru Your query is almost there! I think your error is happening because of the columns you're joining the tables on. The joining column should be equal (or represent the same data) in both tables to be accurate. You should amend the query to look more like: SELECT items.itemcallnumber, items.barcode, biblio.author,biblio.title, biblioitems.publishercode AS ISBN, items.price FROM items LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber) LEFT JOIN biblioitems ON (biblioitems.biblionumber=items.biblionumber) LEFT JOIN biblio_metadata ON (items.biblionumber=biblio_metadata.biblionumber) Hopefully that gives you some data in your results. Also just noticed that you're using biblioitems.publishercode as ISBN, I'm sure you know this, but there is also a biblioitems.isbn field that might be mapped more accurately for you to use for this purpose. Hope that helps! Aleisha On 2/08/21 9:40 pm, muiru james wrote: > Hello team, > > I recently reinstalled koha 20.05 on Ubuntu 20. I'm running a complete > shelflist report with columns biblio.author, biblio.title. However for new > items added to the records, columns for author and title are blank. I have > tried to use the extractvalue from biblio_metadata and the result is the > same. > > The query is as below: > > SELECT > items.itemcallnumber, items.barcode, biblio.author,biblio.title, > biblioitems.publishercode AS ISBN, items.price. > From items > LEFT JOIN biblio ON (biblio.biblionumber=items.itemnumber) > LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=biblionumber) > LEFT JOIN biblio_metadata ON (items.itemnumber=biblio_metadata.biblionumber) > > Records staged after installation has the details but new items added ti > the existing records has only data from the items table- callnumber, > barcode and price. > > During the installation process, i could not install mariadb directly n had > to install the mariadbserver10.03 then mariadbclient-10.03 then > mariadbserver. > > I have tried rebuilding zebra and also rebuilding the tables from the > rebuildtables.pl without success. > > Any help will be greatly appreciated. > > Regards > James > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha -- *Aleisha Amohia*(she/her) Koha Developer Catalyst IT - Expert Open Source Solutions Tel: +64 4 499 2267 | www.catalyst.net.nz <http://www.catalyst.net.nz> Catalyst Logo CONFIDENTIALITY NOTICE: This email is intended for the named recipients only. It may contain privileged, confidential or copyright information. If you are not the named recipient, any use, reliance upon, disclosure or copying of this email or its attachments is unauthorised. If you have received this email in error, please reply via email or call +64 4 499 2267.

1 0

koha-US August 2021 Events & Meetings
by Jason Robb 02 Aug '21

02 Aug '21

koha-US online meetings and events are free and open to all. See our calendar for a full list: http://koha-us.org/calendar/. *Meetings* Board Meeting - Wednesday, August 4 @ 8:30a PT / 11:30a ET / 15:30 UTC - Meeting Link - https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 - Agenda - https://docs.google.com/document/d/1y8-JRvCa4oHawPTRPtu6Dw9Tp0ZeAVU3WBcC7n-… General Meeting - Wednesday, August 11 @ 8:30a PT / 11:30a ET / 15:30 UTC *Special Interest Groups* Circulation - Tuesday, August 3 @ 10:00a PT / 1:00p ET / 17:00 UTC Cataloging - Thursday, August 5 @ 8:00a PT / 11:00a ET / 15:00 UTC Acquisitions - Tuesday, August 17 @ 9:00a PT / 12:00p ET / 16:00 UTC Web Development - Thursday, August 19 @ 10:00a PT / 1:00p ET / 17:00 UTC Books & Crafts - Wednesday, August 25 @ 5:00p PT / 8:00p ET / 00:00 UTC Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topic-specific mailing lists. Most meetings and events are recorded and made available at https://www.youtube.com/kohaus For Google Calendar users, add our events calendar to your list for easy access to meeting times and links: https://calendar.google.com/calendar/u/1?cid=a29oYS11cy5vcmdfZG1xb2pkczE5Zn… Jason Robb koha-US Secretary secretary(a)koha-us.org

1 0

OCLC Conexxion Gateway
by Shafrizan Affendi 02 Aug '21

02 Aug '21

Good afternoon. Hi all. I've read https://koha-community.org/manual//latest/en/html/third_party_software.html… on how to set up OCLC service on Koha. My question is how do I add more than 1 person koha account to the configuration file? I got 4 patrons (librarian) to add. Can anyone help me? host: 1.2.3.4port: 8000log: /home/koha/koha-dev/var/log/connexion.logkoha: http://kohastaff.myuniversity.eduuser: koha_generic_staffpassword: passwordmatch: 001overlay_action: replacenomatch_action: create_newitem_action: ignoreimport_mode: direct How should I add another user and password? Can anyone provide an example? I'm using Koha ver 20.11 on debian 10. I highly appreciate your help.

2 1

[koha] Missing bibliographic details.
by muiru james 02 Aug '21

02 Aug '21

Hello team, I recently reinstalled koha 20.05 on Ubuntu 20. I'm running a complete shelflist report with columns biblio.author, biblio.title. However for new items added to the records, columns for author and title are blank. I have tried to use the extractvalue from biblio_metadata and the result is the same. The query is as below: SELECT items.itemcallnumber, items.barcode, biblio.author,biblio.title, biblioitems.publishercode AS ISBN, items.price. >From items LEFT JOIN biblio ON (biblio.biblionumber=items.itemnumber) LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=biblionumber) LEFT JOIN biblio_metadata ON (items.itemnumber=biblio_metadata.biblionumber) Records staged after installation has the details but new items added ti the existing records has only data from the items table- callnumber, barcode and price. During the installation process, i could not install mariadb directly n had to install the mariadbserver10.03 then mariadbclient-10.03 then mariadbserver. I have tried rebuilding zebra and also rebuilding the tables from the rebuildtables.pl without success. Any help will be greatly appreciated. Regards James

1 0

Koha password is forgotten
by Sanjay Uchcharia 02 Aug '21

02 Aug '21

Hello there, I've forgotten my koha password. How to get it back in Ubuntu 20.04. Thankyou. :)

3 3

OCLC Connexion Gateway
by Shafrizan Affendi 02 Aug '21

02 Aug '21

Good afternoon. Hi all. I've read https://koha-community.org/manual//latest/en/html/third_party_software.html… on how to set up OCLC service on Koha. My question is how do I add more than 1 person koha account to the configuration file? I got 4 patrons (librarian) to add. Can anyone help me? host: 1.2.3.4port: 8000log: /home/koha/koha-dev/var/log/connexion.logkoha: http://kohastaff.myuniversity.eduuser: koha_generic_staffpassword: passwordmatch: 001overlay_action: replacenomatch_action: create_newitem_action: ignoreimport_mode: direct How should I add another user and password? Can anyone provide an example? I'm using Koha ver 20.11 on debian 10. I highly appreciate your help.

1 0

Keyword search (2)
by Michael Kuhn 01 Aug '21

01 Aug '21

Hi In our library we are using an unchanged Zebra configuration as coming with Koha 20.11.00. The keyword search is described in https://koha-community.org/manual/20.11/en/html/searching.html#basic-search… There it says: "When a single word is entered, a keyword search is performed. You can check this out by typing one word into the form and note the number of results located. Then, repeat the search with a minor change. In front of the search word, type ‘kw=’ followed by the same search term. The results will be identical." This is NOT TRUE. Instead there is quite a difference. Search for: life * URL: .../search.pl?q=life * 821 results Search for: kw=life * URL: .../search.pl?q=kw%3Dlife * 788 results Does anyone know what is going on here? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 1