Solaredge database

Topics (not sure which fora)
when not sure where to post, post here and mods will move it to right forum.

Moderators: leecollings, remb0

Post Reply
Franzie
Posts: 30
Joined: Wednesday 09 January 2019 17:10
Target OS: Raspberry Pi / ODroid
Domoticz version: 2020.1
Location: Nederland
Contact:

Solaredge database

Post 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
User avatar
FireWizard
Posts: 1862
Joined: Tuesday 25 December 2018 12:11
Target OS: Raspberry Pi / ODroid
Domoticz version: Beta
Location: Voorthuizen (NL)
Contact:

Re: Solaredge database

Post by FireWizard »

Hi,

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

Regards
Franzie
Posts: 30
Joined: Wednesday 09 January 2019 17:10
Target OS: Raspberry Pi / ODroid
Domoticz version: 2020.1
Location: Nederland
Contact:

Re: Solaredge database

Post by Franzie »

Thanks. I did read but even then I don't know what to do to repair! I'm not into SQL!
Franzie
Posts: 30
Joined: Wednesday 09 January 2019 17:10
Target OS: Raspberry Pi / ODroid
Domoticz version: 2020.1
Location: Nederland
Contact:

Re: Solaredge database

Post 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?
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest