Invalid datetime format: 1366 Incorrect string value: '\xE0'

ℹ️ Support
, , ,
1
Support intro

After updating to the current version i have had these repeating errors. I also have a note stating
“This instance is missing some recommended PHP modules. For improved performance and better compatibility it is highly recommended to install them: bz2.” not sure if this is related.
I have adjusted the following settings as some were set at utf8mb3. But that didnt fix anything unfortunatly.

Variable_name | Value |
±-------------------------±-----------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb3 |
| character_sets_dir | /usr/share/mariadb/charsets/ |

would appreciate any help and advise. Thanks.

Sorry to hear you’re facing problems :slightly_frowning_face:

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:

 DriverException An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE0' for column `nextcloud`.`oc_systemtag`.`name` at row 1
Error while running background job (class: OCA\Recognize\BackgroundJobs\ClassifyLandmarksJob, arguments: Array ( [storageId] => 5 [rootId] => 3446 ) )

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 :heart:

Nextcloud version (eg, 20.0.5): 28.0.2
Operating system and version (eg, Ubuntu 20.04): Synology w/ Docker
Apache or nginx version (eg, Apache 2.4.25): 2.4.57
PHP version (eg, 7.4): 8.2.15

The issue you are facing: Getting this error every 5/10 minutes. When a cron job is run I believe.

Is this the first time you’ve seen this error? (Y/N): Yes

Steps to replicate it:

  1. Automatically runs in background as cron job

The output of your Nextcloud log in Admin > Logging:

 DriverException An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE0' for column `nextcloud`.`oc_systemtag`.`name` at row 1
Error while running background job (class: OCA\Recognize\BackgroundJobs\ClassifyLandmarksJob, arguments: Array ( [storageId] => 5 [rootId] => 3446 ) )

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

PASTE HERE

The output of your Apache/nginx/system log in /var/log/____:

PASTE HERE

PASTE HERE


Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

PASTE HERE