Announcement

Collapse
No announcement yet.

Won't display charts

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Won't display charts

    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?
    Attached Files
    Last edited by mbdirtfarmer; March 23rd, 2013, 11:45 PM. Reason: forgot HS version.

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

    Regards,
    Ultrajones
    Plug-ins: UltraMon, UltraM1G, UltraCID, Ultra1Wire, UltraLog, UltraWeatherBug, UltraPioneerAVR, UltraGCIR

    Comment


    • #3
      db Sent via emal.

      Comment


      • #4
        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?
        Plug-ins: UltraMon, UltraM1G, UltraCID, Ultra1Wire, UltraLog, UltraWeatherBug, UltraPioneerAVR, UltraGCIR

        Comment


        • #5
          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.
          Attached Files

          Comment


          • #6
            Ok, the single quote house code is the issue. Let me see if there is a way to fix this...
            Plug-ins: UltraMon, UltraM1G, UltraCID, Ultra1Wire, UltraLog, UltraWeatherBug, UltraPioneerAVR, UltraGCIR

            Comment


            • #7
              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.

              Comment


              • #8
                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.

                Comment


                • #9
                  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.
                  Plug-ins: UltraMon, UltraM1G, UltraCID, Ultra1Wire, UltraLog, UltraWeatherBug, UltraPioneerAVR, UltraGCIR

                  Comment

                  Working...
                  X