However: When running the OPL-update script it fails with message:
DBD::mysql::db do failed: Specified key was too long; max key length is 1000 bytes at /var/webwork/webwork2/bin/OPL-updat
e line 266.
e line 266.
The offending query is:
CREATE TABLE `OPL_author` (
author_id int (15) NOT NULL auto_increment,
institution tinyblob,
lastname varchar (255) NOT NULL,
firstname varchar (255) NOT NULL,
email varchar (255),
KEY author (lastname, firstname),
PRIMARY KEY (author_id)
) ENGINE=MYISAM
author_id int (15) NOT NULL auto_increment,
institution tinyblob,
lastname varchar (255) NOT NULL,
firstname varchar (255) NOT NULL,
email varchar (255),
KEY author (lastname, firstname),
PRIMARY KEY (author_id)
) ENGINE=MYISAM
It seems to have to do with UTF-characters again, where 255 of them take up too many bytes for the index.
Unfortunately the library browser does not work because of this.
Is there a way around this issue?
EDIT: After some googling it seems that the problem is with the myisam-engine. However, i have
$database_storage_engine = 'innodb';
in my site.conf, so i'm not sure why OPL-update wants to use myisam.
EDIT2: Well it turns out that the offenting configuration was in defaults.config. I changed MYISAM to INNODB and the update ran through fine.