# Unable to restore/update discourse (PG::InvalidTextRepresentation: ERROR: invalid input syntax for type integer: "\[\]")

**URL:** https://meta.discourse.org/t/unable-to-restore-update-discourse-pg-error-invalid-input-syntax-for-type-integer/229828
**Category:** Support
**Created:** [June 13, 2022, 4:41pm UTC](https://meta.discourse.org/t/unable-to-restore-update-discourse-pg-error-invalid-input-syntax-for-type-integer/229828 "2022-06-13T16:41:19Z")
**Posts on this page:** 1
**Showing post:** 10

<div class="post-metadata">

### Author: ![david](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/david/32/157490_2.png) [@david](https://meta.discourse.org/u/david)
#### Post date: [June 13, 2022, 8:05pm UTC](https://meta.discourse.org/t/unable-to-restore-update-discourse-pg-error-invalid-input-syntax-for-type-integer/229828/10 "2022-06-13T20:05:05Z")

</div>

> [@pfaffman](#):
>
> that migration is _supposed_ to migrate those selectable avatars to the new format.

It is, and it’s worked in every other case we’ve seen. `[]` isn’t a valid value, even in the old format, so this particular case is quite surprising. Maybe it’s left over from some manual work on the console, or a bad import 🤔

If we get more reports, we’ll be sure to add an automated fix for this case.

---

_[View the full topic](https://meta.discourse.org/t/unable-to-restore-update-discourse-pg-error-invalid-input-syntax-for-type-integer/229828)._