[Koha-bugs] [Bug 30899] Upgrade sometimes fails at "Upgrade to 21.11.05.004"

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30899

--- Comment #8 from Fridolin Somers <fridolin.somers at biblibre.com> ---
(In reply to Magnus Enger from comment #1)
> Looks like the problem is on line 11 of
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/db_revs/211105004.pl:
> 
>  10         if( foreign_key_exists('borrower_attribute_types',
> 'category_code_fk') ) {
>  11             $dbh->do( q|ALTER TABLE borrower_attribute_types DROP
> CONSTRAINT category_code_fk| );
>  12             if( index_exists('borrower_attribute_types',
> 'category_code_fk') ) {
>  13                 $dbh->do( q|ALTER TABLE borrower_attribute_types DROP
> INDEX category_code_fk| );
>  14             }
>  15         }

Ahhh, the syntax is not :
  DROP CONSTRAINT category_code_fk
it is :
  DROP FOREIGN KEY category_code_fk

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.