+2
Not a bug

"SQLite Error 19: column num is not unique" when moving note to top

SunSham 14 years ago updated by Alex Jenter 14 years ago 11
i tried move one note to the top then got error "SQLite Error 19: column num is not unique" then i tried other note also same error.

take a look here: http://dl.dropbox.com/u/563640/reportbugcintanotes.png
error reordering

Answer

Answer
Not a bug
Closed because 1) Can't reproduce and 2) No further upvotes after 4 months.
im currently using latest version of CintaNotes... its 1.1C =/
Ok, did you export and re-import database?
still not work :(

i tested other time after export and re-import XML.. then it mess up manual sort by list :(... in other time, move to the top still same error "SQLite Error 19: column num is not unique".....

export XML dont have feature: manual sort by list... T_T

i forgot to say "Portable"...anyway, im currently using CintaNotes 1.1C Portable (because run from dropbox folder) :)...
Could you provide me with some minimal database where the error occurs? It would help debugging immensely.

Export/Selected command exports notes in the order they currently appear on screen.
How can i do that?
Just take your database and replace sensitive data with arbitrary text. But it's important that you don't delete notes.
SunSham, is the problem still there?
yes, still same problem after export then import... but i always use alt+UP like one by one.. hehehe..
It is important that you delete cintanotes.db after export. Did you do that?
but the problem is sort by after import... like tired of arrange it again... :(
You don't need to arrange again, just when export switch view to manual, as you'd like to see it after import.
Answer
Not a bug
Closed because 1) Can't reproduce and 2) No further upvotes after 4 months.