Unable to update Mail app

HI guys,

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[42000]: 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!