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)
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,
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
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.
>
>
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