# Works in Client but not in Vision Preview

**URL:** <https://forum.inductiveautomation.com/t/works-in-client-but-not-in-vision-preview/40140>\
**Category:** Ignition\
**Created:** [October 29, 2020, 4:08pm UTC](https://forum.inductiveautomation.com/t/works-in-client-but-not-in-vision-preview/40140 "2020-10-29T16:08:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![steven.cox](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/steven.cox/32/18589_2.png) [@steven.cox](https://forum.inductiveautomation.com/u/steven.cox)\
**Post date:** [October 29, 2020, 4:08pm UTC](https://forum.inductiveautomation.com/t/works-in-client-but-not-in-vision-preview/40140/1 "2020-10-29T16:08:03Z")

</div>

Good morning all,

Yesterday before the hurricane hit, I had a lot of help learning and setting up a script to update a database table. It worked great in preview more and in the client.

Today, I startup and it does not work in preview mode but it works fine in the client. The only difference is a reboot.

I get this on the console…

```auto
10:56:30.114 [AWT-EventQueue-0] ERROR Vision.Components.AdvancedTable - Error invoking extension method.
org.python.core.PyException: Traceback (most recent call last):
  File "<extension-method onCellEdited>", line 31, in onCellEdited
	at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:362)
	at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepUpdate(AbstractDBUtilities.java:258)
	at jdk.internal.reflect.GeneratedMethodAccessor265.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
java.lang.Exception: java.lang.Exception: Error executing system.db.runPrepUpdate(UPDATE binder_names SET archive=? WHERE id=?, [false, 15], , , false, false)

```

plus a lot more.

What am I missing here? Again, it works fine in the client.

Thanks, Steven

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [October 29, 2020, 4:41pm UTC](https://forum.inductiveautomation.com/t/works-in-client-but-not-in-vision-preview/40140/2 "2020-10-29T16:41:55Z")

</div>

What’s the rest?

Is your gateway in read-only or read/write?

---

<div class="post-metadata">

**Author:** ![steven.cox](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/steven.cox/32/18589_2.png) [@steven.cox](https://forum.inductiveautomation.com/u/steven.cox)\
**Post date:** [October 29, 2020, 5:55pm UTC](https://forum.inductiveautomation.com/t/works-in-client-but-not-in-vision-preview/40140/3 "2020-10-29T17:55:29Z")

</div>

@bschroeder,

Thats what it was. I forgot to turn read/right back on after a fresh start. I thought about changing that in the project settings so I would not make this mistake, and something made me not do it…and I forgot!!

Thanks for the reminder!

Steven