Hi,
i have a database file that is corrupted. That means: Ich can take a look at everything, but as soon as i change some specific things (or try to delete something) then i get this error and can't do anything anymore. The problem is reproducible.
Win7 64
Newest CintaNotes version right now (2.2)
I would love to work again with my notes and i can provide the database to analyze the problem but only if the data inside will be threated with security (will only provide the file to the developer).
Cheers,
DS
PS: See the screenshot for details
Database Exception SQLite Error 19
-
- Posts: 18
- Joined: Wed Mar 25, 2009 12:47 am
- Contact:
Database Exception SQLite Error 19
- Attachments
-
- CintaNotes Bug.png (152.68 KiB) Viewed 10483 times
-
- Posts: 1324
- Joined: Tue Mar 08, 2011 11:15 am
Re: Database Exception SQLite Error 19
Hi DStrohma,
i've just created a post, which will provide information on how to recreate your data.
Check here: http://www.cintanotes.com/forum/viewtopic.php?f=3&t=156&p=7331#p7331
Come back in case you need more help.
Please provide information, what caused your trouble. Is it reproducible? Please turn on debugging and provide a log in case this should happen again; see help\debug\[*] debug log.
Thanks for your help.
Thomas
i've just created a post, which will provide information on how to recreate your data.
Check here: http://www.cintanotes.com/forum/viewtopic.php?f=3&t=156&p=7331#p7331
Come back in case you need more help.
Please provide information, what caused your trouble. Is it reproducible? Please turn on debugging and provide a log in case this should happen again; see help\debug\[*] debug log.
Thanks for your help.
Thomas
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Database Exception SQLite Error 19
Hi DStrohma,
really sorry that this has happened. Do you have any idea what might have lead to this situation?
It would be very important to recreate the steps which lead to such corruption.
The best option for us is if you could send the corrupted database over to us,
but I understand very well that this might not be an option.
Also please follow Thomas's advice on data recovery - by now he's become an expert
on the topic
really sorry that this has happened. Do you have any idea what might have lead to this situation?
It would be very important to recreate the steps which lead to such corruption.
The best option for us is if you could send the corrupted database over to us,
but I understand very well that this might not be an option.
Also please follow Thomas's advice on data recovery - by now he's become an expert
on the topic
Alex
-
- Posts: 18
- Joined: Wed Mar 25, 2009 12:47 am
- Contact:
Re: Database Exception SQLite Error 19
I will send the developer the corrupted database file. Hope he can find the problem
Here is what i have done till the exception happened:
1) I had two caterories and created a new one (a new tab)
2) I added notes to the new tab (the tab was colled 'Akquise')
3) I tried to delete the note "Novero GmbH"
4) Got the exception.
I think the problem occured when i added the third category. Before that everything worked fine. There are also some other exceptions (but all database related) if i want to (for example) change a note - specifically the note "Arbeitszeit pro Woche" in another category.
Cheers
Here is what i have done till the exception happened:
1) I had two caterories and created a new one (a new tab)
2) I added notes to the new tab (the tab was colled 'Akquise')
3) I tried to delete the note "Novero GmbH"
4) Got the exception.
I think the problem occured when i added the third category. Before that everything worked fine. There are also some other exceptions (but all database related) if i want to (for example) change a note - specifically the note "Arbeitszeit pro Woche" in another category.
Cheers
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Database Exception SQLite Error 19
Hi DStroma,
sorry but didn't receive the file.. could you please send it to support@cintanotes.com ?
Huge thanks in advance!
sorry but didn't receive the file.. could you please send it to support@cintanotes.com ?
Huge thanks in advance!
Alex
-
- Posts: 18
- Joined: Wed Mar 25, 2009 12:47 am
- Contact:
Re: Database Exception SQLite Error 19
Hi,
i've send you the file per mail.
Cheers,
DS
i've send you the file per mail.
Cheers,
DS
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Database Exception SQLite Error 19
I got it, thanks! Will get back to you as soon as we have any information.
Alex
-
- Posts: 18
- Joined: Wed Mar 25, 2009 12:47 am
- Contact:
Re: Database Exception SQLite Error 19
The provided fix workes perfectly. Thanks!
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Database Exception SQLite Error 19
Great to hear that, thank you very much for your help.
Of course we'll include the fix into the next update.
Of course we'll include the fix into the next update.
Alex
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Database Exception SQLite Error 19
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.
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.
Alex