Re: [Koha-devel] Can't call method "biblioitemnumber" on an undefined value

2025-03-05 Thread David Schmidt via Koha-devel
https://github.com/Koha-Community/Koha/blob/24.05.x/misc/maintenance/search_for_data_inconsistencies.pl#L152 probably that the biblio in question doesnt have a biblioitem associated. if thats the cause an extra step could be introduced that prevents calling biblio->biblioitem->biblioitemnumber i

Re: [Koha-devel] [Koha] Error 500 when searching in Koha 23.11.0

2024-04-15 Thread David Schmidt via Koha-devel
hmm im surprised the column/table names are not quoted. the SQL seems to be the output of https://github.com/Koha-Community/Koha/blob/master/misc/maintenance/audit_database.pl#L24 and the default for using quote_identifiers is true. (https://metacpan.org/pod/SQL::Translator#quote_identifiers)

Re: [Koha-devel] [Koha] Error 500 when searching in Koha 23.11.0

2024-04-15 Thread David Schmidt via Koha-devel
could it be that "schema" is a reserved word and it has to be quoted? looks like it -> https://mariadb.com/kb/en/reserved-words/ https://stackoverflow.com/questions/2889871/how-do-i-escape-reserved-words-used-as-column-names-mysql-create-table cheers david On Mon, 15 Apr 2024, at 9:40 AM, Micha

Re: [Koha-devel] Elasticsearch sans Zebra

2024-03-25 Thread David Schmidt via Koha-devel
Hi David the majority of our Koha installations use Elastiscearch and we have a process that deactivates zebra but we would love to see the change you proposed. I vaguely remember a bug where not having zebra running caused a problem (with background jobs i think) even if ES is in charge of ind

Re: [Koha-devel] 22.11.12 having package dependency problems?

2024-01-23 Thread David Schmidt via Koha-devel
We noticed the same issue on different servers yesterday. On Wed, 24 Jan 2024, at 6:59 AM, David Cook via Koha-devel wrote: > I help out a few libraries running 22.11 straight from the community, and two > libraries lately have had Koha go down during automatic upgrades to > 22.11.12-1. > > ko

Re: [Koha-devel] Elasticsearch issue in koha v22.05.06

2023-10-23 Thread David Schmidt via Koha-devel
which ES perl client is installed? the newest version that still works with ES7 (which we are using) is https://metacpan.org/release/EZIMUEL/Search-Elasticsearch-7.717/view/lib/Search/Elasticsearch.pm check currently installed version `perl -MSearch::Elasticsearch\ Search::Elasticsearch ve

Re: [Koha-devel] koha-testing-docker startup gotcha...

2023-02-22 Thread David Schmidt
what I like to do to always have matching UIDs ## ## # Dockerfile ARG CONTAINER_UID=1000 RUN useradd --create-home --home-dir /home/hks3 \ --uid $CONTAINER_UID --user-group --shell /bin/bash hks3 # building container docker-compose build --build-arg CONTAINER_UID=`id

Re: [Koha-devel] The many failings of background_jobs_worker.pl

2022-12-21 Thread David Schmidt
jup, the JSON bug hit us too we also encountered some problems regarding rabbitmq/workers debugging wasn't straigthforward because I had a hard time to find meaningful debug output. luckily the folks on IRC were very helpful as usual. the latest bug (not sure if it is a bug as of yet) was that

Re: [Koha-devel] Koha 22.05.04: Can't locate Koha/Script.pm in @INC

2022-10-28 Thread David Schmidt
lkmarcimport.pl" (and I do this a lot). > > 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

Re: [Koha-devel] Koha 22.05.04: Can't locate Koha/Script.pm in @INC

2022-10-28 Thread David Schmidt
hi add that path to your PERL5LIB env var $ export PERL5LIB=/usr/share/koha/lib $ /usr/share/koha/bin/migration_tools/bulkmarcimport.pl -b -m marcxml -framework=ABC -file TITEL.marcxml -v 2 cheers david On Fri, 28 Oct 2022, at 1:02 PM, Michael Kuhn wrote: > Hi > > I am running a fresh install

Re: [Koha-devel] koha-create with remote mariadb server

2022-09-30 Thread David Schmidt
.org"$/DOMAIN=".koha-support.eu"/' /etc/koha/koha-sites.conf sed -i -e 's/^OPACSUFFIX=""$/OPACSUFFIX="-opac"/' /etc/koha/koha-sites.conf #instance:username:password:dbname:dbhost echo "koha-demo:koha_demo:kohadbpw:koha_demo:mariadb" > koha_db_passwdfile.txt koha-crea

[Koha-devel] koha-create with remote mariadb server

2022-09-29 Thread David Schmidt
im trying to create a koha instance configured for a remote mariadb server https://wiki.koha-community.org/wiki/Debian#Create_a_Koha_instance > remove /etc/mysql/koha-common.cnf > create a new file in its place containing the connection information for the server, in the form of

Re: [Koha-devel] custom core patches management

2021-11-11 Thread David Schmidt
packages and use the official koha git checkout directly and maintain branches for each koha instance. if anyone is interested in the perl script I wrote let me know. cheers david On Tue, 2 Nov 2021, at 11:00 AM, David Schmidt wrote: > Hello koha community, > > We made some changes to

[Koha-devel] custom core patches management

2021-11-02 Thread David Schmidt
Hello koha community, We made some changes to our Koha instance and are now looking for a mechanism to apply them to a new installation. - some of the changes are simply new files, thats easy. - some changes were possible to put into plugins or use existing hooks. but how do you deal with chang

[Koha-devel] bulkmarcimport.pl ... re-import/update existing records

2021-04-22 Thread David Schmidt
Hello koha folks, ### I hope this is the correct list for this kind of email ### We are currently exporting about 500k recods from a dabis system into a new koha installation. the export file (MARCXML) goes through some transformations using catmandu. I imported the first 25k records using th