Another bug in designer

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

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


And now i can no longer open the Data window due to the error keeps coming:
image

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

1 Like

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.

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

1 Like