Announcement

Collapse
No announcement yet.

Error in the log and log empty

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

    Error in the log and log empty

    Ultrajones,
    I'm gettign these errors in the log and the log is empty, any suggestions?

    Aug-08 10:13:48 AM 1 Error System.Data.SQLite.SQLiteException (0x80004005): database disk image is malformed database disk image is malformed 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)
    Aug-08 10:13:48 AM 1 Error System.Data.SQLite.SQLiteException
    Aug-08 10:13:48 AM 1 Error System.Data.SQLite.SQLiteException (0x80004005): database disk image is malformed database disk image is malformed 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()
    Aug-08 10:13:48 AM 1 Error System.Data.SQLite.SQLiteException

    #2
    Originally posted by aldo View Post
    Ultrajones,
    I'm gettign these errors in the log and the log is empty, any suggestions?

    Aug-08 10:13:48 AM 1 Error System.Data.SQLite.SQLiteException (0x80004005): database disk image is malformed database disk image is malformed 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)
    Aug-08 10:13:48 AM 1 Error System.Data.SQLite.SQLiteException
    Aug-08 10:13:48 AM 1 Error System.Data.SQLite.SQLiteException (0x80004005): database disk image is malformed database disk image is malformed 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()
    Aug-08 10:13:48 AM 1 Error System.Data.SQLite.SQLiteException
    It looks like the database is corrupt. Please shutdown Homeseer, then rename HomeSeer HS3\Data\ultralog3\ultralog3.db3, then restart HomeSeer. That should rebuild the database so you can use the plug-in again.

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

    Comment


      #3
      Thanks Ultrajones, it worked.

      Comment

      Working...
      X