Announcement

Collapse
No announcement yet.

Errors after restore from backup

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

    Errors after restore from backup

    My Homeseer windows server had a hard drive issue and I restored from backup. However, since then, Ultralog3 hasn't quite been functioning and gives me the following errors. Any ideas?


    Jan-14 3:00:20 PM 1 Error System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database no such table: tblHomeSeerLog 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.ExecuteReader(CommandBehavi or behavior) 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_ULTRALOG3.hspi_database.ExecuteHSLogSQL(String strSQL, Int32& iRecordCount, Int32 iPageSize, Int32& iPageCount, Int32& iPageCur)

    Jan-14 3:00:20 PM 1 Error System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database no such table: tblHomeSeerLog 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.ExecuteReader(CommandBehavi or behavior) at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(Command Behavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at HSPI_ULTRALOG3.hspi_database.GetHSLogTypes()

    Jan-14 2:59:02 PM Plug-In Finished initializing plug-in UltraLog3

    Jan-14 2:58:11 PM Info Plugin UltraLog3 has connected. IP:127.0.0.1:50829

    [IMG]<blockquote class="imgur-embed-pub" lang="en" data-id="a/Gln5t"><a href="//imgur.com/Gln5t"></a></blockquote><script async src="//s.imgur.com/min/embed.js" charset="utf-8"></script>[/IMG]

    #2
    Originally posted by snhroc View Post
    My Homeseer windows server had a hard drive issue and I restored from backup. However, since then, Ultralog3 hasn't quite been functioning and gives me the following errors. Any ideas?


    Jan-14 3:00:20 PM 1 Error System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database no such table: tblHomeSeerLog 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.ExecuteReader(CommandBehavi or behavior) 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_ULTRALOG3.hspi_database.ExecuteHSLogSQL(String strSQL, Int32& iRecordCount, Int32 iPageSize, Int32& iPageCount, Int32& iPageCur)

    Jan-14 3:00:20 PM 1 Error System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database no such table: tblHomeSeerLog 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.ExecuteReader(CommandBehavi or behavior) at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(Command Behavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at HSPI_ULTRALOG3.hspi_database.GetHSLogTypes()

    Jan-14 2:59:02 PM Plug-In Finished initializing plug-in UltraLog3

    Jan-14 2:58:11 PM Info Plugin UltraLog3 has connected. IP:127.0.0.1:50829

    [IMG]<blockquote class="imgur-embed-pub" lang="en" data-id="a/Gln5t"><a href="//imgur.com/Gln5t"></a></blockquote><script async src="//s.imgur.com/min/embed.js" charset="utf-8"></script>[/IMG]
    The tblHomeSeerLog table is the primary table within the database. If that's missing or corrupt, then you may want to consider shutting down HomeSeer, then renaming the databases in HomeSeer HS3\Data\ultralog3, then restarting HomeSeer. This action will get the plug-in up and running again.

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

    Comment

    Working...
    X