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&data=02%7C01%7Cp.katarzynski%40kew.org% > 7Cf0393a3f6721444265a908d665315e76%7C44892b45194046119753a4b3be4e > a7fe%7C0%7C0%7C636807660059308450&sdata=OIopTlHxTEsA60V2kxFAMxbRZ2n3W1 > lDQ9M3jKfzcFA%3D&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&data=02%7C01%7Cp. > katarzynski%40kew.org%7Cf0393a3f6721444265a908d665315e76% > 7C44892b45194046119753a4b3be4ea7fe%7C0%7C0%7C636807660059308450&sdata= > NNj7zwqHT9Tdszo8zcchvzuMH%2BiQ40jUyrc%2BUboa4xk%3D&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&data=02%7C01%7Cp. > katarzynski%40kew.org%7Cf0393a3f6721444265a908d665315e76% > 7C44892b45194046119753a4b3be4ea7fe%7C0%7C0%7C636807660059308450&sdata= > pYcQRTwMLvqtpDVSTMDCVx4am0wu92vHuIPGHS1VRxg%3D&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&data=02%7C01%7Cp. > katarzynski%40kew.org%7Cf0393a3f6721444265a908d665315e76% > 7C44892b45194046119753a4b3be4ea7fe%7C0%7C0%7C636807660059308450&sdata= > tFU7xMmgBSJYgw5ovu6cHpi8C5FlZ3Iku5ALLfL2qBM%3D&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