Ctrl+Alt+Click on a tag

yogi
Posts: 49
Joined: Wed Apr 02, 2014 2:04 pm
Contact:

Ctrl+Alt+Click on a tag

Postby yogi » Wed Jul 27, 2016 9:59 pm

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
User avatar
CintaNotes Developer
Site Admin
Posts: 4697
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Ctrl+Alt+Click on a tag

Postby CintaNotes Developer » Thu Jul 28, 2016 2:01 am

How many different tags do you have overall?
Alex
yogi
Posts: 49
Joined: Wed Apr 02, 2014 2:04 pm
Contact:

Re: Ctrl+Alt+Click on a tag

Postby yogi » Thu Jul 28, 2016 8:58 pm

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
User avatar
usbpoweredfridge
Posts: 407
Joined: Fri Jan 17, 2014 11:08 pm
Contact:

Re: Ctrl+Alt+Click on a tag

Postby usbpoweredfridge » Fri Jul 29, 2016 11:00 am

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
User avatar
CintaNotes Developer
Site Admin
Posts: 4697
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Ctrl+Alt+Click on a tag

Postby CintaNotes Developer » Fri Aug 05, 2016 5:07 pm

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.
Alex
yogi
Posts: 49
Joined: Wed Apr 02, 2014 2:04 pm
Contact:

Re: Ctrl+Alt+Click on a tag

Postby yogi » Thu Aug 11, 2016 4:54 am

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
User avatar
CintaNotes Developer
Site Admin
Posts: 4697
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Ctrl+Alt+Click on a tag

Postby CintaNotes Developer » Thu Aug 11, 2016 6:04 am

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!
Alex

Return to “Bug Reports”