
+2
Not a bug
"SQLite Error 19: column num is not unique" when moving note to top
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
take a look here: http://dl.dropbox.com/u/563640/reportbugcintanotes.png
Answer

0
Answer
Not a bug
Alex Jenter 14 years ago
Closed because 1) Can't reproduce and 2) No further upvotes after 4 months.

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) :)...
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.
Export/Selected command exports notes in the order they currently appear on screen.

Just take your database and replace sensitive data with arbitrary text. But it's important that you don't delete notes.

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.
Customer support service by UserEcho