[Koha] opac search returned results doesn't show title information
Hi, When I upgraded koha17.11 to 18.11 （unimarc）, the opac search returned results list doesn't show title information,but the intranet search returned results show very well. How to solve this problem? Peter ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Unable to upload "koha-coverflow-plugin-v2.4.25"
Hi Murphy > I am using koha 18.11 running on ubuntu 16.04. I am trying to upload > the plugin file "koha-coverflow-plugin-v2.4.25" and am receiving this > error message "*Cannot unpack file to the plugins directory. Please > verify that the Apache user can write to the plugins directory". * Did you verify the Apache user can write to the plugins directory? (it needs to have a valid user and the needed rights, usually 0755) The plugins directory is "/var/lib/koha//plugins". Hope this ghelps. 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 m...@adminkuhn.ch · W www.adminkuhn.ch ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] OVERDUE FINES FAILED TO INCREMENT
Hi Murphy
> I have set up the global systems preferences as suggested. though
> there is still no overdue charge increment today. the problem here
> is, it is charging overdue fines once but not increasing the charges
> daily. i have also seen an instruction in fineMode that ,the systems
> administrator should schedule: "misc/cronjobs/fines.pl " . i am the
> systems administrator here but don't know how to schedule it. please i
> need an assistance.
About this cronjob: Usually it is active, as far as I know. However
check your file "/etc/cron.daily/koha.common" for an active line like
the following. In Koha 18.11 it looks like this:
koha-foreach --chdir --enabled /usr/share/koha/bin/cronjobs/fines.pl
Of course, to work this needs a running cron daemon.
Also see
* https://koha-community.org/manual/18.11/en/html/cron_jobs.html#fines
By the way: The given path there ("misc/cronjobs/fines.pl") is wrong. In
fact in Koha 18.11 the script is residing in directory
"/usr/share/koha/bin/cronjobs".
Hope this helps.
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 m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Help with SQL report
Hi Christopher,
Do you use the acquisitions module? If not, what MARC field is your
vendor information in?
If you use the acquisitions module, you can try this
SELECT
biblionumber AS ""
FROM
aqorders
LEFT JOIN aqbasket USING (basketno)
LEFT JOIN aqbooksellers ON (aqbasket.booksellerid=aqbooksellers.id)
WHERE aqbooksellers.name LIKE <>
If your vendor information is in a MARC field, you need to change the
table biblioitems in the FROM and JOIN sections to biblio_metadata (as
well as changing the marcxml to metadata). Your query should look like
SELECT CONCAT('href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.biblionumber,'')
AS biblionumber, biblio.title, biblio.author
FROM biblio_metadata
JOIN biblio ON (biblio_metadata.biblionumber = biblio.biblionumber)
WHERE ExtractValue(metadata, "//datafield[@tag=<< Field
(XXX)>>]/subfield[@code=<>]")
LIKE <>
Finally, if you only need a list of biblionumbers for batch delete, you
can remove the superfluous information in the SELECT section :
SELECT biblio.biblionumber AS ""
FROM biblio_metadata
JOIN biblio ON (biblio_metadata.biblionumber = biblio.biblionumber)
WHERE ExtractValue(metadata, "//datafield[@tag=<< Field
(XXX)>>]/subfield[@code=<>]")
LIKE <>
N.B. When I want a list for batch modification/delete, I always put
SELECT biblionumber AS "". That way, you don't have the pesky error
message saying Koha didn't find the biblionumber "biblionumber"...
Good luck!
Caroline Cyr La Rose, M.L.I.S.
Product Manager, inLibro
Le 19-01-24 à 16 h 58, Christopher Davis a écrit :
Greetings Colleagues,
I have been attempting to use the "Biblios with like data in a
subfield of a field" report which is found within the Koha reports
library at
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Biblios_with_like_data_in_a_subfield_of_a_field;
however, no matter what values I input into the report dialog boxes, I
still get a long list of my system's complete holdings instead of a
much shorter list of records from a certain vendor. I did notice that
I needed to change the "marcxml" on line four of the SQL code to
"metadata" or else the report failed to run. What am I doing wrong?
I am just trying to get a list of bibliographic records from a certain
vendor so that I can then feed the record numbers into the Batch
Record Deletion tool. Maybe there's a better report to use than this one?
Many thanks,
*
*
*Christopher Davis, MLS*
Systems & E-Services Librarian
Uintah County Library
204 E 100 N
Vernal, UT 84078
phone: (435) 789-0091 ext. 261
email: cgda...@uintah.utah.gov
web: uintahlibrary.org
catalog: basinlibraries.org
facebook.com/uintahcountylibrary
instagram.com/uintahcountylibrary
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Patron_Self_Registration__Error
Mohan, My guess would be that you need to double-check your PatronSelfRegistrationBorrowerMandatoryField and PatronSelfRegistrationBorrowerUnwantedField system preferences. If you make a field mandatory but then that same field is also listed as an unwanted field in the other preference, that could cause this error. Koha would expect that field to be filled out per the mandatory field setting, but then it does not get displayed on screen for patrons to fill out per the unwanted field setting. I hope that helps! Arturo Longoria Reference Librarian/Web Manager Texas State Law Library www.sll.texas.gov -Original Message- From: Koha On Behalf Of Mohan Kumar K.V. Sent: Thursday, January 24, 2019 21:12 To: Koha Subject: [Koha] Patron_Self_Registration__Error Hi Everybody, Can you please help me to fix below mentioned Koha Patron Self Registration Issue I am using Koha version 17.05, when i tried to submit patron self registration form in OPAC, I am getting below mentioned error. I had made required settings to enable the feature, but still I am getting same error. Error - "you have not filled out all required fields. please fill in missing fields and resubmit." Thank you, Mohan ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Unable to upload "koha-coverflow-plugin-v2.4.25"
Hi, I am using koha 18.11 running on ubuntu 16.04. I am trying to upload the plugin file "koha-coverflow-plugin-v2.4.25" and am receiving this error message "*Cannot unpack file to the plugins directory. Please verify that the Apache user can write to the plugins directory". * Please i need help. Thank you. Murphy Igbudu Systems Librarian University Library and Information Services, Benue State University Makurdi. Nigeria. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
