[Koha] Koha Community Newsletter: May 2020

The Koha Community Newsletter for May 2020 is here: https://koha-community.org/koha-community-newsletter-may-2020/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. -- Chad Roseburg Editor,

Re: [Koha] Barcode as a link report

Hi, you have 2 tables in your query that both have a biblionumber column: items and biblio. So in your query, you need to specifiy which table is meant by adding the name of the table it should use: SELECT CONCAT('', itemnumber, '' ) AS

[Koha] Barcode as a link report

Hello Mark, Following up on this query, this is the whole SQL query SELECT CONCAT('', itemnumber, '' ) AS itemnumber,items.itemcallnumber,items.barcode,biblio.author,biblio.title,items.price FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN

Re: [Koha] Seeking advise

Dear Tadesse I had to do this once and from my experience I would go for 2 Clean install of new version and just handle the data IF the data is „clean“ MARC (no special use of fields for „special purposes“ as libraries do :-) This is done in one day IF certain „adaptions“ where made the two

Re: [Koha] Koha slows and searches fail

Thanks for your help, For the big issue: DBI connect failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused") at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1517. I took a look at processes running and opac_search.pl (can't remember

[Koha] Seeking advise

Hello, Two of our sister institutes are thinking about merging two instances of Koha into one (joined catalog with a single instance of Koha running on a single database) with external expert help. Right now, the two systems are running on two separate VMs and old versions of Koha (3.8 and