Hi David
You wrote:
> I don't think your database was properly upgraded, and doing these
> manual corrections isn't really going to be enough unless you go line
> by line through the upgrade scripts and figure out all the things that
> were missed.
>
> If you're able to, I would go back and try the upgrade again. If you
> can't... then I would carefully look through every database revision.
I already did try upgrading the Koha 21.11 database again, several
times. With or without changes in the dump. It lead to nothing so
eventually I came up with the "solution" I described because the library
needs the database to work.
> You might also want to consider looking at
> ./misc/maintenance/audit_database.pl as that could save you time.
> (Just don't blindly run the suggestions made by the script. They're
> just hints.)
Thanks for the hint! Unfortunately I didn't find no help page or
documentation for this script... However, I ran the script and there
were some suggestions that I applied. (As far as I see this script is
only available for the database strucjture of Koha 23.11 but not for the
original 21.11)
But for two tables the suggested SQL commands won't work:
ALTER TABLE biblio_metadata CHANGE COLUMN schema schema varchar(16) NOT
NULL;
ALTER TABLE deletedbiblio_metadata CHANGE COLUMN schema schema
varchar(16) NOT NULL;
When trying to apply these commands both give this output:
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right
syntax to use near 'schema schema varchar(16) NOT NULL' at line 1
Do you happen to know what is wrong with these commands? I checked the
syntax ans it seems to be OK according to
https://mariadb.com/kb/en/alter-table/ or
https://dba.stackexchange.com/questions/152387/altering-a-column-null-to-not-null
The current columns "schema" for both tables looks as follows:
| Field | Type | Null | Key | Default | Extra
+--------------+-------------+------+-----+---------------------+------
...
| schema | varchar(16) | YES | | NULL |
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
-----Original Message-----
From: Koha-devel <koha-devel-boun...@lists.koha-community.org> On Behalf Of
Michael Kuhn via Koha-devel
Sent: Saturday, 13 April 2024 9:28 AM
To: k...@lists.katipo.co.nz; Koha-devel <koha-devel@lists.koha-community.org>
Subject: Re: [Koha-devel] [Koha] Error 500 when searching in Koha 23.11.0
Hi
Just for the record: I updated from Koha 21.11.10 to 23.11.04.
When searching the catalogue I got a result list, but when clicking a single hit I got an
error 500. In file "plack-error.log" I found this:
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
execute failed: Unknown column 'issue.renewals_count' in 'field list' at
/usr/share/koha/lib/Koha/Objects.pm line 317
In Koha 21.11 this column was called "issues.renewals" and in Koha 23.11 it should be
called "issues.renewals_count" - but for whatever reason the upgrade did not rename it
properly. I have done that myself:
ALTER TABLE issues RENAME COLUMN renewals TO renewals_count;
Now single hits show up.
PS1: The error message says the column is "issue.renewals_count" but actually it is
"issues.renewals_count".
PS2: https://schema.koha-community.org/23_11/tables/issues.html says the type
of this column is tinyint(3) while it actually is tinyint(4).
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
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/ git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/
