Re: Search not indexing Table content

Marc Laporte <[email protected]>
Newsgroups gmane.comp.cms.tiki.user
Message-ID <CABd-ERHsLwJFpWfXYHU25fH5T+xF1-1+t2_5Dc5cfGah9V2zyQ@mail.gmail.com>
hmmmmm

Weird. There is another preference to exclude certain categories from the
index, but I doubt you have activated it. And it would hide the whole page,
not just the table.


One more idea:

Lucene is deprecated. Try MySQL FTS.

You can then use PhpMyAdmin or https://www.adminer.org to check the
generated data.

Try to find the page, and what is stored in the index.

Marc





On Wednesday, December 19, 2018, Pawel Katarzynski <[email protected]>
wrote:

> Hi Marc,
>
> It did not made any change. I did "untick" by the "Exclude all plugins" in
> options. Did index rebuild using: # sudo -u apache php console.php
> index:rebuild --force --log. With Lucene as search engine, still no results
> found for any keyword that is in table.
>
> Pawel
>
> -----Original Message-----
> From: Cloutier, Philippe (DGARI-Consultant) <
> Philippe.Cloutier.externe-3LJ5X92lM5eafr9EPe0ZzS/[email protected]>
> Sent: 18 December 2018 21:40
> To: Tiki users mailing list <[email protected]>
> Subject: Re: [Tikiwiki-users] Search not indexing Table content
>
> >De : Marc Laporte [mailto:[email protected]] Envoyé : 18 décembre
> >2018 14:56
> >
> >This is because all plugin content is excluded by default.
> >
> >Instead, unified_exclude_all_plugins should be off
> >
> >
> >It was added in r47124 and made it the default in r48096
> >
> >Here is: https://emea01.safelinks.protection.outlook.com/?url=
> https%3A%2F%2Fsourceforge.net%2Fp%2Ftikiwiki%2Fcode%
> 2F47124It&amp;data=02%7C01%7Cp.katarzynski%40kew.org%
> 7Cf0393a3f6721444265a908d665315e76%7C44892b45194046119753a4b3be4e
> a7fe%7C0%7C0%7C636807660059308450&amp;sdata=OIopTlHxTEsA60V2kxFAMxbRZ2n3W1
> lDQ9M3jKfzcFA%3D&amp;reserved=0 was a good idea to add such a feature. A
> bad idea to activate by default in https://emea01.safelinks.
> protection.outlook.com/?url=http%3A%2F%2Fsourceforge.net%
> 2Fp%2Ftikiwiki%2Fcode%2F48096.So&amp;data=02%7C01%7Cp.
> katarzynski%40kew.org%7Cf0393a3f6721444265a908d665315e76%
> 7C44892b45194046119753a4b3be4ea7fe%7C0%7C0%7C636807660059308450&amp;sdata=
> NNj7zwqHT9Tdszo8zcchvzuMH%2BiQ40jUyrc%2BUboa4xk%3D&amp;reserved=0 kicking
> the can down the road instead of addressing the issues. Would have been
> better to exclude plugins with known issues from the index. The result of
> this is that all future work on existing and new plugins was mostly done
> without taking into account the index.
>
>
> I added that proposal to https://emea01.safelinks.
> protection.outlook.com/?url=https%3A%2F%2Fdev.tiki.org%
> 2FDefault-Preferences-to-be-changed&amp;data=02%7C01%7Cp.
> katarzynski%40kew.org%7Cf0393a3f6721444265a908d665315e76%
> 7C44892b45194046119753a4b3be4ea7fe%7C0%7C0%7C636807660059308450&amp;sdata=
> pYcQRTwMLvqtpDVSTMDCVx4am0wu92vHuIPGHS1VRxg%3D&amp;reserved=0 in version
> 19.
>
> P.S. Your mail has strange formatting Marc (never noticed that before).
>
> >Marc
> >
> >
> >
> >On Tuesday, December 18, 2018, 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:
> >>
> >> [image: cid:[email protected]]
> >>
> >>
> >>
> >> 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.
> >>
> >> [image: cid:image002.png-TqSFo4MYwXJ1Dx3lc/[email protected]]
> >>
> >>
> >>
> >> 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/htm
> >> l/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*
>
> _______________________________________________
> TikiWiki-users mailing list
> [email protected]
> https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.
> sourceforge.net%2Flists%2Flistinfo%2Ftikiwiki-users&amp;data=02%7C01%7Cp.
> katarzynski%40kew.org%7Cf0393a3f6721444265a908d665315e76%
> 7C44892b45194046119753a4b3be4ea7fe%7C0%7C0%7C636807660059308450&amp;sdata=
> tFU7xMmgBSJYgw5ovu6cHpi8C5FlZ3Iku5ALLfL2qBM%3D&amp;reserved=0
>
> _______________________________________________
> TikiWiki-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users
>


-- 
Marc Laporte

http://WikiSuite.org
http://PluginProblems.com
http://Avan.Tech

_______________________________________________
TikiWiki-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.