Malformed database disk image is malformed

[baxter]

mcsMQTT has never really worked right (no charting, for one thing). I just noticed in the log a bunch of these:

HistoryExecuteCommand
INSERT INTO MQTT_HISTORY
(Sequence,Publish,LastDate,Topic,Payload)
Values (75,0,'2021-07-20 17:27:19','dashbox/01021578/c32/watt','0')
at Mono.Data.Sqlite.SQLite3.Reset(SqliteStatement stmt)
at Mono.Data.Sqlite.SQLite3.Step(SqliteStatement stmt)
at Mono.Data.Sqlite.SqliteDataReader.NextResult()
at Mono.Data.Sqlite.SqliteDataReader..ctor(SqliteCommand cmd, CommandBehavior behave)
at Mono.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at MCSMQTTHS4_2020.Database.HistoryExecuteCommand(String sCommand)
in C:\Users\Public\Documents\TFVC\HS\MQTT\MCSMQTTHS4_2020\Datab ase.vb:line 1065
Line 0 The database disk image is malformed database disk image is malformed

I looked in C:\Users\Public\Documents and there are no subdirectories. Where is this database?

I tried uninstalling mcsMQTT and re-installing, but the error came back. Obviously, the database (wherever it is) hung around after uninstalling.

[Michael McSharry]

In HS install location subfolder \Data\mcsMQTT\mcsMQTT History.db. Note the same folder has mcsMQTT.db which is where the Association tab and Edit tab information is maintained.

When this file is corrupted then use of SQLite for History and Chart is not possible. InfluxDB can still be used. Best to just delete the file and let it be recreated unless of course you have a valid database in the past and a backup exists.

[Guest]

For charting, check InfluxDB, highly customizable and integrates well with HS/HStouch.
McsMQTT is a great plugin + outstanding support.
If you need assistance just ask, the author or the community will help.

[baxter]

Thanks for the response, Michael. I deleted all traces of the database and re-installed mcsMQTT. Seems to work better now.