https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38602
David Nind <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #175071|0 |1 is obsolete| | --- Comment #4 from David Nind <[email protected]> --- Created attachment 175176 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=175176&action=edit Bug 38602: Do not check if columns bookings.creation_date and bookings.modification_date from information_schema If one has multiple databases in use adding columns bookings.creation_date and bookings.modification_date is added just to first updated database and skipped in other updates. This happens because we check if these columns already exist in database from information_schema. We should instead make this check with method column_exists. To test: 1. Apply this patch. 3. Drop columns bookings.creation_date and bookings.modification_date: ALTER TABLE bookings DROP COLUMN creation_date; ALTER TABLE bookings DROP COLUMN modification_date; 2. Revert your database back to version 24.0600028: UPDATE systempreferences SET value = "24.0600014" WHERE variable = "version"; 3. Run updatedatabase.pl. => Check that columns were added. If you happen to have two databases: 1. Check if you have columns in your bookings table: SELECT DISTINCT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('creation_date', 'modification_date'); => Note that columns exist only in one of the databases. 2. Make sure you're using database missing columns from booking table. 3. Apply this patch. 4. Revert back to version 24.0600028. 5. Run updatedatabase.pl => Check that columns were now added to database. Sponsored-by: Koha-Suomi Oy Signed-off-by: David Nind <[email protected]> -- 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/
