Re: Search not indexing Table content

Mmm…

I wonder if this is not related to a default setting in mysql to search for a 3 letter words minimum.
May be there is a setting somewhere that is omitting the hyphens in the search changing a search for "KEW-PTP-001" into a search for "KEW" "PTP" "001"

Something default setting won't return…

https://stackoverflow.com/questions/1585611/mysql-full-text-search-for-words-with-three-or-less-letters
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
https://stackoverflow.com/questions/5192499/how-to-allow-fulltext-searching-with-hyphens-in-the-search-query

Good luck !
Bernard

> On 18 Dec 2018, at 19:34 , Pawel Katarzynski <[email protected]> wrote:
> 
> Hi List, 
>  
> I am using tiki 18.2 and Search engine set to: MySQL Full-text search (although I did tried with Lucene engine as well to same effect).
> Whenever I try to search for keyword that is inside table rather than just a plain text I get no result.
>  
> Example:
> <image001.png>
>  
> If I search for “KEW-PTP-001” I get no results. I’ve rebuild index few times since so its not indexing it at all.
> <image002.png>
>  
> While checking logs form rebuild index – no matter if I use MySQL or Lucene it always show an error in the end (although though Tiki interface it always shows “done”)
>  
> # php console.php index:rebuild --log
> [2018-12-18 17:06] Started rebuilding index... logging to file: /tmp/Search_Indexer_mysql_tiki_wiki_console.log
> Unified search engine: MySQL, version 5.5.60-MariaDB
> Indexed
>   wiki page: 48
>   file: 2
>   file gallery: 3
>   comment: 0
>   user: 10
>   group: 14
>   calendaritem: 0
>   calendar: 0
>   category: 0
>   total fields in the search index: 49
> Rebuilding index done
> Execution time: 3 secs
> Current Memory usage: 34.8 MiB
> Memory peak usage before indexing: 14.6 MiB
> Memory peak usage after indexing: 34.9 MiB
> Number of queries: 1164
> [root@kptnetops01 tiki]# cat /tmp/Search_Indexer_lucene_console.log
> 2018-12-18T17:05:05+00:00 INFO (6): Starting rebuild {"memoryUsage":"17.5 MiB"}
> …..
> 2018-12-18T17:05:07+00:00 INFO (6): Starting optimization {"memoryUsage":"20.7 MiB"}
> 2018-12-18T17:05:07+00:00 INFO (6): Finished optimization {"memoryUsage":"20.5 MiB"}
> 2018-12-18T17:05:07+00:00 INFO (6): Finished rebuild {"memoryUsage":"20.5 MiB"}
> 2018-12-18T17:05:07+00:00 ERR (3): NOTICE: Undefined property: Search_Lucene_Index::$lucene {"code":8,"file":"/var/www/html/tiki/lib/core/Search/Lucene/Index.php","line":36}
>  
> Any tips how to solve this issue will be appreciated. Most of my Wiki pages are table content and hence make search unusable ☹
>  
>  
> Thanks
> Pawel
> 
> 
> The Royal Botanic Gardens, Kew is a non-departmental public body with exempt charitable status, whose principal place of business is at Royal Botanic Gardens, Kew, Richmond, Surrey TW9 3AE, United Kingdom.
> 
> The information contained in this email and any attachments is intended solely for the addressee(s) and may contain confidential or legally privileged information. If you have received this message in error, please return it immediately and permanently delete it. Do not use, copy or disclose the information contained in this email or in any attachment.
> 
> Any views expressed in this email do not necessarily reflect the opinions of RBG Kew.
> 
> Any files attached to this email have been inspected with virus detection software by RBG Kew before transmission, however you should carry out your own virus checks before opening any attachments. RBG Kew accepts no liability for any loss or damage which may be caused by software viruses.
> _______________________________________________
> TikiWiki-users mailing list
> [email protected] <mailto:[email protected]>
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users <https://lists.sourceforge.net/lists/listinfo/tikiwiki-users>

_______________________________________________
TikiWiki-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-users