Won't display charts

[mbdirtfarmer]

just got my Temp08 installed and testing plugin with 1 ds18s20, using default plugin database sqlite

device is updating fine but chart button does nothing, here is the error from Homeseer logs:

------
3/22/2013 8:48:04 PM ~!~Ultra1Wire2 Error~!~An unexpected error occured in the QueryDatabase() function/subroutine: [System.Data.SQLite.SQLiteException: SQLite errornear "2": syntax error at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) at System.Data.SQLite.SQLiteCommand.BuildNextCommand() at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(Command Behavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteR eader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at HSPI_ULTRA1WIRE2.Database.QueryDatabase(String strSQL)]
3/22/2013 8:48:04 PM ~!~Ultra1Wire2 Error~!~An unexpected error occured in the GetSensorChart() function/subroutine: [System.IndexOutOfRangeException: Cannot find table 0. at System.Data.DataTableCollection.get_Item(Int32 index) at HSPI_ULTRA1WIRE2.HSPI.GetSensorChart(Hashtable& PluginDevices, Hashtable& DeviceColors, String ChartType, ArrayList TempSensorList, DateTime dEndDateTime, String Interval)]
3/22/2013 8:48:07 PM ~!~Ultra1Wire2 Error~!~An unexpected error occured in the QueryDatabase() function/subroutine: [System.Data.SQLite.SQLiteException: SQLite errornear "2": syntax error at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) at System.Data.SQLite.SQLiteCommand.BuildNextCommand() at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(Command Behavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteR eader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at HSPI_ULTRA1WIRE2.Database.QueryDatabase(String strSQL)]
3/22/2013 8:48:07 PM ~!~Ultra1Wire2 Error~!~An unexpected error occured in the GetSensorChart() function/subroutine: [System.IndexOutOfRangeException: Cannot find table 0. at System.Data.DataTableCollection.get_Item(Int32 index) at HSPI_ULTRA1WIRE2.HSPI.GetSensorChart(Hashtable& PluginDevices, Hashtable& DeviceColors, String ChartType, ArrayList TempSensorList, DateTime dEndDateTime, String Interval)]
----

HS Latest: 2.5.0.79?

Did I miss something in the setup? Any Ideas or suggestions?

[Ultrajones]

Can you send me the Ultra1Wire2 SQLite database so I can attempt to replicate that issue? Send it to ultrajones@hotmail.com.

Regards,
Ultrajones

[mbdirtfarmer]

db Sent via emal.

[Ultrajones]

It looks like your HomeSeer house code is not making it into the database. Can you provide me the housecode displayed on the Ultra1Wire2 > Status web page?

[mbdirtfarmer]

The housecode from status page is: # :as shown in my status screen snap in my first post.

I'm also attaching 2 more snaps from my home screen.

[Ultrajones]

Ok, the single quote house code is the issue. Let me see if there is a way to fix this...

[mbdirtfarmer]

something tells me that a while back I had a problem with that "single quote" housecode with another plugin... I wonder if there is a way to stop it from being handed out.

No panic Ultra, enjoy the easter weekend.

[mbdirtfarmer]

I know you have been busy with your brultech plugin rewrite. Can you give me a bit of feedback here?

I guess the first question is, will this plugin make the transition to HS3? If not then no need to go any further. I will have to work towards a solution that will work with HS3. I probably wont be jumping on the bandwagon right away but will probably make the transition after it is in a stable state. Then again I may change my mind depending on how things look when they release the beta.

If it will be supported in HS3 then I will purchase this plugin and hopefully work through this issue.

[Ultrajones]

Yes, this plug-in will make it to HS3. I am not in any hurry as it will be a long time before it is officially released. I won't start working on any plug-in conversions until sometime after a beta release.

I'll look at the single quote issue later today.