# Table Error when running application, but not in preview mode

**URL:** <https://forum.inductiveautomation.com/t/table-error-when-running-application-but-not-in-preview-mode/60906>\
**Category:** Ignition\
**Tags:** database\
**Created:** [June 17, 2022, 6:22pm UTC](https://forum.inductiveautomation.com/t/table-error-when-running-application-but-not-in-preview-mode/60906 "2022-06-17T18:22:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ignition\_Newbie](https://avatars.discourse-cdn.com/v4/letter/i/f6c823/32.png) [@Ignition\_Newbie](https://forum.inductiveautomation.com/u/Ignition_Newbie)\
**Post date:** [June 17, 2022, 6:22pm UTC](https://forum.inductiveautomation.com/t/table-error-when-running-application-but-not-in-preview-mode/60906/1 "2022-06-17T18:22:40Z")

</div>

I am using transaction groups to write to MySQL database, and then displaying the logged information onto a table. In the data binding property, I am putting:

SELECT Product\_Code, Disp\_Qty, t\_stamp  
FROM table

there are no errors, and can see the information logging to the table when in preview mode. But when I run the application, there is an error, but no error message.

Any thoughts on what could be causing this error?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/5/15959c854f0a077a6365bf2c8ee03e66fbfc6bf6.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/5/e5282f739129714dde09fc93e1e66adbd44a72fe.png)

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [June 17, 2022, 6:29pm UTC](https://forum.inductiveautomation.com/t/table-error-when-running-application-but-not-in-preview-mode/60906/2 "2022-06-17T18:29:51Z")

</div>

You’re using a legacy database query without enabling legacy access for the client. Convert your query to a named query, bind it to the table, and it will work. You can also grant legacy access in project properties → Permissions, but it is a security risk and an anti-pattern (bad design).

---

<div class="post-metadata">

**Author:** ![Ignition\_Newbie](https://avatars.discourse-cdn.com/v4/letter/i/f6c823/32.png) [@Ignition\_Newbie](https://forum.inductiveautomation.com/u/Ignition_Newbie)\
**Post date:** [June 17, 2022, 6:42pm UTC](https://forum.inductiveautomation.com/t/table-error-when-running-application-but-not-in-preview-mode/60906/3 "2022-06-17T18:42:59Z")

</div>

Thank you very much for your reply. Works great now.