Announcement

Collapse
No announcement yet.

SQLite corrupt issue

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

    SQLite corrupt issue

    I am getting this error, which is in my log:

    Failed to cleanup the devices table: SQLite.SQLiteException: Corrupt at SQLite.SQLiteCommand.ExecuteNonQuery() at SQLite.TableQuery`1.Delete(Expression`1 predExpr) at HSPI_HSBuddy.History.DeviceHistory.CleanupCallback(Object context)

    What I tried was to delete the hsbuddy.db3 file, but I lost my NFC card information (NFC works great, by the way). I went back to some back up files, but I guess this is has been going on for longer than I have back ups. Any suggestions? Thanks.

    #2
    Just delete the history dB file in the data directory of Hsbuddy. I've had this issue a couple of times. Stop the plug in, delete the file and restart.
    HS3PRO 3.0.0.500 as a Fire Daemon service, Windows 2016 Server Std Intel Core i5 PC HTPC Slim SFF 4GB, 120GB SSD drive, WLG800, RFXCom, TI103,NetCam, UltraNetcam3, BLBackup, CurrentCost 3P Rain8Net, MCsSprinker, HSTouch, Ademco Security plugin/AD2USB, JowiHue, various Oregon Scientific temp/humidity sensors, Z-Net, Zsmoke, Aeron Labs micro switches, Amazon Echo Dots, WS+, WD+ ... on and on.

    Comment


      #3
      Originally posted by langenet View Post
      Just delete the history dB file in the data directory of Hsbuddy. I've had this issue a couple of times. Stop the plug in, delete the file and restart.
      Thank you!

      Comment

      Working...
      X