Error while trying to create admin user: An exception occurred while executing ‘CREATE TABLE oc_migrations

Hi All,

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[42000]: 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.
Many thanks.