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/
_______________________________________________
freebsd-ports@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"
