# Another bug in designer

**URL:** <https://forum.inductiveautomation.com/t/another-bug-in-designer/53125>\
**Category:** Ignition\
**Created:** [November 16, 2021, 1:34pm UTC](https://forum.inductiveautomation.com/t/another-bug-in-designer/53125 "2021-11-16T13:34:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![SKA](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ska/32/29528_2.png) [@SKA](https://forum.inductiveautomation.com/u/SKA)\
**Post date:** [November 16, 2021, 1:34pm UTC](https://forum.inductiveautomation.com/t/another-bug-in-designer/53125/1 "2021-11-16T13:34:33Z")

</div>

I changed the SQL from tag historian in the power table i got to this SQL statement that works in mysql workbench:

```auto
USE ignition;

SELECT sqlt_data_1_2021_11.t_stamp, sqlt_data_1_2021_11.stringvalue, sensor.tagText AS SensorText FROM sqlt_data_1_2021_11
inner join sensorid Sensor ON sensor.tagID = sqlt_data_1_2021_11.tagid 

WHERE stringvalue != "0000"
;

```

But in ignition it throws and error

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/6/16eb75875cfdfb1e5f6f841afe8137d0c202cc51.png)  
And now i can no longer open the Data window due to the error keeps coming:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/7/374b2c1964c9fa3a12cdd9123beb91be748efbd7.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [November 16, 2021, 1:39pm UTC](https://forum.inductiveautomation.com/t/another-bug-in-designer/53125/2 "2021-11-16T13:39:49Z")

</div>

You are giving the MySQL JDBC driver two statements: “USE” and “SELECT”. With few exceptions, JDBC drivers only allow one statement, not a script.

---

<div class="post-metadata">

**Author:** ![SKA](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ska/32/29528_2.png) [@SKA](https://forum.inductiveautomation.com/u/SKA)\
**Post date:** [November 16, 2021, 1:41pm UTC](https://forum.inductiveautomation.com/t/another-bug-in-designer/53125/3 "2021-11-16T13:41:19Z")

</div>

That was what i figured, because i use the workbench as root, i had to use it, but forgot remove it in ignition.

After spamming alt+c to close the error dialog i managed to get the data dialog open to correct it.

---

<div class="post-metadata">

**Author:** ![kcollins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kcollins/32/19646_2.png) [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\
**Post date:** [November 16, 2021, 2:10pm UTC](https://forum.inductiveautomation.com/t/another-bug-in-designer/53125/4 "2021-11-16T14:10:55Z")

</div>

Try this set of buttons to control whether the error dialogs pop up front or are allowed behind:

 ![2021-11-16 at 8.09 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/b/dbcda6db1e3c6b1a27e7502f2118ec5337fd8c5d.png)