https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22445
Joonas Kylmälä <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #119 from Joonas Kylmälä <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
