Edit Database

72 views
Skip to first unread message

Ronald Merema

unread,
May 19, 2016, 8:17:13 AM5/19/16
to WebSolarLog
I am using websolarlog for over a year now, and i am very satisfied with it.
But last month i had a crash of the sd card. i regulary make a back up on dropbox.
I had saved a image of websolarlog, so i have maked a new sd card, then i have transferd back the data from the back up.

Everything was working again.
but i do not make a back up every dat, so i was missing data.
I have manualy entered the missing data in the `Yields` field.

Bu when i now take a look to the production page i see an error.
I am missing march, and see 2 times april. even the data is not correct.
All the data in the Yields is correct entered.

How can i edit the database and correct the production page?
websolarlog.JPG

Ronald Merema

unread,
May 31, 2016, 12:09:23 PM5/31/16
to WebSolarLog
Nobody has an idea how to edit the database ?

Nico Bogaert

unread,
May 31, 2016, 4:03:29 PM5/31/16
to WebSolarLog
The database is just a single file SQLite database, so I'd think a tool like DB Browser should help you out... Haven't used it myself, but doesn't look that difficult to use, so if I were you I'd give it a try.

best regards,

Nico

Martin Diphoorn

unread,
Jun 17, 2016, 11:29:52 AM6/17/16
to WebSolarLog
There are lots of ways to edit an database. Most off the time i use sqlite3 to edit it. But that is all commandline. There is also something called sqllitemanager which you can install. This an webbased editor written in php.
The strange thing is dat the yield way should work.
Reply all
Reply to author
Forward
0 new messages