Just got both and Air and Sky and wanted to try your plugin. But I ran into an issue.
Code:
[TABLE="cellspacing: 0"] [TR="class: cke_show_border"] [TD="align: left"][COLOR=#000000]Nov-03 4:11:13 PM[/COLOR][/TD] [TD="align: left"] [/TD] [TD="colspan: 3, align: left"][COLOR=#000000]Database[/COLOR][/TD] [TD="colspan: 8, align: left"][COLOR=#000000]There were errors generated during the save of the database item. Please consult this log for more details and report any data loss to HomeSeer Technologies.[/COLOR][/TD] [/TR] [/TABLE] [TABLE="cellspacing: 0"] [TR="class: cke_show_border"] [TD="align: left"][COLOR=#FF0000]Nov-03 4:11:03 PM[/COLOR][/TD] [TD="align: left"] [/TD] [TD="colspan: 3, align: left"][COLOR=#FF0000]Database[/COLOR][/TD] [TD="colspan: 8, align: left"][COLOR=#FF0000]Error - Save of the devices to the database did not succeed - see the log for more details.[/COLOR][/TD] [/TR] [/TABLE] [TABLE="cellspacing: 0"] [TR="class: cke_show_border"] [TD="align: left"][COLOR=#000000]Nov-03 4:11:03 PM[/COLOR][/TD] [TD="align: left"] [/TD] [TD="colspan: 3, align: left"][COLOR=#000000]Database[/COLOR][/TD] [TD="colspan: 8, align: left"][COLOR=#000000]ERROR, device Pressure failed to be updated or added to the database.[/COLOR][/TD] [/TR] [/TABLE] [TABLE="cellspacing: 0"] [TR="class: cke_show_border"] [TD="align: left"][COLOR=#FF0000]Nov-03 4:11:03 PM[/COLOR][/TD] [TD="align: left"] [/TD] [TD="colspan: 3, align: left"][COLOR=#FF0000]Error[/COLOR][/TD] [TD="colspan: 8, align: left"][COLOR=#FF0000]SQL Exception : UPDATE [Devices] SET [ref]=4853,[name]='Pressure',[location]='',[location2]='',[Last_Change]='2018-11-02 23:02:08',[devValue]=NaN,[devString]='',[object_version]=101,[object_data]=@ByteArray WHERE [ref]=4853;[/COLOR][/TD] [/TR] [/TABLE] [TABLE="cellspacing: 0"] [TR="class: cke_show_border"] [TD="align: left"][COLOR=#FF0000]Nov-03 4:11:03 PM[/COLOR][/TD] [TD="align: left"] [/TD] [TD="colspan: 3, align: left"][COLOR=#FF0000]Error[/COLOR][/TD] [TD="colspan: 8, align: left"][COLOR=#FF0000]SQL Exception updating device record in the database: SQL logic error or missing database no such column: NaN, Code=1, Link=[/COLOR][/TD] [/TR] [/TABLE]
Comment