[Koha-bugs] [Bug 22445] Ability to define a URL for custom cover images
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Nov 8 07:58:48 CET 2019
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.
More information about the Koha-bugs
mailing list