# Error 500 when try to recover account after upgrade to v2.0.1

**URL:** <https://community.passbolt.com/t/error-500-when-try-to-recover-account-after-upgrade-to-v2-0-1/555>\
**Category:** Installation Issues\
**Created:** [April 12, 2018, 3:35pm UTC](https://community.passbolt.com/t/error-500-when-try-to-recover-account-after-upgrade-to-v2-0-1/555 "2018-04-12T15:35:26Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![dducatel](https://avatars.discourse-cdn.com/v4/letter/d/c6cbf5/32.png) [@dducatel](https://community.passbolt.com/u/dducatel)\
**Post date:** [April 13, 2018, 8:00am UTC](https://community.passbolt.com/t/error-500-when-try-to-recover-account-after-upgrade-to-v2-0-1/555/3 "2018-04-13T08:00:19Z")

</div>

ok, so my `file_storage` tables as 8 field with the bad encoding

```
+--------------+--------------+-------------+--------------------+--------------------+
| table_schema | table_name | column_name | character_set_name | collation_name |
+--------------+--------------+-------------+--------------------+--------------------+
| passbolt | file_storage | user_id | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | foreign_key | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | model | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | filename | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | extension | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | hash | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | path | utf8mb4 | utf8mb4_general_ci |
| passbolt | file_storage | adapter | utf8mb4 | utf8mb4_general_ci |
+--------------+--------------+-------------+--------------------+--------------------+
8 rows in set (0.01 sec)

```

I will dit the change to `utf8mb4_unicode_ci`.

Edit:

So I did it and it’s working 😉  
Thanks @remi

For people will facing the same trouble theses lines do the change

```
ALTER TABLE file_storage MODIFY user_id varchar(36) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY foreign_key varchar(36) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY model varchar(128) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY filename varchar(255) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY extension varchar(5) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY hash varchar(64) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY path varchar(255) COLLATE utf8mb4_unicode_ci;
ALTER TABLE file_storage MODIFY adapter varchar(32) COLLATE utf8mb4_unicode_ci;
```

---

_[View the full topic](https://community.passbolt.com/t/error-500-when-try-to-recover-account-after-upgrade-to-v2-0-1/555)._