Re: Search not indexing Table content

Hi Bernard,

That is not the case – I did other searches that are longer than 3 letters and it only returns pages where they are mentioned in plain text but not when they are in tables.
Again this issue is happening on Lucene searches as well so don’t think its SLQ related.

Thanks though will go though your links for future reference.


Pawel

From: Bsfez Tiki <[email protected]>
Sent: 18 December 2018 19:07
To: Tiki users mailing list <[email protected]>
Subject: Re: [Tikiwiki-users] 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://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F1585611%2Fmysql-full-text-search-for-words-with-three-or-less-letters&data=02%7C01%7Cp.katarzynski%40kew.org%7Cc044c63cabb9400cf92f08d6651c1062%7C44892b45194046119753a4b3be4ea7fe%7C0%7C0%7C636807568556437880&sdata=MemRwXX4V2Fdb%2FbXk6Wg4mWcXo5PzVVZUnUey0Ybr5Q%3D&reserved=0>
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Ffulltext-fine-tuning.html&data=02%7C01%7Cp.katarzynski%40kew.org%7Cc044c63cabb9400cf92f08d6651c1062%7C44892b45194046119753a4b3be4ea7fe%7C0%7C0%7C636807568556437880&sdata=Rqq8rfMHbR0pEx3A15qGv5SPab%2Fzy12h%2BEx0W%2BErSqg%3D&reserved=0>
https://stackoverflow.com/questions/5192499/how-to-allow-fulltext-searching-with-hyphens-in-the-search-query<https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F5192499%2Fhow-to-allow-fulltext-searching-with-hyphens-in-the-search-query&data=02%7C01%7Cp.katarzynski%40kew.org%7Cc044c63cabb9400cf92f08d6651c1062%7C44892b45194046119753a4b3be4ea7fe%7C0%7C0%7C636807568556437880&sdata=fjcwMH5L%2Bj6cPjks%2Bmvxv85gLyKDQn3PgjlkiASfdf8%3D&reserved=0>

Good luck !
Bernard


On 18 Dec 2018, at 19:34 , Pawel Katarzynski <[email protected]<mailto:[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://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Ftikiwiki-users&data=02%7C01%7Cp.katarzynski%40kew.org%7Cc044c63cabb9400cf92f08d6651c1062%7C44892b45194046119753a4b3be4ea7fe%7C0%7C0%7C636807568556594084&sdata=Iqg9H8VYpkmBp6%2FKB38O%2Bj5X%2Blh9At0xzphBIn2AgdM%3D&reserved=0>

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