Support intro
Sorry to hear you’re facing problems
help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.
In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:
example
Or for longer, use three backticks above and below the code snippet:
longer
example
here
Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can
Nextcloud version 16.0.1:
Operating system and version _4.15.0-50-generic #54-Ubuntu _:
Apache or nginx version Apache/2.4.29:
PHP version 7.2 with Zend OPcache v7.2.17-0ubuntu0.18.04.1:
The issue you are facing:
Tried to convert datebase to 4bytes
After : sudo -u www-data php occ maintenance:repair
getting :
Nextcloud is in maintenance mode - no apps have been loaded
- Repair MySQL collation
- Change row format for oc_addressbooks …
- Change collation for oc_addressbooks …
In AbstractMySQLDriver.php line 125:
An exception occurred while executing ‘ALTER TABLE oc_addressbooks
CONVER
T TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;’:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was t
oo long; max key length is 767 bytes
In PDOStatement.php line 143:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was t
oo long; max key length is 767 bytes
In PDOStatement.php line 141:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was t
oo long; max key length is 767 bytes
maintenance:repair [–include-expensive]
DB is MySQL - MariaDB 5.5 57 remote on QNAP
Is this the first time you’ve seen this error? Y: