User Tools

Site Tools


1071_specified_key_too_long

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
1071_specified_key_too_long [2020/11/25 19:39] chris1071_specified_key_too_long [2020/11/25 19:41] (current) chris
Line 1: Line 1:
-**1071 Specified key was too long**+**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 a setting in your config.php which prevents you from upgrading. +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  +All you need to do is to change the following in your nextcloud/config/config.php file: 
  
    'mysql.utf8mb4' => true,    'mysql.utf8mb4' => true,
 to to
-   'mysql.utf' => true,+   'mysql.utf8mb4' => false, 
 +    
 +Try your upgrade again and it should work now.  
 +\\ 
 +\\ 
 +Enjoy, 
 + 
 +**Your ArtIT Team** 
 +\\ 
 +\\ 
 + 
 +**[[applications|BACK]]** 
 + 
  
1071_specified_key_too_long.1606329544.txt.gz · Last modified: 2020/11/25 19:39 by chris