I'm not sure what happened but I'm using CintaNotes 2.4 and am getting the attached error. It shows up when I search for notes with special characters or when attempting to either delete a note fully or to the recycling bin. Please let me know if there is any other info needed to help resolve this issue.

Thanks Thomas but I didn't loose my data. All my notes are still there, I only have this error when searching using special characters or when attempting to delete a new note that I create. I did create a new tag in my db and it lets me search without error but when attempting to search all my notes or other tags with special characters I get the error. I'm more looking for a way to stop the error than to recover data (since I do not show it as being lost)

Thomas Lohrum wrote:You will no longer be able to use your database error-free. You need to rebuild. Happily none of your data got lost. To recover your data is the way to get rid of the database error.

Ok, sorry for any confusion. I was able to export all but one tag as an xml and import the rest. I still have the old db file that has that old malformed tag. I don't know how to get it to export or use sqlite3 to do it. Can anyone help there so I don't loose that tag? It's one of my biggest tags with most of my notes

really sorry for this issue. This is a long-time problem which we are struggling with.Changing your settings file should protect you from any further corruptions, howeverwith the already corrupted file we need to deal separately.

The easiest way would be for you to send the corrupted DB to support@cintanotes.comAnd although I assure you that it will be handled with the utmost care and security, I perfectly understand that this might not be an option.

If not, please tell if you are able to export any individual note from this 'corrupted' tag.Thanks!

Thanks but since I have work related notes in that corrupted tag I can't send the DB. I wish I could, to have someone look at, it but like you said, it's not an option. I am able to export individual notes from the tag but since I've been using CintaNotes since 2009 this tag is a bit "bloated" (4663 notes). It would take way too long to export one by one.

It would be nice to be able to get this back, but it's not the end of the world as I still have plenty of notes in other tags to search through when I need to look back to past notes. Thanks for the replies though

pablomentabo wrote:Ok, sorry for any confusion. I was able to export all but one tag as an xml and import the rest. I still have the old db file that has that old malformed tag. I don't know how to get it to export or use sqlite3 to do it. Can anyone help there so I don't loose that tag? It's one of my biggest tags with most of my notes

did you try to directly import from your old database? This is usually the easiest way to come up with a fresh database.

pablomentabo wrote:Ok, sorry for any confusion. I was able to export all but one tag as an xml and import the rest. I still have the old db file that has that old malformed tag. I don't know how to get it to export or use sqlite3 to do it. Can anyone help there so I don't loose that tag? It's one of my biggest tags with most of my notes

did you try to directly import from your old database? This is usually the easiest way to come up with a fresh database.

Thomas

Yes but it never finishes (I'm assuming when it gets to the corrupted tag it's failing). It just hangs trying to import them

pablomentabo wrote:Thanks but since I have work related notes in that corrupted tag I can't send the DB. I wish I could, to have someone look at, it but like you said, it's not an option. I am able to export individual notes from the tag but since I've been using CintaNotes since 2009 this tag is a bit "bloated" (4663 notes). It would take way too long to export one by one.

It would be nice to be able to get this back, but it's not the end of the world as I still have plenty of notes in other tags to search through when I need to look back to past notes. Thanks for the replies though

Probably not the whole tag is corrupted though, and I think that you can still rescue the majority of your notes.I suggest to use the "binary search" approach:1) Create a copy of your .db file2) Delete all notes except those having the corrupted tag3) Select the first half of notes and try to export4) If export succeeds, delete exported notes and goto 35) If export fails, select and try to export the second half of notes, then goto 4

This approach should allow you to rescue the most of your data. It may even be that only one note is in fact corrupted.

pablomentabo wrote:Thanks but since I have work related notes in that corrupted tag I can't send the DB. I wish I could, to have someone look at, it but like you said, it's not an option. I am able to export individual notes from the tag but since I've been using CintaNotes since 2009 this tag is a bit "bloated" (4663 notes). It would take way too long to export one by one.

It would be nice to be able to get this back, but it's not the end of the world as I still have plenty of notes in other tags to search through when I need to look back to past notes. Thanks for the replies though

Probably not the whole tag is corrupted though, and I think that you can still rescue the majority of your notes.I suggest to use the "binary search" approach:1) Create a copy of your .db file2) Delete all notes except those having the corrupted tag3) Select the first half of notes and try to export4) If export succeeds, delete exported notes and goto 35) If export fails, select and try to export the second half of notes, then goto 4

This approach should allow you to rescue the most of your data. It may even be that only one note is in fact corrupted.

Please let me know if it gives anything!

Thanks, got most of my notes back out of that one corrupt tag... still working on a bit in there to see if there was really only one corrupted note. I'd say this thread can be marked complete. Thanks again for the assistance

pablomentabo wrote:Thanks, got most of my notes back out of that one corrupt tag... still working on a bit in there to see if there was really only one corrupted note. I'd say this thread can be marked complete. Thanks again for the assistance

Glad that I could help, and sorry again for the inconvenience this has caused.In case something like this comes up again (theoretically it shouldn't if you've changed the settings file like I advised), please do let me know!