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 < vbovictor@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.somers@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,
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.somers@biblibre.com <mailto:fridolin.somers@biblibre.com>> escreveu:
Strange, the DBRev SQL looks OK :
$dbh->do(q{ ALTER TABLE recalls CHANGE COLUMN borrowernumber
Le 10/06/2022 à 00:31, Victor Barroso Oliveira a écrit : 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.somers@biblibre.com <mailto:fridolin.somers@biblibre.com> <mailto:fridolin.somers@biblibre.com <mailto:fridolin.somers@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-customizatio...
<
https://koha-community.org/manual/21.11/en/html/tools.html#html-customizatio...
>> >> >> <
https://koha-community.org/manual/21.11/en/html/tools.html#html-customizatio...
<
https://koha-community.org/manual/21.11/en/html/tools.html#html-customizatio...
>> >> >> 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.somers@biblibre.com <mailto:fridolin.somers@biblibre.com> >> <mailto:fridolin.somers@biblibre.com <mailto:fridolin.somers@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.somers@biblibre.com <mailto:fridolin.somers@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.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France