Page 1 of 1

Ctrl+Alt+Click on a tag

Posted: Wed Jul 27, 2016 9:59 pm
by yogi
Hi,
CN gave me the following errors when I tried: Ctrl+Alt+Click on a tag

Error Class db:DatabaseException
SQLite error1:
Expression tree is too large(maximum depth 1000)

and repeatedly

Error Class db:: Database Exception
SQLite error 5:
database is locked

I had to use the taskmanager to kill cintanotes.

This is CN 3.2 under w8.1.
There are 2503 notes.
I clicked on ort/tarmstedt.
Ort has 437 entries.
tarmstedt has 118 entries.

Kind regards
Yogi

Re: Ctrl+Alt+Click on a tag

Posted: Thu Jul 28, 2016 2:01 am
by CintaNotes Developer
How many different tags do you have overall?

Re: Ctrl+Alt+Click on a tag

Posted: Thu Jul 28, 2016 8:58 pm
by yogi
Alex,
can I read this somewhere in the programm?
I have 2504 notes. They are all tagged with at least one tag. Many have severall tags, and there are two and three-level tags.
Hope this helps
Yogi

Re: Ctrl+Alt+Click on a tag

Posted: Fri Jul 29, 2016 11:00 am
by usbpoweredfridge
Hi Yogi,

If you have the following option enabled, the tag count will show at the top of the Tag Sidebar:
Options > Tags > Display Tag Usage Counts on Tag Sidebar

Regards,

Chris

Re: Ctrl+Alt+Click on a tag

Posted: Fri Aug 05, 2016 5:07 pm
by CintaNotes Developer
There's no way to display this info in the UI I'm afraid. But you can export the notebook to XML and count the number of "tag" entries inside of "tags" element.

Re: Ctrl+Alt+Click on a tag

Posted: Thu Aug 11, 2016 4:54 am
by yogi
Hallo,
the tag usage count is 2522.
The count of tags in the exported file resulted in: 1032.
Total number of notes in 5 sections is 30003.
Hope this helps.
The error still happens.

Otherwise it works very well, the new rules-command is very nice indeed.
Kind regards
Rolf

Re: Ctrl+Alt+Click on a tag

Posted: Thu Aug 11, 2016 6:04 am
by CintaNotes Developer
Ok thanks for the info. The reason is very large number of tags. Since when you click Ctrl+Alt+Tag, each tag except the clicked one is added to the query (with NOT specifier), the resulting query becomes too large and overwhelms SQLite's parser.
Added to our todo list. Thanks for reporting!