https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22445 Joonas Kylmälä <joonas.kylmala@helsinki.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |joonas.kylmala@helsinki.fi --- Comment #119 from Joonas Kylmälä <joonas.kylmala@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.