Page 1 of 1

move to bottom / alt+end / sqlite error 19

Posted: Thu May 13, 2010 3:19 pm
by danhouser82
Running: Windows XP, with SP3, 32bit.

After upgrading from 10.5M to 1.0B, I can no longer use the hotkey OR the command for "move to bottom".

i get the following error...

"class sqlite::DatabaseException
SQLite Error 19:
column num is not unique"

Let me know if more information is needed.
BTW, CintaNotes rocks!

Re: move to bottom / alt+end / sqlite error 19

Posted: Thu May 13, 2010 4:58 pm
by CintaNotes Developer
Hello and thanks for the report!

Please try this version:
download/file.php?id=72

Re: move to bottom / alt+end / sqlite error 19

Posted: Fri May 14, 2010 5:03 pm
by danhouser82
Didn't work, still the same problem and code.

Re: move to bottom / alt+end / sqlite error 19

Posted: Sat May 15, 2010 3:54 am
by CintaNotes Developer
The new exe should work, I think you might have the corrupted database.
Please export your notes to XML and re-import them from scratch to fix this.

If this doesn't help, please tell me more about the circumstances of the error:
1) are any tags selected on the tag sidebar?
2) which note do you try to move to bottom - the top one or from the middle?

thanks!

Re: move to bottom / alt+end / sqlite error 19

Posted: Tue May 18, 2010 12:15 pm
by danhouser82
The export / import XML did the trick!

Corrupted database is what I was thinking too, but it did it on all 3 of my PCs. I upgraded each the same way. From 10.5 to 1.0B then the preview file you've posted.

1) tags were selected yes, but switching between any caused the same error.
2) it's any note that wasn't already the bottom note.

Also I'm using the zip (portable?) versions if that makes a difference.

Anyway thanks! Keep up the great work!