[Koha-bugs] [Bug 22445] Ability to define a URL for custom cover images

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

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

Joonas Kylmälä <joonas.kylmala at helsinki.fi> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |joonas.kylmala at helsinki.fi

--- Comment #119 from Joonas Kylmälä <joonas.kylmala at helsinki.fi> ---
The database upgrade breaks on my kohadevbox setup (mysql-server package
version 5.7.27-0ubuntu0.18.04.1):

> $ updatedatabase 
> Upgrade to 19.06.00.042 done (Bug 22445 - Add new pref *CustomCoverImages*)
> DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE accountlines
>                 ADD
>                   debit_type_code ' at line 1 [for Statement "
>                 ALTER IGNORE TABLE accountlines
>                 ADD
>                   debit_type_code varchar(80) DEFAULT NULL
>                 AFTER
>                   accounttype
>               "] at /home/koha/kohaclone/installer/data/mysql/updatedatabase.pl line 19888.
> DBD::mysql::db do failed: Key column 'debit_type_code' doesn't exist in table [for Statement "
>             ALTER TABLE accountlines ADD CONSTRAINT `accountlines_ibfk_debit_type` FOREIGN KEY (`debit_type_code`) REFERENCES `account_debit_types` (`code`) ON DELETE RESTRICT ON UPDATE CASCADE
>               "] at /home/koha/kohaclone/installer/data/mysql/updatedatabase.pl line 19901.
> DBD::mysql::db do failed: Unknown column 'debit_type_code' in 'field list' [for Statement "
>         UPDATE accountlines SET debit_type_code = accounttype, accounttype = NULL WHERE accounttype IN (SELECT code from account_debit_types)
>         "] at /home/koha/kohaclone/installer/data/mysql/updatedatabase.pl line 19910.
> Upgrade to 19.06.00.043 done (Bug 23049 - Add account debit_types)
> DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE accountlines
>                 ADD
>                   credit_type_code' at line 1 [for Statement "
>                 ALTER IGNORE TABLE accountlines
>                 ADD
>                   credit_type_code varchar(80) DEFAULT NULL
>                 AFTER
>                   accounttype
>               "] at /home/koha/kohaclone/installer/data/mysql/updatedatabase.pl line 19992.
> DBD::mysql::db do failed: Key column 'credit_type_code' doesn't exist in table [for Statement "
>                 ALTER TABLE accountlines
>                 ADD CONSTRAINT
>                   `accountlines_ibfk_credit_type`
>                 FOREIGN KEY (`credit_type_code`) REFERENCES `account_credit_types` (`code`)
>                 ON DELETE RESTRICT
>                 ON UPDATE CASCADE
>               "] at /home/koha/kohaclone/installer/data/mysql/updatedatabase.pl line 20005.
> DBD::mysql::db do failed: Unknown column 'credit_type_code' in 'field list' [for Statement "
>           UPDATE
>             accountlines 
>           SET
>             credit_type_code = accounttype, accounttype = NULL
>           WHERE accounttype IN (SELECT code from account_credit_types)
>         "] at /home/koha/kohaclone/installer/data/mysql/updatedatabase.pl line 20067.
> Upgrade to 19.06.00.044 done (Bug 23805 - Add account credit_types)
> Upgrade to 19.06.00.045 done (Bug 23866 - Set HEA syspref to prompt for review)
> Upgrade to 19.06.00.046 done (Bug 15260 - Option for extended loan with useDaysMode)
> Upgrade to 19.06.00.047 done (Bug 14697 - Extend and enhance 'Claims returned' lost status)
> Upgrade to 19.06.00.048 done (Bug 22581 - add new OPACShowMusicalInscripts and OPACPlayMusicalInscripts system preferences)
> Upgrade to 19.06.00.049 done (Bug 13958 - Add a SuspensionsCalendar syspref)
> Upgrade to 19.06.00.050 done (Bug 23293 - Add 'OPACFineNoRenewalsIncludeCredits' system preference)

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