Page 1 of 1

Database errors etc.

Posted: Tue Jun 18, 2013 9:23 am
by gnarf
I get all kinds of database errors since 1 week ago.
i can't edit and save my notes but I can open them OK.
I upgraded to 2.2.1 Beta a week ago while I was travelling, this temporaliry solved my problems for a few days.
The brand new version 2.2.3 have the same problem.

"Database malformed", "class err invalid state exception" after editing a note. :cry:
What is the cause of this?

I am a registrated user.

Re: Database errors etc.

Posted: Tue Jun 18, 2013 10:39 am
by kp_denis
Hello.

Please try attached CintaNotes.exe, this version contains database auto fixing logic.
If this doesn't solve problem, please send log file created by attached CN version (use menu option Help\Debug\Debug Logging) to support@cintanotes.com .

Best regards, Denis.

Re: Database errors etc.

Posted: Tue Jun 18, 2013 4:30 pm
by gnarf
Where can i find the file to send in? Looked but dunno what file you mean?

Re: Database errors etc.

Posted: Tue Jun 18, 2013 5:43 pm
by Thomas Lohrum
gnarf wrote:Where can i find the file to send in? Looked but dunno what file you mean?

On Win7 you'll find it here C:\Users\<your user-name>\AppData\Roaming\CintaNotes\log.1.txt. The name of the log-file may vary. Thus check for the timestamp of the logfile.

Thomas

Re: Database errors etc.

Posted: Tue Jun 18, 2013 6:43 pm
by gnarf
Thomas Lohrum wrote:
gnarf wrote:Where can i find the file to send in? Looked but dunno what file you mean?

On Win7 you'll find it here C:\Users\<your user-name>\AppData\Roaming\CintaNotes\log.1.txt. The name of the log-file may vary. Thus check for the timestamp of the logfile.

Thomas


I will send you some files because same problem...

Re: Database errors etc.

Posted: Thu Jun 20, 2013 1:32 am
by CintaNotes Developer
gnarf wrote:I will send you some files because same problem...

Thank you, please check your mail..

Re: Database errors etc.

Posted: Tue Jul 02, 2013 6:12 am
by CintaNotes Developer
In order to avoid DB corruption in future, I strongly advise to do the following:

open cintanotes.settings and change the lines
sqlite.pragma.journal_mode = MEMORY
to
sqlite.pragma.journal_mode = DELETE

and
sqlite.pragma.synchronous = OFF
to
sqlite.pragma.synchronous = NORMAL

People who need maximum reliability might also consider
sqlite.pragma.synchronous = FULL
(but it will make CN IO operations slower)

CintaNotes 2.3 will change dangerous settings automatically.