WhatPulse Forums » Support » Client software v » Critical database error - restore database fix and not loose stats solution Welcome back, Guest.


Post Reply 
 
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Critical database error - restore database fix and not loose stats solution
01-18-2019, 12:18 AM (This post was last modified: 01-18-2019 12:28 AM by bioforge.)
Post: #1
Information Critical database error - restore database fix and not loose stats solution
If you get the message:

Critical database error!
Something really bad happened to the database and the backup database. The only way to recover is to create a new database. This will not effect your unpulsed stats, but will wipe the rest. Continue?

There is a way to fix the database and not loose your stats.

1. Click No - two times
[Image: attachment.php?aid=1306]

2. Click Ok
[Image: attachment.php?aid=1308]

3. Download and install sqlitebrowser - DB Browser for SQLite
from here:

https://sqlitebrowser.org/

Go to "File/Open Database", navigate to your WhatPulse install location and open "whatpulse.db" (make a backup copy before opening if something goes wrong...)

On win7 it should be in:
C:\Program Files (x86)\WhatPulse2\whatpulse.db

4. Once database is opened, go to "Browse Data" tab and choose Table "pending_applications_stats", select all and click on "Delete Record". Refresh and see if anything pops up again, if it does just keep deleting till all is gone.

[Image: attachment.php?aid=1310]

5. Click on "Write Changes" and close sqlite browser.

6. Open WhatPulse, it should work normally now with all your previous stats preserved.

If you get the Critical database error again, after making a copy of your database from Program Files, also make a copy of the backup database from here:

C:\Users\ *your username* \AppData\Local\Application Data\whatpulse\whatpulse.db

And let WhatPulse wipe your database. Once it creates new database, close it and repeat steps 1-6 above. Close sqlite browser when finishesd, since WhatPulse can not write to the database if it is opened there.

This method works if your computer crashed, or if you hibernate often and it does not restart properly.

If this does not work work, in "app.log" that is located here:

C:\Users\ *your username* \AppData\Local\Application Data\whatpulse\WhatPulse\app.log

you can try to figure out from DEBUG lines where the problem is in the database, try to find it and delete it in your corrupted database, but good luck with searching for that...

Since you backed up your corrupted database you can also try to delete some other records and see if it will open normally.

It worked for me few times computer crashed, but last time it did not, but luckily I had not so old copy of the database and started again from there with out loosing much of the data. So if your database is having a lot of stats, you can periodically also make a backup copy of your database to some location, just in case.


Good luck!


Attached File(s)
.jpg  Image2.jpg (Size: 51.1 KB / Downloads: 76)
.jpg  Image3.jpg (Size: 35.67 KB / Downloads: 74)
.jpg  Image5.jpg (Size: 274.02 KB / Downloads: 72)
Find all posts by this user
Quote this message in a reply
Post Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  Yet another Critical Database Error sintholo 0 216 01-28-2019 11:24 PM
Last Post: sintholo
  Critical Database Error 5antoro 2 4,517 01-18-2019 06:51 PM
Last Post: bioforge
  I'm getting an error when trying to run WhatPulse on 16.04. breichart 0 282 12-03-2018 12:23 PM
Last Post: breichart
  Can't pulse, but no error? Wezzor 0 305 11-20-2018 08:50 PM
Last Post: Wezzor
  Partial stats/settings reset updating Linux x64 to 2.8.4 dgw 0 273 11-17-2018 09:21 AM
Last Post: dgw
  "Error: Wrong password!" upon pulsing, password not changed. Kelse 14 1,217 11-05-2018 05:27 PM
Last Post: Strazdas
  "Error while pushing!" AmokOwe 7 744 11-02-2018 03:30 PM
Last Post: jerone
  Database backup? iOChris 1 492 09-24-2018 12:52 AM
Last Post: scorpion6228
  Linux and Qt5 j000 6 2,145 08-07-2018 08:23 PM
Last Post: Endymion
Exclamation Complete stats wipe Vantropix 0 668 06-19-2018 03:12 PM
Last Post: Vantropix

Forum Jump:


User(s) browsing this thread: 1 Guest(s)