[Koha] Edit OPACBLOCK after upgrading to 21.11

[Fridolin SOMERS]

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 at biblibre.com <mailto:fridolin.somers at 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-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>
>>      > Koha at lists.katipo.co.nz <mailto:Koha at 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 at biblibre.com
>>     <mailto:fridolin.somers at biblibre.com>>
>>     Software and system maintainer 🦄
>>     BibLibre, France
>>     _______________________________________________
>>
>>     Koha mailing list http://koha-community.org 
>> <http://koha-community.org>
>>     Koha at lists.katipo.co.nz <mailto:Koha at 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 at biblibre.com>
Software and system maintainer 🦄
BibLibre, France