Upgrade version 2.8 to 2.12

Re: Upgrade version 2.8 to 2.12

by Björn Bergstrand -
Number of replies: 0
I updated webwork from 2.8 to 2.12 with almost no issues. UTF-characters did not work, but applying the patch at resolved that issue.

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.

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)

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.