www.homeseer.com    
 

Go Back   HomeSeer Message Board > 3rd Party Plug-Ins/Scripts > Plug-ins by Author > Click Here for List of Author Forums > Ultra Scripts and Plug-Ins > UltraLog HSPI

UltraLog HSPI Discussion area for the UltraLog, HomeSeer database logging plug-in.

Reply
 
Thread Tools Display Modes
  #1  
Old January 14th, 2018, 04:06 PM
snhroc snhroc is offline
Seer
 
Join Date: Sep 2015
Location: Rochester, NY
Posts: 14
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]
[/IMG]
Reply With Quote
  #2  
Old January 15th, 2018, 10:11 AM
Ultrajones's Avatar
Ultrajones Ultrajones is offline
OverSeer
 
Join Date: Jan 2001
Location: Michigan, US
Posts: 5,782
Quote:
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]
[/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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Restore backup from Zee to S6 ? mikalj HomeTroller™ 1 July 3rd, 2017 01:31 PM
Can't Restore HS3 from Backup VirtualPanther HS3 / HS3PRO Discussion 10 December 14th, 2014 09:13 AM
Backup and Restore HS3 Steve Q HS3 / HS3PRO Discussion 2 December 10th, 2014 04:08 PM
Backup / restore holmes.craig@gmail.com HomeTroller Zee 4 May 10th, 2014 10:51 AM
Restore from Backup neiltimms ActiveBackup Plug-In 3 January 10th, 2008 09:36 PM


All times are GMT -4. The time now is 11:18 AM.


Copyright HomeSeer Technologies, LLC