web installer appears on upgrade
Hi, I am looking for help. With a regular upgrade of the package in Ubuntu 22.04 using apt, there was a problem running the upgrade script because of a second instance installed and running. I removed that instance, and the upgrade script completed successfully. However, after the upgrade and before and after I removed that second instance, my main Koha instance started showing the maintenance mode message on the OPAC (complete with our header image, suggesting that it is connected to the database). I thought I would check the staff client, but that shows the web installer with this message: Welcome to the Koha 22.11 web installer Before we begin, please verify you have the correct credentials to continue. Please log in with the username and password given to you by your systems administrator and located in your|koha-conf.xml|configuration file. That's not normal behavior, right? I double checked the configuration file to make sure the right database, user, and password were there. Anyway, I cannot take it out of maintenance mode. Can anyone point me in the right direction for solving this? the Koha version is 22.11.07-2. Thanks, Daniel
Hi, in our case, when this occurs, the solution is usually to restart the memcached and then perform koha-upgrade-schema <instance>. Hope this helps. Best regards, Anke -- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns@gwdg.de ------------------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg@gwdg.de Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 ------------------------------------------------- Zertifiziert nach ISO 9001 und ISO 27001 -------------------------------------------------
-----Ursprüngliche Nachricht----- Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von Daniel Owens Gesendet: Dienstag, 11. Juli 2023 17:06 An: Discussion Group Koha <koha@lists.katipo.co.nz> Betreff: [Koha] web installer appears on upgrade
Hi, I am looking for help.
With a regular upgrade of the package in Ubuntu 22.04 using apt, there was a problem running the upgrade script because of a second instance installed and running. I removed that instance, and the upgrade script completed successfully.
However, after the upgrade and before and after I removed that second instance, my main Koha instance started showing the maintenance mode message on the OPAC (complete with our header image, suggesting that it is connected to the database). I thought I would check the staff client, but that shows the web installer with this message:
Welcome to the Koha 22.11 web installer
Before we begin, please verify you have the correct credentials to continue. Please log in with the username and password given to you by your systems administrator and located in your|koha-conf.xml|configuration file.
That's not normal behavior, right? I double checked the configuration file to make sure the right database, user, and password were there.
Anyway, I cannot take it out of maintenance mode. Can anyone point me in the right direction for solving this? the Koha version is 22.11.07-2.
Thanks, Daniel _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
This worked the last time I had the problem, but with the latest upgrade I got the web installer again. After running: $ sudo service memcached restart $ sudo koha-upgrade-schema hbc Upgrading database schema for hbc Upgrade to 22.11.07.003 [14:01:47]: Bug 34029 - Extend datatypes in biblioitems and deletedbiblioitems tables to avoid import errors Updated biblioitems.place to text Updated deletedbiblioitems.place to text ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column 'publishercode' used in key specification without a key length at /usr/share/koha/lib/C4/Installer.pm line 741 Can anyone give me a pointer about where to go from here? Daniel On 7/11/23 10:18 AM, Bruns, Anke wrote:
Hi,
in our case, when this occurs, the solution is usually to restart the memcached and then perform koha-upgrade-schema <instance>.
Hope this helps.
Best regards, Anke
On 22.11.x index on publishercode seems OK : KEY `publishercode` (`publishercode`(191)), The size on index has been added by : Bug 18336: Convert schema from utf8 to utf8mb4 I've look at old databases, the index is OK. Please open a bug report. Best regards Le 10/08/2023 à 04:43, Daniel Owens a écrit :
This worked the last time I had the problem, but with the latest upgrade I got the web installer again. After running:
$ sudo service memcached restart $ sudo koha-upgrade-schema hbc
Upgrading database schema for hbc Upgrade to 22.11.07.003 [14:01:47]: Bug 34029 - Extend datatypes in biblioitems and deletedbiblioitems tables to avoid import errors Updated biblioitems.place to text Updated deletedbiblioitems.place to text ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column 'publishercode' used in key specification without a key length at /usr/share/koha/lib/C4/Installer.pm line 741
Can anyone give me a pointer about where to go from here?
Daniel
On 7/11/23 10:18 AM, Bruns, Anke wrote:
Hi,
in our case, when this occurs, the solution is usually to restart the memcached and then perform koha-upgrade-schema <instance>.
Hope this helps.
Best regards, Anke
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France
Okay, will do. Thanks. On 8/10/23 4:09 PM, Fridolin SOMERS wrote:
On 22.11.x index on publishercode seems OK : KEY `publishercode` (`publishercode`(191)),
The size on index has been added by : Bug 18336: Convert schema from utf8 to utf8mb4
I've look at old databases, the index is OK.
Please open a bug report.
Best regards
Le 10/08/2023 à 04:43, Daniel Owens a écrit :
This worked the last time I had the problem, but with the latest upgrade I got the web installer again. After running:
$ sudo service memcached restart $ sudo koha-upgrade-schema hbc
Upgrading database schema for hbc Upgrade to 22.11.07.003 [14:01:47]: Bug 34029 - Extend datatypes in biblioitems and deletedbiblioitems tables to avoid import errors Updated biblioitems.place to text Updated deletedbiblioitems.place to text ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column 'publishercode' used in key specification without a key length at /usr/share/koha/lib/C4/Installer.pm line 741
Can anyone give me a pointer about where to go from here?
Daniel
On 7/11/23 10:18 AM, Bruns, Anke wrote:
Hi,
in our case, when this occurs, the solution is usually to restart the memcached and then perform koha-upgrade-schema <instance>.
Hope this helps.
Best regards, Anke
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
I opened a bug report, but I imagine it will take awhile before this is fixed. Is there any documentation about how to downgrade on Linux (Ubuntu)? I do have a backup. Daniel On 8/10/23 4:09 PM, Fridolin SOMERS wrote:
On 22.11.x index on publishercode seems OK : KEY `publishercode` (`publishercode`(191)),
The size on index has been added by : Bug 18336: Convert schema from utf8 to utf8mb4
I've look at old databases, the index is OK.
Please open a bug report.
Best regards
Le 10/08/2023 à 04:43, Daniel Owens a écrit :
This worked the last time I had the problem, but with the latest upgrade I got the web installer again. After running:
$ sudo service memcached restart $ sudo koha-upgrade-schema hbc
Upgrading database schema for hbc Upgrade to 22.11.07.003 [14:01:47]: Bug 34029 - Extend datatypes in biblioitems and deletedbiblioitems tables to avoid import errors Updated biblioitems.place to text Updated deletedbiblioitems.place to text ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column 'publishercode' used in key specification without a key length at /usr/share/koha/lib/C4/Installer.pm line 741
Can anyone give me a pointer about where to go from here?
Daniel
On 7/11/23 10:18 AM, Bruns, Anke wrote:
Hi,
in our case, when this occurs, the solution is usually to restart the memcached and then perform koha-upgrade-schema <instance>.
Hope this helps.
Best regards, Anke
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Daniel, I think this got lost when we had a bit of trouble with the mailing list. Were you able to resolve your issue? While we are working on the fix, the workaround suggested on the bug might help you to finish the update: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34516#c2 Katrin On 14.08.23 23:44, Daniel Owens wrote:
I opened a bug report, but I imagine it will take awhile before this is fixed. Is there any documentation about how to downgrade on Linux (Ubuntu)? I do have a backup.
Daniel
On 8/10/23 4:09 PM, Fridolin SOMERS wrote:
On 22.11.x index on publishercode seems OK : KEY `publishercode` (`publishercode`(191)),
The size on index has been added by : Bug 18336: Convert schema from utf8 to utf8mb4
I've look at old databases, the index is OK.
Please open a bug report.
Best regards
Le 10/08/2023 à 04:43, Daniel Owens a écrit :
This worked the last time I had the problem, but with the latest upgrade I got the web installer again. After running:
$ sudo service memcached restart $ sudo koha-upgrade-schema hbc
Upgrading database schema for hbc Upgrade to 22.11.07.003 [14:01:47]: Bug 34029 - Extend datatypes in biblioitems and deletedbiblioitems tables to avoid import errors Updated biblioitems.place to text Updated deletedbiblioitems.place to text ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column 'publishercode' used in key specification without a key length at /usr/share/koha/lib/C4/Installer.pm line 741
Can anyone give me a pointer about where to go from here?
Daniel
On 7/11/23 10:18 AM, Bruns, Anke wrote:
Hi,
in our case, when this occurs, the solution is usually to restart the memcached and then perform koha-upgrade-schema <instance>.
Hope this helps.
Best regards, Anke
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Bruns, Anke -
Daniel Owens -
Fridolin SOMERS -
Katrin Fischer