How does Cintanotes sqlite db identify "worked" files from "halfworked" files?

Pacerier
Posts: 32
Joined: Fri Mar 31, 2017 6:40 pm
Contact:

How does Cintanotes sqlite db identify "worked" files from "halfworked" files?

Postby Pacerier » Sat Apr 22, 2017 12:35 am

I created a brand new Cintanotes DB, and added some test content.

The content can be found in the sqlite table NotesData_content. But how does Cintanotes identify which are the normal notes and which are the "halfworked" (popup) notes?

(I'm in desperate need to recover some important data and I was hoping to salvage them in the raw sqlite database, anyone with any info on the database structure please share some advice.)
---
User avatar
CintaNotes Developer
Site Admin
Posts: 4741
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: How does Cintanotes sqlite db identify "worked" files from "halfworked" files?

Postby CintaNotes Developer » Sat Apr 22, 2017 5:07 pm

There are no "halfworked" notes. CintaNotes only stores the ids of notes that should be reopened, in cintanotes.settings file.
Your notes were saved when you exited CN or shutdown the PC. But if CN crashed then it is possible that the information was lost. Sorry.
Alex
Pacerier
Posts: 32
Joined: Fri Mar 31, 2017 6:40 pm
Contact:

Re: How does Cintanotes sqlite db identify "worked" files from "halfworked" files?

Postby Pacerier » Sun Apr 23, 2017 7:10 am

I have a dump file which I believed Cintanotes had generated at the point of crash: cintanotes_20170421-1208.dmp

Is there any possible salvageable information within the file cintanotes_20170421-1208.dmp ?
---
User avatar
CintaNotes Developer
Site Admin
Posts: 4741
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: How does Cintanotes sqlite db identify "worked" files from "halfworked" files?

Postby CintaNotes Developer » Tue Apr 25, 2017 2:39 pm

I'm afraid that the dump won't help here. It's not a full memory dump. Sorry.
Alex
Pacerier
Posts: 32
Joined: Fri Mar 31, 2017 6:40 pm
Contact:

Re: How does Cintanotes sqlite db identify "worked" files from "halfworked" files?

Postby Pacerier » Mon May 01, 2017 1:32 am

Hi admin, I've got many of such dump files.

What kind of data is stored within the file? I might be able to salvage some clues from it using a reader.
---
User avatar
CintaNotes Developer
Site Admin
Posts: 4741
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: How does Cintanotes sqlite db identify "worked" files from "halfworked" files?

Postby CintaNotes Developer » Wed May 03, 2017 10:08 am

This is a minidump file. It usually contains the general information about execution state. The edited but unsaved information is not there.
Still please send them to me to support@cintanotes.com, I'll analyze them to see if there's anything useful there.
Alex
Pacerier
Posts: 32
Joined: Fri Mar 31, 2017 6:40 pm
Contact:

Re: How does Cintanotes sqlite db identify "worked" files from "halfworked" files?

Postby Pacerier » Thu May 04, 2017 11:28 am

It should be possible to observe the dump files to determine if a note is opened or unopened at the point of crash.

What are the variables in which those state are stored?
---
User avatar
CintaNotes Developer
Site Admin
Posts: 4741
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: How does Cintanotes sqlite db identify "worked" files from "halfworked" files?

Postby CintaNotes Developer » Thu May 04, 2017 12:15 pm

Well I doubt it will help, but nevertheless - who knows maybe your debugging skills are better than mine and you'll be able to extract
this info from the dump despite the lack of PDB files and it being serously obscured by the Enigma Protector!

Inside of CN, there's a class NoteEditManager that has a collection of NoteEditDialogs.
Each NoteEditDialog has several variables of type Note:

note: represents the most recent state of note (updated from UI controls)
originalNote: represents the note as it was loaded from the database

Each Note has fields:
id - id in the Notes table
uid- global note id, used for sync
Alex

Return to “CintaNotes Personal Notes Manager”