![]() |
Not able to perform a search
This is probably a case of user error, so please be patient. For some reason, I am unable to perform a quick search or an advanced search in my database. It is quite large at 790MB, and I tried compacting and repairing. Full text search is not activated, and I have never had trouble like this before. It seems not to matter where in the database I try to search from. I can use my pre-defined searches from the search pane, but quick and advanced simply do not work. Nothing happens - the detail pane does not change. This worked yesterday.
Any suggestions? By the way, I am using 4.1.3.4. Jon |
Is it not searching, or searching but not finding any results (does the caption beside the Advanced/Quick button in the search detail pane update with 0 matching items...done)?
You mentioned that your pre-defined searches work. The Quick Search and Advanced Find items are just other pre-defined searches, so you might be able to just use or copy one of the working search items and instead. |
Thank you for your reply. I cannot use the standard shortcut (CTRL+SHIFT+F), the menu or the toolbar. Nothing happens. I do not get the search form in the detail pane.
Jon |
Are you able to manually navigate in the Search pane (Ctrl+0) to My Searches -> Quick Search and search from there?
We would need to see your database to diagnose the problem. See the notes in #5a to minimize the database size for sending: http://www.kinook.com/Forum/showthre...?threadid=3038 Thanks. |
Quote:
Jon |
I re-created Quick Search within the Search Pane. It functions normally. However, I cannot use the shortcut, toolbar icon, nor the menu - nothing works and I would like to limit my search to particular areas of the tree.
Jon |
Quote:
|
Did you check the 'Reset all system information to defaults' option when repairing? That should bring back the real Quick Search item even if it was deleted somehow.
|
Quote:
Jon EDIT: Is it possible that one or more items could have this effect? |
Actually, a regular repair (with the Reset option unchecked) should also restore a deleted Quick Search item. Apparently something in the original database is preventing that from working. You can try running these statements with SQLite.exe (see http://www.kinook.com/Forum/showthre...?threadid=2825):
INSERT INTO Item(ItemID,ItemTitle,TemplateItemID,StatusID,Icon ID,System,CreateDate,UpdateDate,AccessDate,Keyword Count,TitleAttributeID,ChildCount,LinkCount,Access Count,BlobSize,UncompressedSize) VALUES (990,'Quick Search',8,NULL,980,1,38197,38197,NULL,2,5,NULL,NUL L,NULL,NULL,NULL); INSERT INTO ItemLink(ItemLinkID,ItemID,ParentItemID,Expanded,C hildPosition,DeleteDate,DeletedParentItemID) VALUES (984,990,996,0,0,NULL,NULL); If that doesn't help, you'll probably need to restore a backup from before the problem occurred. |
OK, I can try this. I'll need to do this tonight. Will get back to you tomorrow.
Jon |
Out of desperation (I really needed some references), I did a compact and repair with the "Reset all system information to defaults" box ticked. It worked, and I now have the search function back to normal. Of course I first backed up my file, but what I would like to know is what customizations were changed? Would the SQLite method be preferrable?
Jon |
A full repair restores all the original data from the template database (items, titles, text, attributes, forms, etc.).
|
I have had the same issue since I have upgraded to 4.2 The other day I needed to run the repair 3 times ( different times throughout the day ) to get the search to work again. I have also frozen up a few times. My db is only 105gb so it might be considered small to have these issues.
|
I guess you mean 105MB? Can you ZIP and send the database, or a pared down version where the problem still occurs, and indicate actions that cause the quick search item to disappear? Thanks.
|
Thanks for the offer to look at the database but it contains sensitive information spread throughout the database.
That being stated, is there a future request to add the ability to password protect individual items and or to password protect individual words, if I had that ability I could have easily sent you the database? I use the quick search a lot throughout the day ( more like rely on it ) and when it works, it is great but then all of a sudden, nothing. I exit out of UR and launch it again hoping that might be the problem, but it does not correct the searching. I have even rebooted and that did not help. It only works when I have compacted with resetting all system information to the defaults. I will try to look for a pattern on when it stops working and let you know what I find. FYI - I am using the portable version, not sure if that matters. |
I don't think that this problem is related to your upgrade to 4.2. I have not done that yet and the symptoms you describe seem to be the same as mine.
Jon |
All times are GMT -5. The time now is 07:41 PM. |
Copyright © 1999-2023 Kinook Software, Inc.