Page 1 of 1

[ANSWERED]SQL Logger Error

PostPosted: Thu Feb 13, 2014 7:08 am
by mlooss
Today my log is full with these messages? It looks like my DB became corrupted/damage, but how and and how can I fix it?

SQL Logger Error exception trying to insert row into table device_history_1568303338 ("SJU Wind Speed MPH")
SQL Logger Error database disk image is malformed

Re: SQL Logger Error

PostPosted: Thu Feb 13, 2014 3:28 pm
by jay (support)
To clear the error, just delete the database file (the path to the file is listed in the plugin's config dialog). If you want to try and save the data in the file you can just roll back to an earlier (uncorrupted) backup. If you don't have a backup, you can attempt to do the recovery yourself but it's a fairly technical procedure.

Note - if you don't actually want the data but you enabled the plugin for use with the Error in Event Log trigger, just uncheck all the checkboxes in the config dialog.

Re: [ANSWERED]SQL Logger Error

PostPosted: Fri Oct 03, 2014 10:01 am
by waveuk
I had this issue twice in 2 weeks. Is this something normal with this plugin? What could be the cause of this corruption?

Re: [ANSWERED]SQL Logger Error

PostPosted: Fri Oct 03, 2014 5:31 pm
by jay (support)
Crashes are usually the culprit - or a power outage.

In the worst case, you may be having issues with your hard drive - repairing it using Disk Utility is a good plan if it continues to happen.