Another bug in designer

SKA · November 16, 2021, 1:34pm

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:

pturmel · November 16, 2021, 1:39pm

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

SKA · November 16, 2021, 1:41pm

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.

kcollins1 · November 16, 2021, 2:10pm

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