good afternoon and hoping this finds you well.
im doing some maintenance on my Nextcloud and when trying to update the Mail app it gave the following error message:
CREATE TABLE oc_mail_mailboxes (id VARCHAR(255) NOT NULL, account_id INT NOT NULL, sync_token VARCHAR(255) NOT NULL, attributes VARCHAR(255) DEFAULT ‘’ NOT NULL, delimiter VARCHAR(1) NOT NULL, messages INT NOT NULL, unseen INT NOT NULL, selectable TINYINT(1) DEFAULT ‘1’ NOT NULL, PRIMARY KEY(account_id, id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ENGINE = InnoDB ROW_FORMAT = compressed’: SQLSTATE: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
i tried recreating the table manually using VARCHAR (100) and it worked fine.
anyone else having this issue?
thanks in advance!