https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8628 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |david@davidnind.com --- Comment #90 from David Nind <david@davidnind.com> --- I'm getting an error when running the database update: DEV atomic update: bug_8628-digital-signs-permissions.perl Upgrade to XXX done (Bug 8628 - adding permission for managing digital signs) DEV atomic update: bug_8628-digital-signs-sysprefs.perl Upgrade to XXX done (Bug 8628 - Adding OPACDigitalSigns, OPACDigitalSignsCSS and OPACDigitalSignsSwatches system preferences) DEV atomic update: bug_8628-digital-signs.perl DBD::mysql::db do failed: Unknown collation: 'utf8mb4' [for Statement " CREATE TABLE sign_streams ( sign_stream_id int(11) NOT NULL auto_increment, -- primary key, used to identify streams saved_sql_id int(11) NOT NULL, -- foreign key from the saved_sql table name varchar(64), -- name/title of the sign PRIMARY KEY (sign_stream_id), CONSTRAINT sign_streams_ibfk_1 FOREIGN KEY (saved_sql_id) REFERENCES saved_sql (id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4 "] at (eval 1419) line 6. DBD::mysql::db do failed: Can't create table 'koha_kohadev.signs_to_streams' (errno: 150) [for Statement " CREATE TABLE signs_to_streams ( sign_to_stream_id int(11) NOT NULL auto_increment, -- primary key, used to identify connections between signs and streams (the same stream can be attached to a sign more than once, with different parameters) sign_stream_id int(11) NOT NULL, -- foreign key from the decks sign_streams table sign_id int(11) NOT NULL, -- foreign key from the signs table params varchar(255) NOT NULL DEFAULT '', -- list of parameters for the SQL associated with the sign_stream PRIMARY KEY (sign_to_stream_id), CONSTRAINT signs_to_streams_ibfk_1 FOREIGN KEY (sign_stream_id) REFERENCES sign_streams (sign_stream_id) ON DELETE CASCADE, CONSTRAINT signs_to_streams_ibfk_2 FOREIGN KEY (sign_id) REFERENCES signs (sign_id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci "] at (eval 1419) line 34. Upgrade to XXX done (Bug 8628 - add signs, sign_streams and signs_to_streams tables) -- You are receiving this mail because: You are watching all bug changes.