Fix a corrupt WSL database

Fix a corrupt WSL database

In this article we describe how to fix a corrupt WebSolarLog SQLite database.
This guide is only for SQLite databases, please see your Admin::Diagnostics to see on which database type your WebSolarLog is running.

First WE NEED TO MAKE a BACKUP of the database

Go to the WebSolarLog/database directory on your server/host

Stop WSL;
WebSolarLog/scripts/ stop
Creat backup of wsl.sdb;
cp wsl.sdb wsl_backup.sdb

Move the original database;
mv wsl.sdb wsl_original.sdb


Lets do it!

Assuming that you are still in the WebSolarLog/database/ directory, run the following commands;
sqlite3 wsl_backup.db

We first run the following integrity command to make sure the database needs some repairs. On the SQLite prompt you run:
pragma integrity_check;

If the result is OK, the database is not corrupted and needs no further actions.

you can quit SQLite by :

restore the old database;
mv wsl_original.sdb wsl.sdb

If you have error messages you could proceed to Next Steps.


Export Data to plaintext file

To export the WebSolarLog data to an plaintext sql file, run the following commands:

echo .dump | sqlite3 wsl_backup.sdb > wsl_plaintext.sql

Now we have a plaintext file with readable SQL data/commands. You could read the file;
nano wsl_plaintext.sql

Create a new WSL database

Now we have a plaintext file with the data, we need to create a new database

To create a new WSL database, just run the following command:

cat wsl_plaintext.sql | sqlite3 wsl.sdb

This command creates a new WSL database with the original data from the corrupt database.


We are Ready!

If there are no errors, then we could start WSL;

WebSolarLog/scripts/ start

For further support, please visite our support group;!forum/websolarlog

Weather Forecast: after rain comes sunshine

Recently we added support for the free “OpenWeatherMap – free weather data and forecast API” to WebSolarLog.

With the data from OWM we can do a lot of cool stuff;

  • Display the current weather conditions
  • Display the weather forecast for X days
  • Solar calculations based on the “real(time)” outside temperature
  • Push your local weather condition to PVoutput
  • Maybe a kWh forecast based on cloud conditions
  • and many many more

How to configure WebSolarLog for OWM:

  1. Go to the Admin
  2. Go to the General tab
  3. Fill the Lat and Long field
  4. Save the General settings
  5. Go to the Inverters tab
  6. Click the button “new inverter” i know it is odd, we do some magic and change the “inverter” into a weather station 😉 )
  7. Give the “inverter” a name, example; “Weather Station”
  8. Change Device Api into “Open Weather Map”
  9. Change Device type info “Weather”
  10. Save the inverter
  11. We are done with the configuration of the Weather station.

From now WebSolarLog will retrieve every 5 minutes the realtime weather conditions for your location based on the location you gave in Admin::General

At the moment WebSolarLog doesn’t show the weather data, but this will change in de near feature.

Announcement: WebSolarLog troubles in combination with SMAspot

The last days we heard from users that they have troubles with Websolarlog in combination with SMAspot.We investigated a few of these issues and our conclusion is;
WebSolarLog is not compatible with other versions then SMAspot 2.0.4We strongly advice all WebSolarLog users with SMAspot to only use “SMAspot 2.0.4” until we have solved this issue.

At the moment we work, with the SMAspot developers, on a SMAspot version which is fully compatible with WebSolarLog for now and the future.

We apologize for this issue and hope to solve it soon.

Code freeze

We want to release an stable version off websolarlog. However new features keeps coming. We have decided to make the current features more stable and fix bugs we encounter. When things are stable the first official stable release will an fact.


If you have any questions, suggestions or what so ever regarding this post, feel free to post on our google support forum: