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?

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