Category: Search

{syntax type="tiki" editor="plain"}
Step1: Create a simple text file and upload to a tiki installation
Step2: Admin Home -> Search -> General Settings (tab) -> Rebuild Index
Step3: Admin Home -> File Galleries -> Search Indexing (tab) -> Rebuild all files for search

However, the contents of the file uploaded in Step 1 are either not indexed or not searchable.

The search function cannot find words within the fancytables. This is quite important function so I would like to know a solution. Is it maybe possible to use the alternative query when the search returns empty set? and check if the query can be found with this alternative. And site is using mysql search currently. Does this work on other search engines?
By using SQL i can find it by changing the search query from
{CODE(caption="Not found" colors="sql")}select * from tiki_pages where data='myQuery';

or

Select * from tiki_pages where data='%myQuery%';{CODE}

{CODE(caption="Found " colors="sql")}Select * from tiki_pages where data like '%myQuery%';{CODE}

But if you leave out the wildcards it still returns nothing

{syntax type="tiki" editor="plain"}
I have Staging + Approval Setup for File Galleries. Browsing the Galleries works fine, Registered Users can see Approved files, Admins can see both Approved and Staging.

When I do a search, Registered Users cannot see any of the Approved files in File Gallery. If I turn on Global Permissions, File (tiki_p_download_files), then Registered Users can see both Approved and Staging. In the Approved category, Registered Users have the download files permission.

Something is funny in the permissions for Searching. This does not appear to follow the category permissions.

On dev.to, is I use the "Search" system from the right col top module "Seach wishes" or

For the string: "Wikiplugin, memberpayment; The period tooltip is not consistent with available options" I have no results.
If cut it and use only: "Wikiplugin, memberpayment" I have results.

I should be able to find the ticket in both cases.

{img fileId="1853" thumb="box"}

{img fileId="1854" thumb="box"}

Searching and trying to using different listing gives random and wrong results.
here I was searching for a recent tracker item I created with the term "Username" in it;

{img fileId="1695" thumb="box"}
{img fileId="1692" thumb="box"}
{img fileId="1693" thumb="box"}

I have checked the unified index freshness (it is ok Your index was last fully rebuilt on Friday 24 December, 2021 07:10:50 IST.) and it should have find me the item I was looking for.

Ultimately the tracker view showed me the item:
{img fileId="1694" thumb="box"}

It has been also confirmed by Volker on the 25/12/2021 on the user list.

After it has been updated to Tiki 24, we have "No results for query." at https://doc.tiki.org/Video-Tutorials

As explained here:
http://tikiwiki.org/tiki-view_forum_thread.php?topics_offset=239&topics_sort_mode=lastPost_desc&forumId=4&comments_parentId=21807


A related item:
When in a forum thread for example:
http://themes.tikiwiki.org/tiki-view_forum_thread.php?comments_parentId=106&topics_threshold=0&topics_offset=11&topics_sort_mode=commentDate_desc&topics_find=&forumId=2

When I click on the "top" link, I am always sent to comments_parentId=0 (which is never good)

I just installed TikiWiki 3.0 on a XP workstation and a Solaris server. When I performed a search, the searched word was not highlighted in the SearchResults page. I used Tiki 2.2 and 2.8 before and both did it. It could be bug in 3.0.

I have examined the generated page and couldn't find the <span class='highight_word_01'> around the searched word.

I appreciate it if someone can show me how to fix it.

Thanks.

To reproduce, se<span style="color:black;background-color:#ff9999;">a</span>rch <span style="color:black;background-color:#ff9999;">a</span>t dev.tw.o, for "Politic<span style="color:black;background-color:#ff9999;">a</span> <span style="color:black;background-color:#ff9999;">a</span>mbient<span style="color:black;background-color:#ff9999;">a</span>l de l<span style="color:black;background-color:#ff9999;">a</span> Ub", for inst<span style="color:black;background-color:#ff9999;">a</span>nce (without the double quoting).

[http://dev.tikiwiki.org/tiki-se<span style="color:black;background-color:#ff9999;">a</span>rchindex.php?highlight=Politic<span style="color:black;background-color:#ff9999;">a</span>+<span style="color:black;background-color:#ff9999;">a</span>mbient<span style="color:black;background-color:#ff9999;">a</span>l+de+l<span style="color:black;background-color:#ff9999;">a</span>+Ub&<span style="color:black;background-color:#ff9999;">a</span>mp;where=p<span style="color:black;background-color:#ff9999;">a</span>ges]

If I could uplo<span style="color:black;background-color:#ff9999;">a</span>d file to the tr<span style="color:black;background-color:#ff9999;">a</span>cker you could see <span style="color:black;background-color:#ff9999;">a</span> screenshot to view the <span style="color:black;background-color:#ff66ff;">output</span> I get, in c<span style="color:black;background-color:#ff9999;">a</span>se devs c<span style="color:black;background-color:#ff9999;">a</span>n not reproduce it yourselves.
For inst<span style="color:black;background-color:#ff9999;">a</span>nce, the first menu <span style="color:black;background-color:#ff9999;">a</span>t de.tw.o, s<span style="color:black;background-color:#ff9999;">a</span>ys then something like:
^l<span style="color:black;background-color:#ff9999;">a</span>ck;b<span style="color:black;background-color:#ff9999;">a</span>ckground-color:#<span style="color:black;background-color:#ff9999;">A</span>0FFFF;">l<span style="color:black;background-color:#ff9999;">a</span>ck;b<span style="color:black;background-color:#ff9999;">a</span>ckground-color:#<span style="color:black;background-color:#ff9999;">A</span>0FFFF;">l<span style="color:black;background-color:#ff9999;">a</span>ck;b<span style="color:black;background-color:#ff9999;">a</span>ckground-color:#<span style="color:black;background-color:#ff9999;">A</span>0FFFF;">Dev HomeP<span style="color:black;background-color:#ff9999;">a</span>ge
Tiki bugs <span style="color:black;background-color:#ff9999;">a</span>nd wishlist
Bug list on SF (re<span style="color:black;background-color:#ff9999;">a</span>d-only)
l<span style="color:black;background-color:#ff9999;">a</span>ck;b<span style="color:black;background-color:#ff9999;">a</span>ckground-color:#<span style="color:black;background-color:#ff9999;">A</span>0FFFF;">l<span style="color:black;background-color:#ff9999;">a</span>ck;b<span style="color:black;background-color:#ff9999;">a</span>ckground-color:#<span style="color:black;background-color:#ff9999;">A</span>0FFFF;">l<span style="color:black;background-color:#ff9999;">a</span>ck;b<span style="color:black;background-color:#ff9999;">a</span>ckground-color:#<span style="color:black;background-color:#ff9999;">A</span>0FFFF;">Developers Multi webc<span style="color:black;background-color:#ff9999;">a</span>m
^
It h<span style="color:black;background-color:#ff9999;">a</span>ppens on 1.8.<span style="color:black;background-color:#99ff99;">5</span> sites, <span style="color:black;background-color:#ff9999;">a</span>nd 1.9.0 sites. Reproduced the bug with mose.css, the def<span style="color:black;background-color:#ff9999;">a</span>ult style <span style="color:black;background-color:#ff9999;">a</span>t dev.tw.o, <span style="color:black;background-color:#ff9999;">a</span>nd <span style="color:black;background-color:#ff9999;">a</span> modified style from d<span style="color:black;background-color:#ff9999;">a</span>mi<span style="color:black;background-color:#ff9999;">a</span>n.css .

Actually on Tiki forums, https://tiki.org/forums, there is a "simple" search field on the main page.
Initiating a search open https://tiki.org/tiki-searchindex.php (out of forums area) I can see 1289 pages of results and it look like forum posts (I didn't;t check all pages ;-) ). The first page of results displayed posts from the mailing list archive (forum26).
You can then use facets to try to narrow search results.
But the filters were though for a general use (Object Type, Language, Federated Search, Category Tree, Categories, Letter, First word) and are bad for searching posts in forum... I don't see a case I would use any of them.?

With 1289 pages of results that just awful.

---

If you go in a forum like : https://tiki.org/forum26
You have also a "simple" search field. Again you are redirected to https://tiki.org/tiki-searchindex.php but then it displays any objects found (not only posts). This is bad too. If I'm in a section or an area like a forum and initiate a search I should see results from this area.
Again filters are not relevant.

---

If I go in a thread then I don't have any search tools but seems ok to me.
https://tiki.org/forumthread77942-Composer-allowed-plugin-list

http://dev.tiki.org/tiki-searchindex.php?filter~content=html5-boilerplate&sort_mode=score_ndesc&filter~type=&filter~language=

{flash type="url" movie="display622" width="1146" height="682"}

Current behavior:
When searching for a term and selecting a language (for example German (DE)) the search results will highlight the searched languages letters (in our example "DE") as well.

{img fileId="1128" thumb="box"}

Expected behavior:
The search results only highlight the searched term and not the chosen language as well.

Step to reproduce:
Search any term in using the search module and the language filters.

{img fileId="1129" thumb="box"}

Possible workaround:
Disable the whole highlighting using CSS.

When on www.tikiwiki.org, I execute a search for anything with "Site" in it. "Site5", or "Site 5" or "Site blahblah". Search returns, with Internet Explorer, __Internet Explorer cannot display the webpage__. I looked at the source and encoding is UTF-8, so at a loss. I tried several other keywords other than "Site" and they all returned proper searches.

This is a weird one.

Just do a simple search and you'll get:

Notice: Only variable references should be returned by reference in /home/amette/public_html/tikiwiki-BRANCH-1-9/lib/search/searchlib.php on line 776

Notice: Only variable references should be returned by reference in /home/amette/public_html/tikiwiki-BRANCH-1-9/lib/search/searchlib.php on line 489
:
:
:
and so on...

I think we'll face this problem a lot more... :-/

Can be seen here:
* https://dev.tiki.org/Unprioritized+Open+Wishes
* https://dev.tiki.org/Move+from+30+minute+fixes+to+ease+filter

Now we have Scheduler and plugin ListExecute we can fairly simply make an automated notification system for this tracker, to:
* email the originator if it's pending and needing retesting
* open, not fixed and a volunteer is listed
* still open after a very long time (gone stale?)
...that sort of thing.

Anyone fancy trying to set it up? (:mrgreen:)

In a Tiki22 I have 2 trackers (orders, payments) with relation fields.

They may be one order with several payments (recurrent, monthly payment).
I have actually 4 payments per orders and that’s work ok but on a specific case I have more payment and Tiki throw errors.

{CODE()}
×
 Error
Indexing failed while processing "1268" (type trackeritem) with the error "Could not perform index modification: Data too long for column 'tracker_field_productsboughtPaymentId_text' at row 1"
×
 Error
Malformed search query: Could not perform index modification: Data too long for column 'tracker_field_productsboughtPaymentId_text' at row 1
×
 Error
The search index could not be updated. The site is misconfigured. Contact an administrator.
Could not perform index modification: Data too long for column 'tracker_field_productsboughtPaymentId_text' at row 1
{CODE}

{img fileId="1485" thumb="box"}

By nature relation shouldn’t be limited and able to handle many items.

~~#F00:__UPDATE__~~
It is plaguing and changing behaviour of other components.
In the screenshot below you can see many counter (plugin list count template) displaying a 0 instead of the real value even if the list plugin is set with a different tracker. There is a big chance the index become corrupted or not completed so I escalated.

The fields should be protected in a first place (avoiding using longer data than possible to use) and finally this field specific should be set to a relative high amount of data.

{img fileId="1486" thumb="box"}

A Show Instance for a simple shopping cart.

{flash type="url" movie="display606" width="1042" height="316"}

{syntax type="tiki" editor="plain"}
Hello,

Some of my last items created don't appears into the "list yours" request on dev.tikiwiki.

!!Details
In seems that it is for all items since a particular date. I have information about this.

Some day ago we had on chat an exchange about the generation of a query with an error (item 3104), when submitting "search" (the error had been checked during the chat - use od in() statement in the SQL request not accepted by MYSQL). The next morning it was put out.

But while we were checking the "list yours" had disappeared. The next morning it was there.

!!Others linked subjects
Items : 3114, 3116

!!Beginning to find the problem (while redacting)
I just made controls, I discover that this items __that I have submitted have no author name, I was nevertheless logged in__.
__This explains the fact that the item don't appears in the list but not why the author had not been defined.__



Trebly

If I search for i.e. "groups" I will receive results I cannot open. No link is behind the entry. This happens on doc.tiki.org. See: [https://doc.tiki.org/tiki-searchindex.php?filter%7Econtent=groups&storeAs=]

{syntax type="tiki" editor="plain"}
On a Tiki27 I have a plugin list with this sort control block to display trackeritems;

-+{sort mode="tracker_field_apiSortingCriteria_asc"}+-
Not all my items have a value for this field.

A few week or month ago it wasn't a problem and nothing were shown in the search-index logs.

After updating this project with the last Git branch 27.x i have a warning for each item without a value in the field.

{CODE()}
2025-07-26T07:40:12+00:00 INFO (6): addDocument wiki page PageName {"memoryUsage":"53.0 MiB","memoryAvail":"73.5 MiB"} 2025-07-26T07:40:20+00:00 ERR (3): NOTICE: Undefined array key "incat" {"code":1024,"file":"/Users/blabla/Documents/blabla/www/htdocs/domain_tiki27/temp/templates_c/en_basic^c992f36a1145d5fb2232 2025-07-26T07:40:20+00:00 ERR
{CODE}

The code should be handling case when a field has no value.

{syntax type="tiki" editor="plain"}
entering the words "visual studio" in the search_box module causes the following message to be returned in the UI:


An error occured in a database query!

Context:
File tiki-searchresults.php
Url tiki-searchresults.php?highlight=visual+studio&where=pages
Query:
select `data` from `tiki_dynamic_variables` where `name`=?
Values:
0 comspec
Message:
Table 'tikidb.tiki_dynamic_variables' doesn't exist
Built query was probably:
select `data` from `tiki_dynamic_variables` where `name`='comspec'

Please see:
http://sourceforge.net/mailarchive/forum.php?thread_id=10026369&forum_id=12569

In tiki-browse_gallery.php, there is Sort Images by [ Name | Date | Hits | User | Size ] so robots can think these are all different pages

We have no syntax for expressing we want an unlimited number of LIST plugin results.

Using mysql Full-Text indexation, one can express the idea with a huge number like so :
{CODE()}{LIST()}
{filter field="object_type" content="trackeritem" }
{filter field="tracker_id" exact="1"}
{pagination max="99999999"}
{OUTPUT(template=)}
{LIST}{CODE}

It is ugly but it does the job in an expressive way (people will understand 99999999 does not mean exactly 99999999).

Using Elascticsearch, the above will fail with an obscure error message « all shards failed » because Elascticsearch has a hard limit which defaults to 10000 but it can be changed at the server level.
See ''Results Per Query'' in [https://www.elastic.co/guide/en/app-search/current/limits.html]
So I need to use:
{CODE()}{LIST()}
{filter field="object_type" content="trackeritem" }
{filter field="tracker_id" exact="1"}
{pagination max="9999"}
{OUTPUT(template=)}
{LIST}{CODE}
Because "10000" looks like I really want "10000" rather than unlimited.

__It is bad that the LIST plugins need to be rewritten when one changes the unified search indexation method.__ Also, it is not obvious why it fails.

__SUGGESTION__ I feel we should allow for a real syntax for unlimited results such as :
{CODE(caption="SUGGESTED SYNTAX" theme="default")}{pagination max="-1"}{CODE}

Then if Tiki uses Elascticsearch searches it could look up the ''Results Per Query'' value (or assume 10000 for starters) when "-1" is encountered.
If Tiki uses "Mysql Full-Text search" if should not have a limit (or it should have a very high one).