Re: [Koha] SQL help please

Kerrie, Just to be sure that I'm understanding you here ... you wan to list the item if it's held at 'QLD', but *not* if it's held at 'QLD' but also held at another branch? I think this will work: SELECT items.itemnumber, biblio.title, biblio.author, items.itemcallnumber,

Re: [Koha] No patron search results in Koha 16.05.09

Dear Michael and colleagues, I have even modified the patrons system preference to list 5 entries per page. Still the problem persists. I even installed koha version 3.22, and still same problem exists. Anybody else, please help in trying to understand what may be the issue Thanks Anselm O

Re: [Koha] No patron search results in Koha 16.05.09

I had a similar thought to Jonathan. When I've seen patrons not returning in the patron search, it is usually because of corrupt/malformed data in the database. joy On Wed, Apr 12, 2017 at 8:43 AM, Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Anselm, > > You are using a

[Koha] Splitting SQL Reports Library

Some time ago, Brooke started the process of splitting the Koha SQL Reports Library (https://wiki.koha-community.org/wiki/SQL_Reports_Library) into more manageable sections, starting with SQL Reports Holds (https://wiki.koha-community.org/wiki/SQL_Reports_Holds) SQL Reports patrons (

Re: [Koha] No patron search results in Koha 16.05.09

Anselm, You are using a non supported version of Koha, you should try and update it to a more recent one. What you describe can happen if the JSON returned by the server is malformed. To check that, before launching a patron search, open the browser's console (firebug or dev tool) and copy/paste

Re: [Koha] Splitting SQL Reports Library

Salvete! Hope this makes sense. Before I say anything else, I am worried that Hea will become unmanageable in a similar fashion if the Community does not provide authorised value entries for Country, Library Type, et cetera. When I was doing the Koha Users Worldwide stuff it

Re: [Koha] Splitting SQL Reports Library

mmm... Suggestion & breaking news: I wouldn't take too much time on it, because Mana-kb will replace this wiki page, letting libraries search & copy & share reports from Mana-kb The code is written, it works, the patch has to be signed-off:

Re: [Koha] No patron search results in Koha 16.05.09

Thanks Jonathan and Joy. Let me do what you suggest and will update you. But you must be right I am upgrading koha from 3.01 to latest. Something may have gone wrong with database. Your cue is really helpful Thanks. Anselm On Wednesday, April 12, 2017, Joy Nelson

Re: [Koha] Update on Coce cached cover images

Hi Agnes, all, Fantastic news on this front. I had no idea Bywater was doing hosting a Coce instance (very cool, and a big thank you!). We are very happy with our local Coce server; though, as Galen pointed out on his blog, it is another service to monitor in addition to Koha. Not really an

Re: [Koha] SQL help please

Hi Katrin, Again, this is giving me everything at QLD, not items ONLY held at QLD… I’m sure there must be a way to do it… Thanks, Kerrie Stevens From: Katrin Fischer [mailto:katrin.fischer...@web.de] Sent: Wednesday, April 12, 2017 5:27 PM To: Kerrie Stevens Cc:

[Koha] Update on Coce cached cover images

Hello Koha users I'm writing to let you know about a feature I have been testing - cover images from a Coce server hosted by Bywater. The ability to use Coce has been in Koha since 3.20 but required setup of a server to make it work. Recently, Bywater offered a hosted Coce server for anyone to

Re: [Koha] SQL help please

Hi Kerry, you are right, I think this one should be better: SELECT i.itemnumber, i.biblionumber, b.title, b.author, i.itemcallnumber, i.barcode, i.homebranch FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) WHERE homebranch = "QLD" AND i.biblionumber not in (select distinct

Re: [Koha] SQL help please

That’s right – I want items only held at QLD, bot Qld and another campus. When I run the report you’ve provided, I get the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM items

Re: [Koha] Publisher Authority Type

Hi all, I had reached out to all of you in this forum for help in setting up authority type for Publisher. Later, based on inputs from some of you(thanks Indranil and Heather) we decided not to set up Authority Type. Recently we came across the below article and decided to use auto complete for

Re: [Koha] Error : Undefined subroutine CGI

Hi All, I am very glad to inform you that, we have successfully integrated KOHA with MariaDB in our new server. In new server we couldn't find any 'Undefined subroutine CGI' error. We can login into MariaDB through putty with DB username and password.But when we try to login into phpmyadmin it