Nextcloud update to 17.0.10

Update failed and I received this error message:

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘ALTER TABLE oc_addressbooks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;’: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

Have you tried to use the search function of this forum (upper right corner) to find an answer on your question?

https://help.nextcloud.com/search?q=max%20key%20length%20is%20767%20bytes

yes. Ive found no solution that works.

new note: when attempting to log into my DB I get this error:
mysql: unknown variable ‘innodb_buffer_pool_size=1G’
still looking for a resolution to this as well.

the initial error seems to be related to the user agent update

As usual aunt G. knows the answer:

yeah. I STARTED WITH GOOGLE. I have already read that…hasn’t helped resolve the issue. I have add it tp the post because the “resolutions” haven’t resolved it.

anytime I attempt to use the DB tools…it gives that error. I have also nano’d the config…I tried the min 128…up to 90% and no change.

NOTE: what I had to do to resolve the innodb_buffer_pool_size error: remove it from the config.

the “-u www-data php occ maintenance:repair” command does not work for me. I had to use:
“sudo -u www-data php /var/www/nextcloud/occ repair”

1 Like