Re: [Koha] Edit OPACBLOCK after upgrading to 21.11
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>> 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> 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-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> > 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 <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
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.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> 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-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> > 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 <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
participants (1)
-
Fridolin SOMERS