HomeGenie Forum

General Category => Troubleshooting and Support => Topic started by: gs001 on July 07, 2015, 06:14:54 AM

Title: SQLite errors in ver 1.492 log
Post by: gs001 on July 07, 2015, 06:14:54 AM

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

Title: Re: SQLite errors in ver 1.492 log
Post by: dani on July 07, 2015, 11:53:57 AM

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.

Title: Re: SQLite errors in ver 1.492 log
Post by: gs001 on July 07, 2015, 06:06:05 PM

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

Title: Re: SQLite errors in ver 1.492 log
Post by: dani on July 08, 2015, 02:41:25 PM

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

Title: Re: SQLite errors in ver 1.492 log
Post by: gs001 on July 08, 2015, 04:47:31 PM

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.

Title: Re: SQLite errors in ver 1.492 log
Post by: dani on July 10, 2015, 11:58:43 AM

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

Title: Re: SQLite errors in ver 1.492 log
Post by: gs001 on July 10, 2015, 08:26:26 PM

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

Title: Re: SQLite errors in ver 1.492 log
Post by: gs001 on July 11, 2015, 06:01:31 AM

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