Owncloud upgrade failure

[David Marec]

Le 30.05.2017 à 22:29, David Marec a écrit :
> 
> Doctrine\DBAL\Exception\DriverException: An exception occurred while 
> executing 'CREATE TABLE oc_account_terms (id BIGINT UNSIGNED 
> AUTO_INCREMENT NOT NULL, account_id BIGINT UNSIGNED NOT NULL, term 
> VARCHAR(256) NOT NULL, INDEX account_id_index (account_id), INDEX 
> term_index (term), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE 
> utf8_bin ENGINE = InnoDB':
> 
> SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key 
> was too long; max key length is 767 bytes
> Update failed
> Maintenance mode is kept active
> Reset log level
> 
> 
> Any clue to get this working again ?
> 

As I understand the issue, the 'term' field stores too many bytes
- VARCHAR(256) * UTF8 > 767 ? -
to be used as a key index !?

(255 seems to be ok )


-- 
David Marec
https://lapinbilly.eu/