# Having issue updating schema for temporal\_visibility database (using 1.20.3 temporal version)

**URL:** <https://community.temporal.io/t/having-issue-updating-schema-for-temporal-visibility-database-using-1-20-3-temporal-version/9138>\
**Category:** Community Support\
**Created:** [August 9, 2023, 11:34pm UTC](https://community.temporal.io/t/having-issue-updating-schema-for-temporal-visibility-database-using-1-20-3-temporal-version/9138 "2023-08-09T23:34:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![D\_g](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/d_g/32/3857_2.png) [@D\_g](https://community.temporal.io/u/D_g)\
**Post date:** [August 9, 2023, 11:34pm UTC](https://community.temporal.io/t/having-issue-updating-schema-for-temporal-visibility-database-using-1-20-3-temporal-version/9138/1 "2023-08-09T23:34:36Z")

</div>

here is the issue while updating the schema for temporal\_visibility database, following this doc [GitHub - temporalio/helm-charts: Temporal Helm charts](https://github.com/temporalio/helm-charts#install-with-your-own-mysql)  
here is the error message 2023-08-09T22:15:40.424Z ERROR Unable to update SQL schema. {“error”: “error executing statement:Error 1060: Duplicate column name ‘search\_attributes’”, “logging-call-at”: “handler.go:78”}  
Please guide, i’m blocked.

 ![image](https://us1.discourse-cdn.com/flex016/uploads/temporal/original/2X/d/d804200742da1046cebdd57b03bee53b1eb3c1cf.png)

---

<div class="post-metadata">

**Author:** ![D\_g](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/d_g/32/3857_2.png) [@D\_g](https://community.temporal.io/u/D_g)\
**Post date:** [August 10, 2023, 3:51pm UTC](https://community.temporal.io/t/having-issue-updating-schema-for-temporal-visibility-database-using-1-20-3-temporal-version/9138/2 "2023-08-10T15:51:40Z")

</div>

@tihomir can you please guide what to do in this case? I can’t edit the advanced\_visibility.sql with temporal user

---

<div class="post-metadata">

**Author:** ![tihomir](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/tihomir/32/6580_2.png) [@tihomir](https://community.temporal.io/u/tihomir)\
**Post date:** [August 10, 2023, 6:26pm UTC](https://community.temporal.io/t/having-issue-updating-schema-for-temporal-visibility-database-using-1-20-3-temporal-version/9138/3 "2023-08-10T18:26:45Z")

</div>

Haven’t seen this before. Need to try to reproduce and get back to you asap.

---

<div class="post-metadata">

**Author:** ![D\_g](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/d_g/32/3857_2.png) [@D\_g](https://community.temporal.io/u/D_g)\
**Post date:** [August 16, 2023, 4:13pm UTC](https://community.temporal.io/t/having-issue-updating-schema-for-temporal-visibility-database-using-1-20-3-temporal-version/9138/4 "2023-08-16T16:13:09Z")

</div>

@tihomir Any update on this? Also having issues doing search with workflow id using temporal 1.20.3

 ![MicrosoftTeams-image (30)](https://us1.discourse-cdn.com/flex016/uploads/temporal/original/2X/a/acfeeef434d239af7c5eaf5f9de53ddf0db8359f.png)