Nextcloud problem MySQL is used as a database, but does not support 4-byte characters
Today I will show you how to use a single command to fix the problem which displays Nextcloud after installation.
The whole will take a few seconds and comes down to enter commands in the console
We log in to the SSH server and go to the directory where is installed our nextcloud
In my case:
1 | cd /home/dysk/domains/dysk-online.pl/public_html |
Then we command:
1 | sudo -u dysk /usr/local/php71/bin/php occ config:system:set mysql.utf8mb4 --type boolean --value="true" |
So in a nutshell:
sudo -u drive – The command is performed with the user's rights
If the page is, for example admin account command will look like this:
1 | sudo -u admin /usr/local/php71/bin/php occ config:system:set mysql.utf8mb4 --type boolean --value="true" |
/usr/local/php71/bin/php – This is the path to our php version minimum 7.0
everybody it can be different depending on the server.
php occ config:system:set mysql.utf8mb4 –type boolean –value=”true” – This is the same command a conversion of the base.
That's all.