# Error executing script

**URL:** <https://forum.inductiveautomation.com/t/error-executing-script/25969>\
**Category:** Ignition\
**Created:** [June 20, 2019, 4:07am UTC](https://forum.inductiveautomation.com/t/error-executing-script/25969 "2019-06-20T04:07:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![waiyin.lee](https://avatars.discourse-cdn.com/v4/letter/w/779978/32.png) [@waiyin.lee](https://forum.inductiveautomation.com/u/waiyin.lee)\
**Post date:** [June 20, 2019, 4:07am UTC](https://forum.inductiveautomation.com/t/error-executing-script/25969/1 "2019-06-20T04:07:42Z")

</div>

I try run an update the database value.  
The script is below

 ![Untitled](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/44c50d3b210675186df7794e8e329513a9401941.png)

However facing the error executing script like below

 ![Untitled1](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/dbcf76874a625b93f845dce4caab04dc19bd5e61.png)

---

<div class="post-metadata">

**Author:** ![waiyin.lee](https://avatars.discourse-cdn.com/v4/letter/w/779978/32.png) [@waiyin.lee](https://forum.inductiveautomation.com/u/waiyin.lee)\
**Post date:** [June 20, 2019, 5:09am UTC](https://forum.inductiveautomation.com/t/error-executing-script/25969/2 "2019-06-20T05:09:38Z")

</div>

Anybody able to assist for this debugging?

---

<div class="post-metadata">

**Author:** ![chi](https://avatars.discourse-cdn.com/v4/letter/c/0ea827/32.png) [@chi](https://forum.inductiveautomation.com/u/chi)\
**Post date:** [June 20, 2019, 7:58am UTC](https://forum.inductiveautomation.com/t/error-executing-script/25969/3 "2019-06-20T07:58:50Z")

</div>

Replace `runUpdateQuery` with `runPrepUpdate`. The rest of your script looks good to me.