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 <[email protected] <mailto:[email protected]>> 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-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>
     > [email protected] <mailto:[email protected]>
     > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
    <https://lists.katipo.co.nz/mailman/listinfo/koha>

    --     Fridolin SOMERS <[email protected]
    <mailto:[email protected]>>
    Software and system maintainer 🦄
    BibLibre, France
    _______________________________________________

    Koha mailing list http://koha-community.org <http://koha-community.org>
    [email protected] <mailto:[email protected]>
    Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
    <https://lists.katipo.co.nz/mailman/listinfo/koha>



--
Fridolin SOMERS <[email protected]>
Software and system maintainer 🦄
BibLibre, France
_______________________________________________

Koha mailing list  http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to