![](https://cdn.userecho.com/characters/83.png?1)
+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
![](/s/cache/75/c0/75c04d6568c1469c8b120f7401c43dca.png)
0
Answer
Not a bug
Alex Jenter 14 years ago
Closed because 1) Can't reproduce and 2) No further upvotes after 4 months.
![](https://cdn.userecho.com/characters/83.png?1)
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) :)...
![](/s/cache/75/c0/75c04d6568c1469c8b120f7401c43dca.png)
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.
![](/s/cache/75/c0/75c04d6568c1469c8b120f7401c43dca.png)
Just take your database and replace sensitive data with arbitrary text. But it's important that you don't delete notes.
![](https://cdn.userecho.com/characters/83.png?1)
yes, still same problem after export then import... but i always use alt+UP like one by one.. hehehe..
![](/s/cache/75/c0/75c04d6568c1469c8b120f7401c43dca.png)
It is important that you delete cintanotes.db after export. Did you do that?
![](https://cdn.userecho.com/characters/83.png?1)
but the problem is sort by after import... like tired of arrange it again... :(
![](/s/cache/75/c0/75c04d6568c1469c8b120f7401c43dca.png)
You don't need to arrange again, just when export switch view to manual, as you'd like to see it after import.
![](/s/cache/75/c0/75c04d6568c1469c8b120f7401c43dca.png)
Answer
Not a bug
Closed because 1) Can't reproduce and 2) No further upvotes after 4 months.
Customer support service by UserEcho