I’m trying to update to 6.3 (from 6.2.5) The update script ran successfully until the end, without problems. “./seafile.sh start” now shows me:
[06/04/18 13:41:31] …/common/ccnet-db.c(142): Error exec query CREATE TABLE IF NOT EXISTS GroupStructure ( id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, group_id INTEGER, path VARCHAR(1024), UNIQUE INDEX(group_id), INDEX(path))ENGINE=INNODB: MySQL failed to execute: Index column size too large. The maximum column size is 767 bytes…
failed to run “ccnet-server -t”
It’s because the index is too large for some databases.
You can manually create that table in your ccnet database by running
CREATE TABLE IF NOT EXISTS GroupStructure ( id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, group_id INTEGER, path VARCHAR(1024), UNIQUE INDEX(group_id))ENGINE=INNODB;
it’s ok to deprecate this table index in open source release.