When it comes to mySQL and Ignition, I'm a newby on both fronts. So, apologies for what is probably a simple oversight on my part.
The issue I can't seem to get past is that when I test the query to insert data into the table, I get the error that one of the columns is unknown. But both the Table Browser in Ignition and the MySQL Workbench show the column as existing. I went so far as to completely delete the database and recreate it in case I had an unprintable character somewhere. I did the same thing with the saved query, but am still getting the same error.
I've included the image below that shows the Named Query, the MySQL Workbench, and the error that comes up when I attempt to test the query from the testing tab. The value that I attempted to write was 1.7, so a FLOAT as the data type required.
Not sure where to go from here. Any nudges would be greatly appreciated!
