1071 SPECIFIED KEY WAS TOO LONG
If you get any error saying something linke “1071 Specified key was too long” when upgrading Nextcloud, you might have a setting in your config.php which prevents you from upgrading.
All you need to do is to change the following in your nextcloud/config/config.php file:
'mysql.utf8mb4' => true,
'mysql.utf8mb4' => false,
Try your upgrade again and it should work now.
Your ArtIT Team