SQLite errors in ver 1.492 log

[gs001]

Hello  again,

I'm seeing a large number of SQLite errors in my log file in version 1.492. I believe I had these errors an my previous version (1.484) also. See the attached log file excerpt.

In addition to the log error, my statistics graphing doesn't function. There is no data to be graphed, and I suspect the two issues are related.

Could someone who is more adept than me take a look at this and point me in the proper direction?

Thanks in advance,

Gary Sanders

[dani]

In maintenance menu, try to reset the database.
In the log we can see that the ValuesHist table has 6 columns and HG try to set 7 values.

[gs001]

Thanks for your reply.

I just tried as you suggested, and reset the database. Unfortunately it made no difference. I still have the same errors.

Is there anything else I can try?

Thanks,

Gary Sanders

[dani]

Can you join here your sqlite database ? I will look the tables.

[gs001]

Thanks for your reply.  Am I correct in assuming the name of the database file is homegenie_stats.db?

If so, I've attached it to this message.

Let me know if this is the wrong file, and thanks for the assistance.

[dani]

As I thought, the tables are not good.
You have only 1 table instaed of 2. And that table as only 6 fields instead of 7.
Can you replace your file by that one I post ?
Inform me if that works !

Cheers
Dani

[gs001]

I just installed the revised database file, and wanted to give you a quick update.

As soon as I restarted HG, I looked at the Stats graphing, and it is starting to provide data, which it hasn't done for quite a while. The graph was blank previously.

I will watch a tail -f of the log file and see if the errors are resolved (but I'm willing to bet they are, thanks to your help).

I'll let you know in a later posting what the log file tells me.

Thank you so much for the assistance with this,

Gary

[gs001]

Final update on this problem - It's Fixed, thanks to your help!

After I installed the Database file, I kept an eye on it, and saw no errors. Just in case I missed something, I downloaded the log file and did a text search for error messages - they were happening like clockwork in batches every five minutes before the db update, and not a single SQLite error in the 10 hours since.

You definitely identified my problem, and I thank you.

Gary