Softvoile support forum

One more help.

if you visit this thread:
http://forum.idimager.com/viewtopic.php?f=2&t=6154
you will find that some person was having problem with his database. Though it was a different software, but it was same sqlite3 database giving "Sqlite error 11 –database image is malformed".

And, the, this person, moderator jgodfrey helped him by recovering almost all his data intact.

When I had problem, i contacted him and he replied promptly, even provided me guest login on his ftp server so that I could load the corrupted file there in privacy.

So, in case you have problem in database, you can try your luck by contacting him and seek his help. His own site is:
http://www.jeffgodfrey.com/ and his email id mentioned in the "contact" of his site is jeff_godfrey at pobox dot com

HTH.

Hello VSRawat

Great! Thank you for taking the time to share your experience to other
people!

I have nothing to add, except I use wxSQLite GUI Browser to view database
http://translate.google.com/translate?u ... en&ie=UTF8

And in the worst case if nothing else worked, you can use the brute force method to recover whatever data.

Make a copy of notes2.db file (say, copy it to tmp.db) and open that file in any text editor. But, you must NOT NOT NOT open it in MS Word or OpenOfficeWriter etc which format the text. Always open it in a raw text editor Depending on the size you can open it it notepad, but if it is bigger, notepad wouldn't open it. TED Notepad is good, but I personally use free METAPAD which is a very power 96KB text editor especially because it allows find/ replacement of tab/ newline etc which other editors mostly don't allow.

So open this copy, tmp.db in METAPAD. It will take time if it is large file and it will remove all binary codes except the tab etc. Good enough. In any case, flashnote was not storing any formatting controls.

Now, just go to the entire file and just manually delete all the large portions of illegible characters that you see anywhere. These were database indices and other coding and not directly related to what you had saved in Flashnote.

OK. Now, you will see that the file has one space after each letter. So you need to remove them. But removing single space will remove normal spaces between words. So, a genuine space has got expanded to three spaces. Hence, you replace thre consequent spaces to something else (I used $$$) that is not likely to be present in your actual text. After that just replace a single space with nothing, so that all single spaces disappear. Now replace that $$$ (or whatever you chose) back to a single space.

Good, now you see all your actual words together separated by a single space. If you had saved multiple spaces, those are also gone, but nothing can be done about that that I know.

Now, it had saved a crlf (newline - carriage return - linefeed) as double. So you replace two newlines with a single newline. (you can do it in metapad by replacing \n\n with \n with control chars on). Well. now your words and spaces and lines are proper.

Keep on saving your file as a text file after each modification.

This is what you can recover. It is all in different order than the order in which it was in various notes pages, it is probably in the order in which you had saved it in flashnote, but still larger chunks of a note will be together.

Now, you can manually create your original structure back in new installation of flashnote, and copy the data from this text file back to various notes and arrange them in order.

HTH.

Having faced problem with database file (notes2.db), I have tried some direct methods. If you have some problem, you can try using these to try your luck to recover your data.

Hope moderator would let this topic remain so that users can have some alternative to work with in case of corrupt database. Hope moderator would add his own information to help people in it.

Flashnote's notes2.db file uses sqlite format 3. Its homepage is http://www.sqlite.org/index.html. The latest version as on date is Version 3.5.7 which can be downloaded for various O.S. from http://www.sqlite.org/download.html The documentation is at http://www.sqlite.org/docs.html and at http://www.sqlite.org/sqlite.html, and there are some mailing lists for users/ developers/ announcements, whose past archives can also be reached from there.

but, this being a command line software might not come handy to GUI users. So there are some more software that handle the same in windows and mouse. Some are:

http://www.sqliteexpert.com/
The above has SQLite whose lastest version 1.6.38 can be found there as trialware and freeware.

http://sqlitestudio.one.pl/index.rvt
The above has SQLite Studio whose latest version 1.0.0-beta6 can be found above as free for non-commercial usage.

if you know of something else that is useful, please share info.

HTH.