# Update to next cloud 21.0.2 has get an error

**URL:** <https://help.nextcloud.com/t/update-to-next-cloud-21-0-2-has-get-an-error/117028>\
**Category:** ℹ️ Support\
**Created:** [May 24, 2021, 7:08pm UTC](https://help.nextcloud.com/t/update-to-next-cloud-21-0-2-has-get-an-error/117028 "2021-05-24T19:08:29Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![swiesend](https://help.nextcloud.com/user_avatar/help.nextcloud.com/swiesend/32/39027_2.png) [@swiesend](https://help.nextcloud.com/u/swiesend)\
**Post date:** [July 14, 2021, 8:11am UTC](https://help.nextcloud.com/t/update-to-next-cloud-21-0-2-has-get-an-error/117028/15 "2021-07-14T08:11:14Z")

</div>

Thank you guys!

For whatever reason I even had a wrong charset/collation

```auto
MariaDB [nextcloud]> show variables like 'innodb_file_per_table';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| innodb_file_per_table | ON |
+-----------------------+-------+
1 row in set (0.004 sec)

MariaDB [nextcloud]> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| latin1 | latin1_swedish_ci |
+--------------------------+----------------------+
1 row in set (0.002 sec)

MariaDB [nextcloud]> ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
Query OK, 1 row affected (0.001 sec)

MariaDB [nextcloud]> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8mb4 | utf8mb4_general_ci |
+--------------------------+----------------------+
1 row in set (0.001 sec)

```

Without dowgrading to `image: mariadb:10.5` or running with command ` --skip-innodb-read-only-compressed` I run also into, when reprairing  
`docker-compose exec --user www-data app php occ maintenance:repair --include-expensive` into:

```auto
     - ERROR: An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x9F\x8E\x82 V...' for column `nextcloud`.`oc_calendarobjects_props`.`value` at row 29

```

---

_[View the full topic](https://help.nextcloud.com/t/update-to-next-cloud-21-0-2-has-get-an-error/117028)._