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:
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)?
SQLite error 11 when search for letter a
-
- Posts: 4
- Joined: Tue Oct 18, 2016 6:15 pm
- Contact:
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: SQLite error 11 when search for letter a
Hi. Have you tried exporting the DB to XML and importing it into a new .db file?
Alex
-
- Posts: 4
- Joined: Tue Oct 18, 2016 6:15 pm
- Contact:
Re: SQLite error 11 when search for letter a
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.
I try export to with XML later.
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
-
- Posts: 4
- Joined: Tue Oct 18, 2016 6:15 pm
- Contact:
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: SQLite error 11 when search for letter a
Thanks for the update.
Why do you find the numbers suspicious, are you sure there wasn't any duplicates?
Why do you find the numbers suspicious, are you sure there wasn't any duplicates?
Alex
-
- Posts: 4
- Joined: Tue Oct 18, 2016 6:15 pm
- Contact:
Re: SQLite error 11 when search for letter a
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.
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.
-
- Posts: 243
- Joined: Sat Aug 01, 2015 5:15 am
- Contact:
Re: SQLite error 11 when search for letter a
Maybe second time you checked 'allow duplicates' when importing.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.
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.)
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact: