Softvoile support forum

It had been working all well and today I started getting this message.

Flashnote: Can't create the main table.
Error#1 - SQLITE_ERROR[1]: SQL logic error or missing database

and when I close and restart, the following comes:
---
Runtime Error!
Program C:\Program Files\Flashnot\Flashnote.exe

This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information.
---

and it doesn't restart.

I renames the database file to something else, it created new in the same folder but it is still not starting.

what to do? I hope my data is safe. I have saved a lot of things to it.

It's seems that database was corrupted



It's very strange, I don't know what did happen. Did you try to re-install it?

I installed it (without uninstalling), no help.

I uninstalled and reinstalled, no help.

Then I tried to delete the database files, (I had kept copies) and I could not delete a file named "notes2.db-journal" that was 80 KB. Window reported file system error on that file.

I could not delete it (not even till now) but I could rename that to something else, and then Flashnote worked.

Then I closed flashnote, deleted the new blank note2.db that it had created. Copied the old note2a.db (that I had renamed) back to note2.db. and I continue working.

It is now working fine, all my previous entries are safe only that some entries that I had made in that session are gone. I don't even know whether I had added what in that session.

It is working fine ever since. just that "notes2a.db-journal" file is stuck on my folder and I can not delete that.

btw, what is that file? I had never noticed it earlier.

hope this will give you some clue to find out and resolve what went wrong.

thanks.

I have been now using flashnote so widely that almost anything I need to save I first copy to flashnote immediately, and after two or three days or a wekk, do housekeeping and copy from flashnote to various disk files.

even non-pc things, like someone giving me some info on phone, I am storing in flashnote.

I am keeping the log of my work also in flashnote.

It is so convenient and useful.

It would be a nightmare if my flashnote database disappears. I might face a heart attack.

It might need some modification in flashnote to prevent loss of data in such cases.

Maybe you can consider to include some automatic periodic backup of entire flashnote database to some single file. Every 4 hours or so, it should automatically save the database to a text file.

thanks.

Notes2.db-journal is temporary file that database engine creates while updating main database. It should be automatically deleted. It's seems as some file system error occurred while Flashnote trying to save its database.

About backup, I suggest you use any backup utility to automatic flashnote database. Or you can do this by hand using File -> Export databases to txt files.

I don't know now how Flashnote will develop further. Probably I will rewrite it from scratch. I am trying to do this now, but I am very busy with other projects, so I can not promise.

It is working good now, but my faith has shaken a bit. It has become so important and I had so many tidbits it that, what if it disappears.




hmm. we need something within flashnote to do it. There is no point in taking the backup of entire hd for just this file.

And, the export database is not at all practical as it creates a folder for every note and puts subnotes in individual separate files. So if we need to check something, we need to open each file one by one. Not practical. It would help if it given option to save entire database to a single text file.



Having been using pc for 25 years, having pc/ net at my home for last 10 years, and having used 1000s of softwares, I can say that Flashnote is an outright winner utility. It is so simple, so convenient, so useful. With proper advertising, I am sure that every user would install it on his pc.

so, don't give up on this utility. Your concept is an essential basic for every pc. It needs some improvements that will increase its convenience multifold, but it is very useful without that itself.

thanks.

It had been working all well and today the inverter tripped during a power failure while I was working in a flashnote window. When the system restarted, I am getting this warning.

Flashnote: Can't open database.
Error#1 - SQLITE_ERROR[11]: database disk image is malformed

on close the warning window, the following comes:
---
Runtime Error!
Program C:\Program Files\Flashnot\Flashnote.exe

This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information.
---

On givine OK on the above, it gives
--
Flashnote has encountered a problem and needs to close. We are sorry for the inconvenience.

If you were in the middle of something, the information you were working on might be lost.

for more information about this error, click here.
--

clicking on click here gives
--
Error Signature
AppName: flashnote.exe AppVer: 2.1.0.0 ModName: flashnote.exe
ModVer: 2.1.0.0 Offset: 00043fb0

to view the technical information about the error report, click here.
--

this click here gives a long file.
--------------------------

it is not starting.

there is a notes2a.db-journal file of 80 KB, renaming it does not make it work.

However, if I rename notes2.db, it starts but creates a new blank notes2.db file.

I installed without uninstalling, no use.

I uninstaled and then reinstalled, no use.

I fear their is nothing that can be done, but if there is please be kind to tell me.

I have reported the first similar error previously and u said that databse is corrupted, however at that time I tweaked and it worked with some minimal loss. This time I have done all that and have run out of ideas and it is not working.

If the database is so prone to corruption, the software should automatically make, each time it opens, and keep 3 or 5 or 8 backups. Nor have you included any option in the software to take periodic hourly, daily or weekly backup. All we can backup is manually and then, it doesn't take back from the backed up file as such to recreate the existing working set of notes and subnotes.

and you never provide any information about the database file, nor share any software that would open the db file directly facilitating us to compact it or take backups, etc. You don't even tell which db format you are using.

It has been an year when the last update was released on April 17th, and no new update has been released.

my faith in this software has gone. It is badly designed. All my months of important information that I was saving in flashnote is gone and you don't give any hint to how to restore it.

If you have given up on this software, u should be upright enough to mention it on its home page. But, I would say that you should find time to improve it by including some of the several suggestions given.

sorry to say all this, but what else can I do when my months of data has vanished.

Hello VSRawat



There is no sense in other sqlite browser if database was malformed. If Flashnote can't open it, any other viewer won't open it as sqlite database. In case of working database there is no sense to open flashnote database in other software:) But I don't hide this information in any case, everybody who asks me gets answer.


New beta version, rewritten from scratch will be available in one week.



I see that you did investigate this in other topic. I really never had such problem, my database has never been corrupted. Thanks for sharing your experience!




It's really bad:( But I should say, that you should do backup of any important data often. Independently, what software creates data.

Hi dear,

now that the initial disappoitnment of loosing the data has subsided, I can think more clearly. Firstly, I am extremely sorry that I used very harsh words in my above mail. It was just due to my sadness on loosing the data. The software is good and very handy. I have regularly using it and I have recommended it to many persons. I again reinstalled it and continuing to use it.



again, sorry for the harsh word. I am continuing to use it.

Actually, none of the method I mentioned in the other thread worked so I went to the last one, brute force I called it.

I opened the db file in metapad, cleaned it as mentioned and manually copied data to new installation of flashnote. Several information is lost, the information was highly fragmented, there were several repeatation of different versions of the same information, so I had to manually arrange it in the new notes, but I would say that 90% of information could be recovered.

What is interesting that the corrupted notes2.db was 16.5 MB. I have recovered half the information, and the new notes2.db is coming just 334 KB, and remaining corrupted notes2.db is 327 KB with still quite a some junk in it.

so, what would some to some 600 KB in a fresh notes2.db was spread in some 16.5 MB in the original file. That is unreasonable.

That is why I seek you to give some option to pack/ compact the database periodically, to remove earlier versions of same information that had been since updated.

and maybe you could consider giving some defragment option so that information gets copied to a fresh notes2.db and written there in sequence so that it will be convenient to recover in case of problem.

Anyway, I will not nag you more. You yourself had come up with such a lovely software, so I am sure that in the new version also, you must have packed many conveniences and magics. Looking forward to use beta.

Hope beta will pick the data from existing notes2.db and would coexist in a different folder because flashnote has become such an essential thing for me that if there is any problem with beta and my data goes again, I will be at a loss.

thanks.

Hello VSRawat




Flashnote compacts database every time when this is needed. I think garbage in your file (<15MB) was appear due to damage of file system.



Yes, the new version will get data from current, but will use such folder as 2.x. But there is no problem, you can make backup before install the new version in any time return to old.

Thanks for sharing info about beta. Eagerly looking forward to get to use it.

In the existing system, I faced one difficulty that while saving backup, it saves notes/ subnotes, arranged in folders/ subfolers managing and searching in which become difficult. It would have been convenient if it could give option to store them all in a single long text file.

Also, while restoring data back from a backup, it asks for a single text file. I have not used the option as I could not understand it fully, but I assume it will take one text file and insert that as a note/ subnote ( i wonder if it was asking the option of inserting it as subnote). It would have been very convenient if it could take fn's saved backup folder and recreate all notes/ subnotes as it had saved. i wonder if it was already doing that.

also, it would be convenient if it could restore from that above suggested single long page text file. it might have some codes enbedded to define notes/ subnotes, may be it could be in xml format or some other that you feel convenient for the setup.

After months of usage, I can vouch that its usage were simple and fast and convenient. If the corruption/ backup/ restore problem is solved, all the worries will be over.

thanks for your patience.

I will add option to export to single file, but in next version. I don't think that this is really critical just now.