Hello, With your support I was able to reset the database of most instances. As per the routine below. Thanks.
However, one of the instances presented a different error when restarting the database. Upgrade to 21.12.00.013 [19:25:20]: Bug 29605 - Resync DB structure for existing installations ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'ar' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 739 What would be the instruction to make the above error? -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- After updating to version 22.05 all bases present the installation screen on koha. When I update the database, I get the following error. Upgrade to 21.12.00.048 [21:43:30]: Bug 30291 - Renaming recalls table columns ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot drop index 'borrowernumber': needed in a foreign key constraint at /usr/share/koha/lib/C4/Installer.pm line 739 Solution mysql >USE database; mysql >SET foreign_key_checks = 0; mysql > ALTER TABLE recalls CHANGE COLUMN borrowernumber patron_id int(11) NOT NULL DEFAULT 0; koha-upgrade-schema library Upgrade to 21.12.00.048 [18:55:35]: Bug 30291 - Renaming recalls table columns Upgrade to 21.12.00.049 [18:55:35]: Bug 30563 - Add system preference RequireCashRegister Upgrade to 21.12.00.050 [18:55:35]: Bug 29924 - Add password expiration Added password_expiry_days to categories Added password_expiration_date field to borrowers Added password_expiration_date field to borrowers Upgrade to 21.12.00.051 [18:55:35]: Bug 29925 - Add password reset option Upgrade to 21.12.00.052 [18:55:35]: Bug 30290 - Modify AR notices, include TOC line WARNING: If you have translated AR notices, please add TOC lines yourself. Upgrade to 21.12.00.053 [18:55:35]: Bug 30611 - Add STAFF_PASSWORD_RESET notice Upgrade to 21.12.00.054 [18:55:35]: Bug 23352 - Adding new column 'subscription.ccode' Upgrade to 21.12.00.055 [18:55:35]: Bug 13412 - Add GenerateAuthorityField667 and GenerateAuthorityField670 system preferences Upgrade to 21.12.00.056 [18:55:35]: Bug 30728 - Allow opting out of real-time holds queue updating possible Upgrade to 21.12.00.057 [18:55:35]: Bug 30852 - Add index to article_requests.debit_id Upgrade to 22.05.00.000 [18:55:35]: Koha 22.05.00 release Em sáb., 11 de jun. de 2022 às 14:15, Victor Barroso Oliveira < vbovic...@gmail.com> escreveu: > after running > the following message appears > ALTER TABLE recalls CHANGE COLUMN borrowernumber patron_id int(11) NOT > NULL DEFAULT 0; > ERROR 1553 (HY000): Cannot drop index 'borrowernumber': needed in a > foreign key constraint > > > Em sex., 10 de jun. de 2022 às 17:56, Fridolin SOMERS < > fridolin.som...@biblibre.com> escreveu: > >> Hi, >> >> Sorry I cant see where the problem is. >> >> Please onpen a report on >> https://bugs.koha-community.org/bugzilla3/enter_bug.cgi?product=Koha >> >> Best regards, >> >> Le 10/06/2022 à 00:31, Victor Barroso Oliveira a écrit : >> > Ubuntu 20.04.4 LTS >> > mysql Ver 15.1 Distrib 10.4.14-MariaDB, for debian-linux-gnu (x86_64) >> > using readline 5.2 >> > >> > This command did not work in Mariadb >> > $dbh->do(q{ ALTER TABLE recalls CHANGE COLUMN borrowernumber patron_id >> > int(11) NOT NULL DEFAULT 0 }); >> > >> > Em sex., 10 de jun. de 2022 às 04:01, Fridolin SOMERS >> > <fridolin.som...@biblibre.com <mailto:fridolin.som...@biblibre.com>> >> > escreveu: >> > >> > Strange, the DBRev SQL looks OK : >> > >> > $dbh->do(q{ ALTER TABLE recalls CHANGE COLUMN borrowernumber >> patron_id >> > int(11) NOT NULL DEFAULT 0 }); >> > >> > What version of MySQL/MariaDB and OS ? >> > >> > Le 09/06/2022 à 20:55, Fridolin SOMERS a écrit : >> > > Hi Victor, please always reply to the list ;) >> > > >> > > Le 09/06/2022 à 14:51, Victor Barroso Oliveira a écrit : >> > >> >> > >> After updating to version 22.05 all bases present the >> installation >> > >> screen on koha. >> > >> When I update the database, I get the following error. >> > >> Upgrade to 21.12.00.048 [21:43:30]: Bug 30291 - Renaming >> recalls >> > >> table columns >> > >> ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: >> Cannot >> > >> drop index 'borrowernumber': needed in a foreign key constraint >> at >> > >> /usr/share/koha/lib/C4/Installer.pm line 739 >> > >> >> > >> how can i solve this? >> > >> >> > >> Em qui., 9 de jun. de 2022 às 18:02, Fridolin SOMERS >> > >> <fridolin.som...@biblibre.com >> > <mailto:fridolin.som...@biblibre.com> >> > <mailto:fridolin.som...@biblibre.com >> > <mailto:fridolin.som...@biblibre.com>>> >> > >> escreveu: >> > >> >> > >> Hi, >> > >> >> > >> You mean OpacMainUserBlock, changed by : >> > >> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23794 >> > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23794> >> > >> >> > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23794 >> > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23794>> >> > >> Convert OpacMainUserBlock system preference to news block >> > >> >> > >> See the manual : >> > >> >> > >> >> > >> https://koha-community.org/manual/21.11/en/html/tools.html#html-customizations >> > < >> https://koha-community.org/manual/21.11/en/html/tools.html#html-customizations >> > >> > >> > >> >> > >> >> > >> >> > < >> https://koha-community.org/manual/21.11/en/html/tools.html#html-customizations >> > < >> https://koha-community.org/manual/21.11/en/html/tools.html#html-customizations >> >> >> > >> > >> >> > >> >> > >> Best regards, >> > >> >> > >> Le 09/06/2022 à 02:09, Victor Barroso Oliveira a écrit : >> > >> > Good Morning, >> > >> > I'm not able to edit OPACBLOCK after upgrading to 21.11 >> > >> > What would be the procedure to edit the block again? >> > >> > Thanks, >> > >> > _______________________________________________ >> > >> > >> > >> > Koha mailing list http://koha-community.org >> > <http://koha-community.org> >> > >> <http://koha-community.org <http://koha-community.org>> >> > >> > Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> >> > <mailto:Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>> >> > >> > Unsubscribe: >> > https://lists.katipo.co.nz/mailman/listinfo/koha >> > <https://lists.katipo.co.nz/mailman/listinfo/koha> >> > >> <https://lists.katipo.co.nz/mailman/listinfo/koha >> > <https://lists.katipo.co.nz/mailman/listinfo/koha>> >> > >> >> > >> -- Fridolin SOMERS <fridolin.som...@biblibre.com >> > <mailto:fridolin.som...@biblibre.com> >> > >> <mailto:fridolin.som...@biblibre.com >> > <mailto:fridolin.som...@biblibre.com>>> >> > >> Software and system maintainer 🦄 >> > >> BibLibre, France >> > >> _______________________________________________ >> > >> >> > >> Koha mailing list http://koha-community.org >> > <http://koha-community.org> >> > >> <http://koha-community.org <http://koha-community.org>> >> > >> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> >> > <mailto:Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>> >> > >> Unsubscribe: >> > https://lists.katipo.co.nz/mailman/listinfo/koha >> > <https://lists.katipo.co.nz/mailman/listinfo/koha> >> > >> <https://lists.katipo.co.nz/mailman/listinfo/koha >> > <https://lists.katipo.co.nz/mailman/listinfo/koha>> >> > >> >> > > >> > >> > -- >> > Fridolin SOMERS <fridolin.som...@biblibre.com >> > <mailto:fridolin.som...@biblibre.com>> >> > Software and system maintainer 🦄 >> > BibLibre, France >> > _______________________________________________ >> > >> > Koha mailing list http://koha-community.org < >> http://koha-community.org> >> > Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> >> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > <https://lists.katipo.co.nz/mailman/listinfo/koha> >> > >> >> -- >> Fridolin SOMERS <fridolin.som...@biblibre.com> >> Software and system maintainer 🦄 >> BibLibre, France >> > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha