Page 1 of 1

Solaredge database

Posted: Saturday 28 March 2020 16:24
by Franzie
Hi there

On the master RPi I have Solaredge data imported from a slave and since 1 day I have a error from the database. Is there a way to repair this without losing my entire database?

2020-03-28 16:16:31.475 Error: SQL Query("SELECT Value1, Value2, Value3, Value4, Value5, Value6, Date FROM MultiMeter WHERE (DeviceRowID==52) ORDER BY Date ASC") : database disk image is malformed

Re: Solaredge database

Posted: Saturday 28 March 2020 16:59
by FireWizard
Hi,

See this thread. Perhaps it is useful for you as well.
https://www.domoticz.com/forum/viewtopi ... se#p237666

Regards

Re: Solaredge database

Posted: Saturday 28 March 2020 20:40
by Franzie
Thanks. I did read but even then I don't know what to do to repair! I'm not into SQL!

Re: Solaredge database

Posted: Saturday 28 March 2020 20:45
by Franzie
Other question. When I restore a database from 3 days before why is the master RPi not reading the Solar data out of the database from the Slave RPi so that there is no gap in the Solar data on the master?
Is this normal, is the master not capable reading that data?