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
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
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”