[Koha-bugs] [Bug 8628] Add digital signs to the OPAC

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8628

David Nind <david at davidnind.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |david at davidnind.com

--- Comment #90 from David Nind <david at 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.