Category: Search

Installer fails at the end with the following error:

"Fatal error: Cannot use object of type stdClass as array in
/tiki/lib/core/Search/Indexer.php on line 64"

I have a wiki site called "Peter Pan"
I include a page alias ~tc~(alias(Miki Mouse))~/tc~
Now I search for "Miki"
Result: Found "Miki" in 0 pages.

That's not what I found in the docs. There it says that the search is supported since tiki4

How can I solve that problem?
---
Edit {sign user="xavi" datetime="2015-02-02T10:53:28+00:00"}:
After confirming same issue in a trunk show instance also, I renamed bug to __'Unified Search Engine MFTS fails for any content'__ (from __'Page alias not found by search'__), and increased the importance to "9". Thanks agian hans for submitting this bug report in the first instance.
---

"Perhaps you are looking for:" list of similar pages should be listed alphabetically. For example you can see it here it is not sorted at all:
https://tiki.org/Roundtable-Meeting-2020-01

I've run a script on all profiles from all branches ( https://github.com/xavidp/TikiProfilesTester ) and I see that all profiles since 15.x throw this error message (which might be related to the fact that unified search index may be currently enabled by default)?
{CODE()}
PHP Fatal error: Uncaught Search_MySql_LimitReachedException: Could not perform index modification: Incorrect datetime value: '0000-00-00 00:00:00' for column 'creation_date' at row 1 in /var/www/html/15.x/lib/core/Search/MySql/QueryBuffer.php:55
Stack trace:
#0 /var/www/html/15.x/lib/core/Search/MySql/QueryBuffer.php(37): Search_MySql_QueryBuffer->realFlush()
#1 /var/www/html/15.x/lib/core/Search/MySql/Table.php(195): Search_MySql_QueryBuffer->flush()
#2 /var/www/html/15.x/lib/core/Search/MySql/Table.php(28): Search_MySql_Table->flush()
#3 [internal function]: Search_MySql_Table->__destruct()
#4 {main}
thrown in /var/www/html/15.x/lib/core/Search/MySql/QueryBuffer.php on line 55
{CODE}

Using php 5.6, and mysql (server) 5.7.12 (mysql client: libmysql - mysqlnd 5.0.11-dev - 20120503).

Profiles are applied through the command line with "php console.php p:a ProfileName"

Plugin List fails to find a match for the category Profiles Wizard (292) in dev.t.o

This item
https://dev.tiki.org/item6374 - "Can't apply a Profile from the Profiles Wizard! (only through profiles control panel): ticket missing?"

is categorized against category 292: "Wizards - Profiles Wizard"

This wiki page has a plugin list call to show items in this category (with equivalent syntax that it's working with no problems - apparently - in other pages in dev.t.o):
https://dev.tiki.org/Profiles-Wizard

and it fails to list that tracker item (and any others tagged against that category, if any).

plugin list filter by category doesn't seem to work on dev.t.o. Example: I dereived some list code from ((Tiki20)) page towards ((jQuery Gantt editor)) page, adapting the filter condition to match categ id 345:
{CODE()}
{filter content="5" field="tracker_id"}
{filter field="tracker_status" content="o OR p"}
{filter field="tracker_field_category" content="345"}
{CODE}

There is at least one item linked to that category
https://dev.tiki.org/item7122-Editing-a-Gantt-Chart-shows-missleading-messages-success-and-error

But plugin list returns zero results.

Am I doing something wrong? (I used to be able to write plugin list calls with filters and such). Some regression?

Plugin List or TrackerList unable to show tracker items with category 50 (PDF) in dev.t.o
AFAIR, this used to work in previous Tiki versions (at least Tiki12 and presumably Tiki15)
See the edits I did on this page ((PDF)) :
https://dev.tiki.org/tiki-pagehistory.php?page=PDF&newver=0&oldver=17

However, in both cases, there were no results shown. There were items in the past assigned to category 50 (PDF), as shown here:
https://dev.tiki.org/cat50

See also this one added today:
https://dev.tiki.org/item6407

I have pages that are related to another and are name as follow;

HomePage
text_HomePage_sectionA
text_HomePage_sectionB
text_HomePage_sectionC
text_HomePage_sectionD_en
text_HomePage_sectionD_fr
text_HomePage_sectionD_he

Etc.

Using Tiki25 and ElasticSearch, when I use a filter with the "exact" parameter like this:
{filter field="title" exact="HomePage"}

Only the page "HomePage" will be returned.

Using Tiki26 and Manticore, using the pages and filter __all the pages__ are returned and not only "HomePage".

The ultimate feature of Amazon and all the e-commerce shopcart systems is the one known as "Customers who bought this item also bought .." or "were also interessted in ..".
The feature would show objects or items that were viewed or bought by previous users in conjunction with the actual item or object.

Idea:
Applied for tiki a new plugin "Relation By Views" would allow to list related wiki pages (or even other objects) in a page likewise to existing backlinks and alias plugins as well as semantic links.
Though, the information is based on previous view counts / his of wiki pages (or other objects) that have been hit by users wihtin the same session as the actual wiki page / object.

The enhancement is obvious: we would make a step further to get implicit relations between pages / objects based on user behaviour.
Just as the advantage in ecommerce is crossselling, we would provide cross-links and encourage readers to have a look to further pages / objects.
In regard to enhancements of the basic shopping cart feature in Tiki 5, this plugin could even be used as a real "customers were also interessted in" feature.

Elasticsearch was set up recently on the *tiki.org sites (thanks to Roberto and Jonny). On the positive side, the results seem to be very good, but I noticed some glitches when doing a search at themes.tiki.org. I entered the word "Bootstrap" in the search input on the homepage and "1.0" appeared in the dropdown. I clicked that and it moved up to the input as if I wanted to search for "1.0", so I had to delete it and re-input my search term. I wonder why that "1.0" appeared. Not a big deal but kind of strange. Later, when I entered "Bootstrap" again on the homepage after doing my first search, there was the expected list of "Bootstrap" results in the dropdown, so the "1.0" item had gone away.

On the results page, with no filters applied, I see that the headings of many results end with the word "External" which makes sense when the links are to tiki.org or dev.t.o., etc. But quite a few of the results that say "External" are actually at themes.tiki.org. The only pattern I can find is that wiki pages don't seem to be affected by this, but trackers, forums, file descriptions, etc. are.

One other thing is that some of the search results link to a page of search results, like -+https://themes.tiki.org/tiki-searchindex.php?filter%7Econtent=Bootstrap&exact_match=y#threadId=3168+-. This seems like a bug.

Finally, I assumed the "Federated search" filter would filter results by site. But I tried each of the options - dev, tw, and doc - and didn't see any change in the list of results, which still came from all of the *tiki.org sites. (By the way, I thought I noticed a "local search" option the first time I used the filter, but it didn't appear as an option after that.)

I then tried filtering by object type - I chose "file gallery" - and again there's no effect. Every result was listed no matter what object type. I tried filtering after submitting a search term and getting results, and also filtering with the initial search request - no difference: no filtering.

{flash type="url" movie="display647" width="1208" height="434"}

As discussed in the devlist:
I can confirm now a nasty regression introduced in Tiki22.x at some point. (between 2 month ago and now)

It broke filters (item link and item list)

It may be related of tracker field "real" life as I saw the BLOB/TEXT error on a field that was added at some point and not all the items have been saved with it (math field).
(console.php recalc doesn’t seems to be in Tiki22)

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

List of the files reverted to have my Tiki back to work (updated, created, deleted):
{CODE()}
reverted:
.editorconfig
_htaccess
changelog.txt
copyright.txt
db/tiki-db.php
db/tiki.sql
doc/devtools/release.php
doc/devtools/satis.json
installer/composer-patches/jcbrand-conversejs_remove-native-javascript-for-bootstrap.patch
installer/schema/20101230_create_top_modules_tiki.php
installer/schema/20110115_create_bottom_modules_tiki.php
installer/schema/20110201_c_code_to_user_modules_tiki.php
lang/ar/language.php
lang/bg/language.php
lang/ca/language.php
lang/cn/language.php
lang/cs/language.js
lang/cs/language.php
lang/cy/language.php
lang/da/language.php
lang/de/language.php
lang/el/language.php
lang/en-uk/language.php
lang/en/language.php
lang/es/language.php
lang/fa/language.php
lang/fi/language.php
lang/fj/language.php
lang/fr/language.php
lang/fy-NL/language.php
lang/gl/language.php
lang/he/language.php
lang/hr/language.php
lang/hu/language.php
lang/id/language.php
lang/is/language.php
lang/it/language.php
lang/iu-iq/language.php
lang/iu-ro/language.php
lang/iu/language.php
lang/ja/language.php
lang/ko/language.php
lang/lt/language.php
lang/nds/language.php
lang/nl/language.php
lang/no/language.php
lang/pl/language.php
lang/pt-br/language.php
lang/pt/language.php
lang/rm/language.php
lang/ro/language.php
lang/ru/language.php
lang/sb/language.php
lang/si/language.php
lang/sk/language.php
lang/sl/language.php
lang/sq/language.php
lang/sr-latn/language.php
lang/sv/language.php
lang/sw/language.php
lang/th/language.php
lang/tr/language.php
lang/tv/language.php
lang/tw/language.php
lang/uk/language.php
lang/ur/language.php
lang/vi/language.php
lib/blogs/bloglib.php
lib/categories/categlib.php
lib/comments/commentslib.php
lib/core/H5P/editor.js
lib/core/Math/Formula/Function/ForEach.php
lib/core/Math/Formula/Function/Subtotal.php
lib/core/Perms.php
lib/core/Perms/ResolverFactory/CategoryFactory.php
lib/core/Perms/ResolverFactory/ObjectFactory.php
lib/core/Search/Formatter.php
lib/core/Search/Indexer.php
lib/core/Search/Query/WikiBuilder.php
lib/core/Services/Cypht/Controller.php
lib/core/Services/Edit/PluginController.php
lib/core/Services/H5P/Controller.php
lib/core/Services/Tracker/Controller.php
lib/core/Services/Tracker/TabularController.php
lib/core/Services/Tracker/Utilities.php
lib/core/Tiki/Command/GetStringsCommand.php
lib/core/Tiki/MailIn/Source/Imap.php
lib/core/Tiki/MailIn/Source/Pop3.php
lib/core/Tiki/MemoryLimit.php
lib/core/Tiki/Profile/InstallHandler/WikiPage.php
lib/core/Tiki/SabreDav/Utilities.php
lib/core/Tiki/Sitemap/AbstractType.php
lib/core/Tiki/Sitemap/Generator.php
lib/core/Tiki/Sitemap/Type/Articles.php
lib/core/Tiki/Sitemap/Type/Blog.php
lib/core/Tiki/Sitemap/Type/Forums.php
lib/core/Tiki/Sitemap/Type/Page.php
lib/core/Tracker/Field/GroupSelector.php
lib/core/Tracker/Field/ItemsList.php
lib/core/Tracker/Field/Math.php
lib/core/Tracker/Filter/Collection.php
lib/core/Tracker/Rule/Definition.php
lib/core/Tracker/Rule/Type/Collection.php
lib/core/Tracker/Rule/Type/Text.php
lib/cypht/integration/classes.php
lib/cypht/modules/tiki/general_modules.php
lib/cypht/modules/tiki/setup.php
lib/cypht/site.js
lib/filegals/filegallib.php
lib/filegals/h5plib.php
lib/gitlib.php
lib/headerlib.php
lib/jquery_tiki/elfinder/tiki-elfinder.js
lib/jquery_tiki/inline_edit.js
lib/jquery_tiki/pluginedit.js
lib/jquery_tiki/tiki-jquery.js
lib/jquery_tiki/wikiplugin-pivottable.js
lib/language/CollectFiles.php
lib/parser/parserlib.php
lib/prefs/feature.php
lib/setup/twversion.class.php
lib/smarty_tiki/modifier.sefurl.php
lib/smarty_tiki/modifier.slug.php
lib/structures/structlib.php
lib/test/rating/AggregationTest.php
lib/tiki-js.js
lib/tikilib.php
lib/toolbars/toolbarslib.php
lib/trackers/trackerlib.php
lib/userslib.php
lib/vue/duration/DurationPicker.vue
lib/vue/duration/DurationPickerEditor.vue
lib/vue/duration/DurationPickerModal.vue
lib/vue/duration/DurationPickerTitle.vue
lib/vue/duration/styles.css
lib/wiki-plugins/wikiplugin_customsearch.php
lib/wiki-plugins/wikiplugin_cypht.php
lib/wiki-plugins/wikiplugin_group.php
lib/wiki-plugins/wikiplugin_pivottable.php
lib/wiki/editlib.php
lib/xmpp/ConverseJS.php
lib/xmpp/css/conversejs.css
lib/xmpp/js/conversejs-tiki-oauth.js
lib/xmpp/js/conversejs-tiki.js
README
robots.txt
route.php
templates/admin/include_security.tpl
templates/admin/include_trackers.tpl
templates/categorize.tpl
templates/database_connection_error.html
templates/filter_control/drop_down.tpl
templates/freetag.tpl
templates/header.tpl
templates/tiki-admin_calendars.tpl
templates/tiki-admin_categories.tpl
templates/tiki-admin_orphaned.tpl
templates/tiki-admin_sitemap.tpl
templates/tiki-admin_tracker_fields.tpl
templates/tiki-admingroups.tpl
templates/tiki-calendar.tpl
templates/tiki-edit_article.tpl
templates/tiki-edit_blog.tpl
templates/tiki-forums.tpl
templates/tiki-list_trackers.tpl
templates/tiki-upload_file.tpl
templates/tiki-view_forum.tpl
templates/tracker/import.tpl
templates/tracker/remove_fields.tpl
templates/tracker_actions.tpl
templates/tracker_sync/clone_remote.tpl
templates/trackerinput/duration.tpl
templates/trackerinput/userpreference.tpl
templates/wiki-plugins/wikiplugin_files.tpl
templates/wiki-plugins/wikiplugin_pivottable.tpl
templates/wiki-plugins/wikiplugin_subscribenewsletter.tpl
templates/wizard/changes_doc_page_iframe.tpl
templates/wizard/changes_new_in_22.tpl
tiki-admin_categories.php
tiki-admin_modules.php
tiki-caldav.php
tiki-calendar_edit_item.php
tiki-check.php
tiki-forums.php
tiki-index.php
tiki-login.php
tiki-setup.php
tiki-upload_file.php
tiki-user_preferences.php
tiki-view_forum_thread.php
vendor_bundled/composer.json
vendor_bundled/composer.lock

db/tiki-secdb_22.0_mysql.sql

db/tiki-secdb_22.1_mysql.sql
installer/schema/20210115_add_trackerfields_sefurl_tiki.sql
lib/core/Math/Formula/Function/PregReplace.php
lib/core/Search/Formatter/ValueFormatter/Url.php
lib/core/Services/Edit/Utilities.php
lib/core/Tracker/Rule/Operator/CollectionContainsUsername.php
lib/core/Tracker/Rule/Operator/TextIsUsername.php
lib/validators/validator_smarty.php
templates/examples/search/h5p.tpl
templates/examples/search/simple_table.tpl
tiki-robots.php
{CODE}

Rebuild Unified Search Index (with MYSQL FTS) failed: Identifier name too long:

{CODE()}
Indexing failed while processing "5528" (type trackeritem) with the error "Could not perform index modification: Identifier name 'tracker_field_losContenidosDistintosBloquesGuardanCoherenciaMPMMUAB' is too long"
...
(dozens of times a similar error)
...
Indexing failed while processing "4" (type sheet) with the error "Could not perform index modification: Identifier name 'tracker_field_losContenidosDistintosBloquesGuardanCoherenciaMPMMUAB' is too long"
Search index could not be rebuilt.
Could not perform index modification: Identifier name 'tracker_field_losContenidosDistintosBloquesGuardanCoherenciaMPMMUAB' is too long
No index available.
{CODE}

However, this message is shown below, as if the index was rebuilt:
{QUOTE()}Your index was last fully rebuilt on Viernes 15 de Noviembre, 2013 20:02:48 CET. {QUOTE}
---
UPDATE: {sign user="xavi" datetime="2013-11-18T17:13:36+00:00"}
credentials:
u: admin
p: 12345
* Reproduced in the associated show.t.o instance, also using Mysql FTS as the unified search engine.
* The "priority" field permanent name was renamed to "tracker_field_trac_as_cal_priority_losContenidosDistintosBloquesGuardanCoherenciaMPMMUAB", and rebuilding the index shows:
+ {CODE()}
Indexing failed while processing "1" (type trackeritem) with the error "Could not perform index modification: Identifier name 'tracker_field_trac_as_cal_priority_losContenidosDistintosBloquesGuardanCoherenciaMPMMUAB' is too long"
Indexing failed while processing "2" (type trackeritem) with the error "Could not perform index modification: Identifier name 'tracker_field_trac_as_cal_priority_losContenidosDistintosBloquesGuardanCoherenciaMPMMUAB' is too long"
Indexing failed while processing "3" (type trackeritem) with the error "Could not perform index modification: Identifier name 'tracker_field_trac_as_cal_priority_losContenidosDistintosBloquesGuardanCoherenciaMPMMUAB' is too long"
Search index could not be rebuilt.
Could not perform index modification: Identifier name 'tracker_field_trac_as_cal_priority_losContenidosDistintosBloquesGuardanCoherenciaMPMMUAB' is too long
No index available.
{CODE}
* And
+ {QUOTE()}
Your index was last fully rebuilt on Monday 18 of November, 2013 17:33:04 CET.
{QUOTE}

---
UPDATE: Something similar showed up in a 12.x production site when I changed the unified search engine from "Lucene" to "Mysql Full Text Search".

Rebuilding index now reports:
{CODE()}ssh-w00ec615@dd29038:/www/htdocs/w00ec615/12x$ php console.php index:rebuild
Started rebuilding index...
Indexation
wiki page: 2
file: 0
trackeritem: 2
sheet: 1
comment: 0
Rebuilding index done
{CODE}

This was always in the web interface and recently added to the command line in http://sourceforge.net/p/tikiwiki/code/48172/
Great!

What would be even more useful is to have the same stats that are provided by the "Server Load" module from tiki-admin_modules.php, which provides Execution time, Memory usage and number of Queries

So then, we can get an idea when it's getting too long or using too much RAM.

We'd want this both in web & command line. This could be added to the ((Monitoring)) system and we could monitor system health.

Thanks!

If you rename a page, the old page name is still in the index.

I would like TikiWiki's search engine to return results with links to matching sections within pages.

A Wikipedia example of this would be a search for "Life and career." It brings up an entry for John R. Brinkley that has links to the entire article on John R. Brinkley (http://en.wikipedia.org/wiki/John_R._Brinkley) and another for the "Political career" section of that page (http://en.wikipedia.org/wiki/John_R._Brinkley#Political_career).

If I tried to do this in TikiWiki, I would get a search result with a link like the following:

http://mywiki/tiki-index.php?Page=John_R._Brinkley&highlight=Political%20career

That might help if I were searching for this in Google, but it doesn't do what the wiki content creators at my company want. If there is a workaround, I'd love to hear it.

wiki page names, wiki page descriptions, etc should not only be indexed but the weight should be higher than text in the the wiki page.

Same logic should apply to all features.

{img src=show_image.php?id=93}

{syntax type="tiki" editor="plain"}
When doing a search in "Development Report bugs, Improve code" area, the search results are shoved to the right side instead of centered on the page, as the rest of the content is.


This makes a search result almost impossible to read.

I suppose this is in release 5 because we are eating our own dogfood - right? It isn't tasting very good today.

Under TikiWIki 21(.2) only the page title is displayed in the search results list, but no longer text in the content section.
See also the forum post: https://tiki.org/forumthread75156-Search-content-section-is-empty

We tested once in the demo area on tiki.org.
There, pages with Lorem ipsum content were created and then we searched for Lorem.
All pages were listed as results but no content was displayed.

In the local test with newly created databases with TikiWiki 18.2 and TikiWiki 21.2, the text content appears under 18.2 but under 21.2 a number instead:

Even rebuilding the search index does not change this.

Example Link:
http://webclassix-12006-7532.show2.tikiwiki.org/tiki-searchindex.php?filter%7Econtent=lorem&sort_mode=score_ndesc
{img fileId="1447" thumb="box"}

Site with content:
http://webclassix-12006-7532.show2.tikiwiki.org/tiki-index.php?page=testpage&highlight=lorem
{img fileId="1448" thumb="box"}

Search (index) need sometimes to "Explode" a itemList field values as an array of string so each value can be filtered

For an exemple, in a tracker you have an itemList fields using this date field with such values:
* tracker_field_date: 2021-03-24, 2021-01-14, 2020-10-22

To filter per date (we need item that contain "2021-03-24" only) we can should be able to use multivalue.

{CODE(caption="filter set in a smarty template, work the same elsewhere")}
{filter field="tracker_field_date" multivalue="{/literal}{$row.tracker_field_holidayDay}{literal}"}
{CODE}

''Note: if you use content you may filter "2021-03-24 and 2021-01-14 because they both contain "2021"''

This is working fine if you use elasticSearch but doesn’t when you use Mysql.

Search and auto complete only work when logged in. When not logged in tiki-listpages.php is completely blank when performing a search and no auto completes are shown.

See http://screencast.com/t/XEJzwKo97k

I am using the 7.x head build. I know the tradeoffs versus using a stable build. I can't go back, though.

#The new, improved search box is partially hidden by the right-hand column of modules.
#The user login name is invisible.

My current site theme is jqui. I have tried other themes, but each one seems to have a different problem.

While these are not breaking problems, they affect the usability of my site, and I am willing to pay a consultant to help me fix them.

Will record a screencast. Hard to explain. You have to see it to believe it :-)

This tracker item could not be found

Currently search displays markup code in results... Could there be an option to filter out parsed code? Code between ~np~ and ~pp~ tags however, is part of the desired search content (but should still remain unparsed).

Thank you,

OC
---
also:
http://tikiwiki.org/tiki-view_forum_thread.php?topics_offset=66&topics_sort_mode=lastPost_desc&forumId=4&comments_parentId=21785