# 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:** Product 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:** 5

<div class="post-metadata">

**Author:** ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)\
**Post date:** [June 13, 2022, 5:48pm UTC](https://meta.discourse.org/t/unable-to-restore-update-discourse-pg-error-invalid-input-syntax-for-type-integer/229828/5 "2022-06-13T17:48:05Z")

</div>

I had a similar error on my test site where I had some errant data in my `selectable_avatar` site setting, and had to update it through the rails console.

Are you comfortable using the rails console? If so, could you run this and see what it says:

`SiteSetting.where(data_type:17)`

---

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