Cannot activate Maps in Nextcloud 16.0.4

Cannot activate Maps in Nextcloud 16.0.4, i get this

[An exception occurred while executing 'CREATE TABLE oc_maps_address_geo (id BIGINT AUTO_INCREMENT NOT NULL, adr VARCHAR(255) NOT NULL, adr_norm VARCHAR(255) NOT NULL, lat DOUBLE PRECISION DEFAULT NULL, lng DOUBLE PRECISION DEFAULT NULL, looked_up TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_4C2424AB9CEC6B64C4BE9D6 (adr, adr_norm), PRIMARY KEY(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](url)

[tacruc]

Which database version are you using?

5.5.5-10.1.41-MariaDB-0ubuntu0.18.04.1

[hoergen]

Same here. I use MariaDB 10.1.38 debian linux

[tacruc]

It is in migration Version000009Date20190625000800. The created table is droped anyways in Version000012Date20190703155323.
@eneiluj what is the best solution to get rid of the broken migration?
@Copiis @hoergen I'm curious is disabling and then enabling the app working?

@Copiis @hoergen I'm curious is disabling and then enabling the app working?

It is not possible to activate the app, the error message already appears during the attempt.

[hoergen]

Got the same experience here. The error message appears

This solved the problem

$ sudo mysql -u root -p
MariaDB [(none)]> use nextcloud;
MariaDB [nextcloud]> set global innodb_large_prefix=on;
MariaDB [nextcloud]> set global innodb_file_format=Barracuda;
$ sudo -u www-data php occ maintenance:repair

[hoergen]

Still not working after done your steps
An exception occurred while executing 'CREATE TABLE oc_maps_address_geo (id BIGINT AUTO_INCREMENT NOT NULL, adr VARCHAR(255) NOT NULL, adr_norm VARCHAR(255) NOT NULL, lat DOUBLE PRECISION DEFAULT NULL, lng DOUBLE PRECISION DEFAULT NULL, looked_up TINYINT(1) NOT NULL, UNIQUE INDEX UNIQ_4C2424AB9CEC6B64C4BE9D6 (adr, adr_norm), PRIMARY KEY(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

[nordcomputer]

Worked for me:

sudo mysql -u root -p
use nextcloud (your Database name)
SET GLOBAL innodb_file_format=Barracuda;
SET GLOBAL innodb_file_per_table=ON;

But instead of MariaDB [nextcloud]> I had a mysql>

The last step produced a warning:
sudo -u www-data php occ maintenance:repair

There are no commands defined in the "mainenance" namespace.

But it worked anyways.