Upgrading Trac throws SQL-error
|Reported by:||stefan@…||Owned by:||seccanj|
I am using Trac 1.1.2dev-r11803 with MySQL and trying to install TestManager. The two generic plugins install fine, but when I install the actual TestManager plugin and upgrade Trac afterwards, I get the following error:
OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')
trac.log says it is the "CREATE TABLE testcase" that fails I can reproduce the error in MySQL, and I can create the table if I ommit the PRIMARY KEY part.
I created the Trac database with this:
CREATE DATABASE trac_myproject DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
As far as I can see in the Trac documentation for MySQL, this should be all right, so what can I do to make the plugin work?