Page 1 of 1

SQLite error 11 when search for letter a

Posted: Tue Oct 18, 2016 6:32 pm
by fortran
Hi.
Cintanotes 3.3.1,3.4
OS: Windows 7 SP1 64bit.

When i try to search in notes, i type english letter "a" in search bar and have that error:
Image
then i close cintanotes, restore database (with slite3 .dump, .read, and pragma user_version=...).
Also i change folder where saved this database to other drive and check memory with memtest86 (no errors).
When i check it later - it appears again.

When i search for other letters and languages (russian), all rights.
May be i need most thoroughly check my database (or post it elsethere)?

Re: SQLite error 11 when search for letter a

Posted: Wed Oct 19, 2016 5:21 am
by CintaNotes Developer
Hi. Have you tried exporting the DB to XML and importing it into a new .db file?

Re: SQLite error 11 when search for letter a

Posted: Wed Oct 19, 2016 6:12 am
by fortran
No, i tried restore with sqlite3 (dump current database and then read dump into new database (also setting user_version)).
I try export to with XML later.

Re: SQLite error 11 when search for letter a

Posted: Wed Oct 19, 2016 6:16 am
by CintaNotes Developer
Ok, please let me know how it goes, thanks!

Re: SQLite error 11 when search for letter a

Posted: Wed Oct 19, 2016 6:29 pm
by fortran
Ok, i am export notes from my database to xml. Then create new database and import them.
Export:
Image
Import
Image
Hmm... this point that were imported 103 notes and skipped 1 duplicate. Cintatnotes show 2 my sections with 89 and 15 notes.
It seems all rights, error with letter "a" does not occur.

Re: SQLite error 11 when search for letter a

Posted: Thu Oct 20, 2016 9:02 am
by CintaNotes Developer
Thanks for the update.
Why do you find the numbers suspicious, are you sure there wasn't any duplicates?

Re: SQLite error 11 when search for letter a

Posted: Thu Oct 20, 2016 5:48 pm
by fortran
May be i mistake when import notes from xml :?
I suppose that no posibility to make 'duplicates' in notes database.
Now i tried again export and import via xml (on those database), and all is ok, imported all 104 notes, no duplicates.

Re: SQLite error 11 when search for letter a

Posted: Thu Oct 20, 2016 10:07 pm
by date
fortran wrote:I suppose that no posibility to make 'duplicates' in notes database.
Now i tried again export and import via xml (on those database), and all is ok, imported all 104 notes, no duplicates.
Maybe second time you checked 'allow duplicates' when importing.

One way to confirm duplicates:
- Open the database that CN said contained duplicates, export to TXT, check 'all notes' and leave just the titles checked (so uncheck text, date, link, etc.) and make the text file.
- Open the text file which has all the titles, and paste it here: http://textmechanic.com/text-tools/basi ... ate-lines/
- Check 'display removed' and then click 'Remove duplicate lines.' Now in the text field below there will be all duplicate titles (except empty ones.) Not perfect but this will maybe narrow it down.

(Your text stays local and is not uploaded to their servers btw.)

Re: SQLite error 11 when search for letter a

Posted: Fri Oct 21, 2016 7:03 am
by CintaNotes Developer
Thanks for your input, date! Nice technique