[Koha] 3M self check error information with “Account” option

In one of the options on 3M self check, I can set to display Account information. Under the Account option, when I tried to list my loan record, there’s an error message referring me to the counter for help. Thanks & regards, Peter Lau Librarian Tel: (852) 3977 9868 | Email: peter@yccece.ed

Re: [Koha] OPAC research does not work

Hi David, I didn't notice if someone already answered you. You need to build your search indexes before being able to find anything in the OPAC. Do you have access to your server? If you use Zebra (you probably do, but just to make sure, check the system preference SearchEngine in Administr

Re: [Koha] Report for items held by 2 out of 3 branches

Hi, All -- Think the version below should do what we're looking for. (Thank you, Barton!) All best, Cab Vinton SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title, i.homebranch, i.itemcallnumber FROM items i LEFT JOIN biblioitems m USING (biblioit

Re: [Koha] Koha 18.05.09 released

Hi Jesse and Lucas > The Koha community is proud to announce the release of 18.05.09. > > This is a maintenance release and contains many bugfixes and > enhancements. > > It includes 3 enhancements, 62 bugfixes. > > As always you can download the release from here: > > http://download.koha-commun

Re: [Koha] Error restoring Koha-Instance

Hi It said there is a Unknown column 'me.damaged_on' ... this usually means that your DB schema has changed. Probably when updated/upgarded your koha install. There is a koha command to upgrade the schema but I don't know if that will solve the issue on a restore. Regards Alvaro |--

[Koha] OPAC research does not work

Hello, I'm having problems configuring Koha. I've uselessly tried solving the issue on my own and also browsing forums. After the install I started cataloging, inserting titles and texts. However once inserted for some reason they don't appear in the OPAC. I can't figure out what I'm doing wrong

Re: [Koha] Report for items held by 2 out of 3 branches

Good point, I removed that logic. SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title, i.homebranch, i.itemcallnumber FROM items i LEFT JOIN biblioitems m USING (biblioitemnumber) LEFT JOIN biblio b ON i.biblionumber = b.biblionumber WHERE i.

[Koha] Error restoring Koha-Instance

Hi all I try to restore a koha-instance wiht koha-restore and I get the following messages: error retrieving biblio 1669 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680. DBD::mysql::st execute failed: Unknown column 'me.damaged_on' in 'field list' [for Statement "SELECT `me`.`ite

Re: [Koha] Report for items held by 2 out of 3 branches

Unless I'm missing the thread somehow, I don't think that will work as the prior conditions for all 3 branches are still present in the WHERE statement. If we eliminate those, then we still need to include the acquisition date condition somehow. Thanks, Cab On Fri, Feb 22, 2019 at 11:11 AM Bar

Re: [Koha] Koha 18.05.09 released

+1 On Fri, Feb 22, 2019 at 9:29 AM Tomas Cohen Arazi wrote: > Great! > > El vie., 22 feb. 2019 a las 11:27, Jesse Maseto (< > je...@bywatersolutions.com>) > escribió: > > > The Koha community is proud to announce the release of 18.05.09. > > > > This is a maintenance release and contains many bu

Re: [Koha] Report for items held by 2 out of 3 branches

you could add count(distinct homebranch) > 1 to your HAVING statement On Fri, Feb 22, 2019 at 9:03 AM Cab Vinton wrote: > Hi, All -- > > We have a report (see below) that generates a random list of items > held by all 3 of our branches & purchased within the past 30 days. > > To generate more

Re: [Koha] Koha 18.05.09 released

Great! El vie., 22 feb. 2019 a las 11:27, Jesse Maseto () escribió: > The Koha community is proud to announce the release of 18.05.09. > > This is a maintenance release and contains many bugfixes and enhancements. > > It includes 3 enhancements, 62 bugfixes. > > As always you can download the rel

[Koha] Koha 18.05.09 released

The Koha community is proud to announce the release of 18.05.09. This is a maintenance release and contains many bugfixes and enhancements. It includes 3 enhancements, 62 bugfixes. As always you can download the release from here: http://download.koha-community.org/koha-18.05.09.tar.gz Thank yo

[Koha] Report for items held by 2 out of 3 branches

Hi, All -- We have a report (see below) that generates a random list of items held by all 3 of our branches & purchased within the past 30 days. To generate more titles we'd like to loosen the criteria by specifying that the titles should be held by just 2 of the 3 branches. I know how I'd appro

[Koha] Koha 18.11.03 release

The Koha community is proud to announce the release of Koha 18.11.03. This is a maintenance release. The full release notes are available at https://koha-community.org/koha-18-11-03-release/ Debian packages will be uploaded in a few days. Best regards and thanks to all those who have contribute

Re: [Koha] z39.50 search does not return results

Hi Hauke, ich hatte das gleiche Problem zweimal in der Vergangenheit und ebenfalls keine Hinweise auf Fehlermeldungen in den Logfiles. Ich vermute jetzt auch noch irgendein Rechteproblem oder eine Inkosistenz durch ein Softwareupdate im Perl-Umfeld. Versuche mal, ob eine "händische Suche" per

[Koha] z39.50 search does not return results

Hey there, I have another issue after moving Koha to a new server: The Z39.50/SRU search is no longer returning results (/cgi-bin/koha/cataloguing/z3950_search.pl). Settings are the same as on the old system, where everything works fine. There are no indications of errors in the logs. Can anyone