I appreciate that the following question may have been answered however I’m just going round in circles with no solution.
I have recently setup Nextcloud 12 on a a fresh install of Ubuntu 16.04 however when accessing the Web GUI Install page or via cmd I receive the following error:
Error while trying to create admin user: An exception occurred while executing ‘CREATE TABLE oc_migrations (app VARCHAR(255) NOT NULL, version VARCHAR(255) NOT NULL, PRIMARY KEY(app, version)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB’: SQLSTATE: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
Can anyone help as to what is causing this and how to solve the issue.
I appreciate any help.