SQLite error 11 when search for letter a

fortran
Posts: 4
Joined: Tue Oct 18, 2016 6:15 pm
Contact:

SQLite error 11 when search for letter a

Postby fortran » Tue Oct 18, 2016 6:32 pm

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)?
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: SQLite error 11 when search for letter a

Postby CintaNotes Developer » Wed Oct 19, 2016 5:21 am

Hi. Have you tried exporting the DB to XML and importing it into a new .db file?
Alex
fortran
Posts: 4
Joined: Tue Oct 18, 2016 6:15 pm
Contact:

Re: SQLite error 11 when search for letter a

Postby fortran » Wed Oct 19, 2016 6:12 am

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.
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: SQLite error 11 when search for letter a

Postby CintaNotes Developer » Wed Oct 19, 2016 6:16 am

Ok, please let me know how it goes, thanks!
Alex
fortran
Posts: 4
Joined: Tue Oct 18, 2016 6:15 pm
Contact:

Re: SQLite error 11 when search for letter a

Postby fortran » Wed Oct 19, 2016 6:29 pm

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.
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: SQLite error 11 when search for letter a

Postby CintaNotes Developer » Thu Oct 20, 2016 9:02 am

Thanks for the update.
Why do you find the numbers suspicious, are you sure there wasn't any duplicates?
Alex
fortran
Posts: 4
Joined: Tue Oct 18, 2016 6:15 pm
Contact:

Re: SQLite error 11 when search for letter a

Postby fortran » Thu Oct 20, 2016 5:48 pm

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.
date
Posts: 243
Joined: Sat Aug 01, 2015 5:15 am
Contact:

Re: SQLite error 11 when search for letter a

Postby date » Thu Oct 20, 2016 10:07 pm

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.)
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: SQLite error 11 when search for letter a

Postby CintaNotes Developer » Fri Oct 21, 2016 7:03 am

Thanks for your input, date! Nice technique
Alex

Return to “Bug Reports”