1. Home
  2. Framework
  3. Repair Snapt Aria SQLite DB

Repair Snapt Aria SQLite DB

If you are receiving an error in Snapt Aria with the keywords: There has been a serious error: SQLSTATE then you likely have a crashed or corrupted SQLite database.

What is SQLite and what does Snapt use?

Snapt Aria uses two SQLite databases – one which is for Snapt Aria information and one that is for logging data.

These may be marked as “crashed” in the case that you lose power while writing or if something else goes wrong.

The databases are located in “db/” – typically you’ll find them in one of the two directories:




. The databases in these directories are called “log.db” and “snapt.db“.

You can repair them by running one of the following commands:

Log DB

mv log.db log-broken.db
echo ".dump" | sqlite3 log-broken.db | sqlite3 log.db


mv waf.db waf-broken.db
echo ".dump" | sqlite3 waf-broken.db | sqlite3 waf.db

Snapt DB

mv snapt.db snapt-broken.db
echo ".dump" | sqlite3 snapt-broken.db | sqlite3 snapt.db

Setting Permissions (Import to run this one afterward)

chmod 777 log.db waf.db snapt.db

After you have run the command you should now be able to login to your Snapt Aria interface.

If this does not solve the problem please restore a backup, or log a ticket at:  support.snapt.net

Updated on March 24, 2020

Was this article helpful?

Related Articles