German Language flagEnglish Language flag
// Log In
Project: evolvis
// Summary // Activity // Search // SCM // Management Project
// View Trackers // old Bug Reports // Download .csv // Monitor

[#1031] Broken search in gf-p-mediawiki

Details
Status:
Closed
Resolution:
Fixed
Priority:
1
Assigned to:
Nobody (None)

Votes: 0/0 (0%)

Version:
-
Linked Bugs:
-
Date Submitted:
2010-10-27 12:21
Date Closed:
09/23/2011 11:17

Submitted by:
Thorsten Glaser (mirabilos)

Permalink
https://evolvis.org/tracker/t_follow.php/1031

Item Detail Information:
application/json / text/plain

Please login
Item Description
Summary*:
Broken search in gf-p-mediawiki
Detailed description:

Enter the Wiki of the Evolvis project:

https://evolvis.org/plugins/mediawiki/wiki/evolvis/index.php/Main_Page

Locate the “search” box on the left-hand side. Type “Features” into the
input box and hit the 「Search」 button (*not* Return key). End up on:
https://evolvis.org/plugins/mediawiki/wiki/evolvis/index.php?title=Special%3ASearch&search=Features&fulltext=Search

-----BEGIN SNIPPET-----
Search results
You searched for Features (all pages starting with "Features" | all pages that link to "Features")
For more information about searching Evolvis Wiki, see Help.
Features 1Special:SearchSearchSearch
No page text matches
Note: Only some namespaces are searched by default. Try prefixing your query with all: to search all content (including talk pages, templates, etc), or use the desired namespace as prefix.
-----END SNIPPET-----

There is, however, a page matching “Features” in the Wiki, namely:
https://evolvis.org/plugins/mediawiki/wiki/evolvis/index.php/SharePoint_Features

Why is this page not found, and how can this bug be fixed?

Followups: ▼△ Sort comments antichronologically

Date: 2010-10-27 14:28
From:

While I can certainly see this bug on evolvis.org, I've tried to reproduce it locally (on a fresh Lenny + Evolvis 4.8.3+evolvis27 installation), and I didn't manage. I initially suspected a mismatch in version numbers (PostgreSQL and/or Mediawiki), but
https://evolvis.org/plugins/mediawiki/wiki/evolvis/index.php/Special:Version tells me I'm using the same versions as you are, so that's a false start.

I believe Mediawiki is using the full-text search facility of PostgreSQL, at least here. If I enable query logging in the database, I get the following bits of SQL:

2010-10-27 16:24:45 CEST LOG: instruction : SELECT to_tsquery( 'Features')
2010-10-27 16:24:45 CEST LOG: instruction : SELECT /* SearchPostgres Admin */ page_id, page_namespace, page_title, ts_rank(titlevector, to_tsquery( 'Features'), 5) AS score FROM page p, revision r, pagecontent c WHERE p.page_latest = r.rev_id AND r.rev_text_id = c.old_id AND titlevector @@ to_tsquery( 'Features') AND page_is_redirect = 0 AND page_namespace IN ('0') ORDER BY score DESC, page_id DESC LIMIT 20 OFFSET 0
2010-10-27 16:24:45 CEST LOG: instruction : SELECT to_tsquery( 'Features')
2010-10-27 16:24:45 CEST LOG: instruction : SELECT /* SearchPostgres Admin */ page_id, page_namespace, page_title, ts_rank(textvector, to_tsquery( 'Features'), 5) AS score FROM page p, revision r, pagecontent c WHERE p.page_latest = r.rev_id AND r.rev_text_id = c.old_id AND textvector @@ to_tsquery( 'Features') AND page_is_redirect = 0 AND page_namespace IN ('0') ORDER BY score DESC, page_id DESC LIMIT 20 OFFSET 0

Do you have similar queries? What happens if you run them by hand?

Date: 2010-10-27 14:56
From:
Date: 2010-10-27 15:47
From:
Date: 2010-10-28 09:14
From: Thorsten Glaser

Workaround put into action, merci!

Keeping this open with low priority to get it resolved
upstream, maybe…

Date: 2011-08-31 08:28
From: Thorsten Glaser

I reported this upstream, but not as a bug, because this is apparently a pre-8.3 compatibility mode which I guess infers we need to update/regenerate the search database:

http://www.mediawiki.org/w/index.php?title=Thread:Project:Support_desk/PostgreSQL_and_the_database_search

Let’s see what upstream says to this.

* indicates required fields.
Item Relationships
You do not have sufficient privileges to view Task relations.
History

No Changes Have Been Made to This Item