Good evening,
during the update to 20.0.7 I got this failure-message:
Reparaturinformation: Change collation for oc_mail_messages …
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘ALTER TABLE oc_mail_messages CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;’: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x92\xB3 A…’ for column cloud.oc_mail_messages.subject at row 13
Das Update ist fehlgeschlagen. Bitte melde dieses Problem an die Nextcloud Community.
The updater ask to contact this forum. What can I do ?
Thank you very much,
Reinhard Wilhelm
Guten Abend,
beim Updaten auf 20.0.7 bekam ich nachfolgende Fehlermeldung:
Reparaturinformation: Change collation for oc_mail_messages …
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘ALTER TABLE oc_mail_messages CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;’: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: ‘\xF0\x9F\x92\xB3 A…’ for column cloud.oc_mail_messages.subject at row 13
Das Update ist fehlgeschlagen. Bitte melde dieses Problem an die Nextcloud Community.
Ich soll mich an das Forum wenden. Was kann ich tun ?
Vielen Dank
Reinhard Wilhelm
Support intro
Sorry to hear you’re facing problems 
help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.
In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:
example
Or for longer, use three backticks above and below the code snippet:
longer
example
here
Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can 
Nextcloud version (eg, 20.0.5): replace me
Operating system and version (eg, Ubuntu 20.04): replace me
Apache or nginx version (eg, Apache 2.4.25): replace me
PHP version (eg, 7.4): replace me
The issue you are facing:
Is this the first time you’ve seen this error? (Y/N): yes
Steps to replicate it:
- manuell update, safe data & config - Folders, download .zip-file, cp it to /var/www/html/nextcloud
- /etc/init.d/apache2 restart
- mozilla
The output of your Nextcloud log in Admin > Logging:
as I've written
The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => 'xxxxxxxxx',
'passwordsalt' => 'xxxxxxxxxxx',
'secret' => 'xxxxxxxxxxxxxxxx',
'trusted_domains' =>
array (
0 => 'cloud.wilhelm.technology',
1 => 'wilhelm.technology',
),
'datadirectory' => '/var/www/html/nextcloud/data',
'dbtype' => 'mysql',
'version' => '20.0.6.1',
'overwrite.cli.url' => 'https://cloud.wilhelm.technology/nextcloud',
'dbname' => 'cloud',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => false,
'dbuser' => 'xxxxx',
'dbpassword' => 'xxxxxxxxxxxxxxxxxxx',
'enable_previews' => false,
'installed' => true,
'theme' => '',
'loglevel' => 2,
'maintenance' => false,
'updater.secret' => 'xxxxxxxxxxxxxxxxxxxx',
'mail_smtpmode' => 'smtp',
'mail_smtpsecure' => 'tls',
'mail_sendmailmode' => 'smtp',
'mail_from_address' => 'xxxxxx',
'mail_domain' => 'xxxxxxx',
'mail_smtpauthtype' => 'LOGIN',
'mail_smtpauth' => 1,
'mail_smtphost' => 'xxxxxx'',
'mail_smtpport' => '587',
'mail_smtpname' => 'xxxxx',
'mail_smtppassword' => 'xxxxxxxxxxxxxxxxx',
);
The output of your Apache/nginx/system log in /var/log/____:
no error