Sphinx and the Translate Extension

Has anyone configure Sphinx to work with the translate extension? It seems the translate extension uses subpages for the translated pages and was curious if anyone tried to have the user default language or the translate user options to help refine the search results. The easy option would be to configure the translate extension to a namespace for each language, but that would just explode the number of namespaces to manage and doesn't seem maintainable long term. Skunark (talk) 04:10, 23 January 2014 (UTC)

wgSphinxSearch_weights not working?

so i set $wgSphinxSearch_weights to: $wgSphinxSearch_weights = array( 'old_text' => 1, #'page_title' => 1000, 'page_counter' => 100 );

yet the page with 486 viewsis in 3rd place and the page with 18 counters, im missing something?, do i have to call wgSphinxSearch_weights in another place? 12.226.128.130 18:01, 31 January 2014 (UTC)

page_counter field is not in the default sphinx.conf query. Did you add it there yourself? It should be something like this:

sql_query = SELECT page_id, page_title, page_namespace, page_is_redirect, page_counter, old_id, old_text FROM page, revision, text WHERE rev_id=page_latest AND old_id=rev_text_id

# attribute columns

sql_attr_uint = page_namespace

sql_attr_uint = page_is_redirect

sql_attr_uint = page_counter

sql_attr_uint = old_id Svemir Brkic (talk) 21:28, 31 January 2014 (UTC)

yes, i used this sql query

sql_query = SELECT \

page_id, \

page_title, \

page_namespace, \

page_is_redirect, \

old_id, \

old_text, \

page_counter AS view_cnt, \

link_cnt \

FROM page \

INNER JOIN revision \

ON rev_id = page_latest \

INNER JOIN text \

ON old_id = rev_text_id \

LEFT JOIN link_count \

ON page_id = link_count_id

from the Extension:SphinxSearch/Page rank 12.226.128.130 20:46, 3 February 2014 (UTC)

and:

sql_attr_uint = page_namespace

sql_attr_uint = page_is_redirect

sql_attr_uint = old_id

sql_attr_uint = view_cnt

sql_attr_uint = link_cnt

(i dont know why but it seems i cant edit my answers here) 12.226.128.130 20:48, 3 February 2014 (UTC)

Have you tried running your queries with Extension:SphinxSearch/SphinxQL? You can see all the columns and values which should then give you a little more insight into what is going on. Mattsmith321 (talk) 03:14, 7 February 2014 (UTC)

I installed SphinxSearch Extension using this tutorial - but it doesn't seem to be working

Case sensitive issue with title match in search.

I have sphinx installed. If I search for 'our natural pets' the article 'Our Natural Pets' comes back. However, if I search for 'food allergies in pets' the article 'Food Allergies in Pets' will not show up directly, rather it will just show in the search results. I've contacted sphinx and they said the engine is running as it should. There is something in the SphinxSearch Extension, or in the MediaWiki core that is trying to match the title. This is bypasing the sphinx search altogether and this is where the case sensitive issue is. Can someone help me with this? Lucy Tech 07:32, 20 February 2014 (UTC)

solved by installing https://www.mediawiki.org/wiki/Extension:TitleKey LTech (talk) 08:25, 20 February 2014 (UTC)

redirect pages showing in search results

I have set some pages to redirect to a different page on the site. When I search using sphinx pages the results shows as eg Monk Parrot REDIRECT Quaker Parrot I don't want pages that have been redirected to show up in the search results. How do I configure the sphinx so they don't show up, or will only show when an admin searches? LTech (talk) 10:12, 3 March 2014 (UTC)

In your sphinx.conf, there are two "sql_query" entries that specify the database queries sphinx uses to get the data. You could add something like this in the WHERE clauses of those queries to make them skip redirects:

and page_is_redirect = 0

After that, reindex the wiki. Svemir Brkic (talk) 12:35, 1 May 2014 (UTC)

Incategory, Intitle, Prefix not working for me

Hi, I have installed SphinxSearch Extension (0.8.5) on MediaWiki 1.21.1 and Sphinx (2.2.4). The general engine works well, including "did you mean" and other nice features. But I cannot make to work the incategory, intitle and prefix search.

The sql_attr_multi = uint category from query; SELECT... is there.

What else can I check? Thank you for your help. Gborgonovo (talk) 12:56, 23 May 2014 (UTC)

UPDATE. It is working indeed, I found it does not work if I use + or - in front of incategory. I.e. +incategory:"Mycategory" does not work, instead myword incategory:Mycategory works.

And this (almost) solves my problem. Thank you. Gborgonovo (talk) 09:43, 26 May 2014 (UTC)

There is a phabricator task for this now: https://phabricator.wikimedia.org/T155306 Svemir Brkic (talk) 01:54, 23 September 2019 (UTC)

Do not call this method...

Hello,

I have the following error flooding my apache's error.log file everytime a user performs a search:

DEPRECATED: Do not call this method or, even better, use SphinxQL instead of an API in /var/www/wiki/extensions/SphinxSearch/sphinxapi.php on line 763, referer: XXX

Line 763 and the ones after it of sphinxapi.php is as follows:

 function SetMatchMode ( $mode )
        {
                trigger_error ( 'DEPRECATED: Do not call this method or, even better, use SphinxQL instead of an API', E_USER_DEPRECATED );
                assert ( $mode==SPH_MATCH_ALL
                        || $mode==SPH_MATCH_ANY
                        || $mode==SPH_MATCH_PHRASE
                        || $mode==SPH_MATCH_BOOLEAN
                        || $mode==SPH_MATCH_EXTENDED
                        || $mode==SPH_MATCH_FULLSCAN
                        || $mode==SPH_MATCH_EXTENDED2 );
                $this->_mode = $mode;
        }

I am using SphinxQL. I have the following lines in sphinx.conf:

listen          = 127.0.0.1:9312
listen          = localhost:9306:mysql41

Netstat confirms that searchd is linstening on port 9306:

root@WIKI:/etc/sphinxsearch# netstat -nlp | grep searchd
tcp        0      0 127.0.0.1:9306          0.0.0.0:*               LISTEN      25975/searchd
tcp        0      0 127.0.0.1:9312          0.0.0.0:*               LISTEN      25975/searchd

185.31.48.30 11:49, 9 June 2014 (UTC)

You may be using SphinxQL, but the extension does not. For now you can remove that trigger_error line from sphinxapi.php. Svemir Brkic (talk) 12:03, 9 June 2014 (UTC)

Oh I see :) Thank you very much for the info. 185.31.48.30 12:17, 9 June 2014 (UTC)

The extension does not connect to the deamon.

Hi Guys,

I'm getting these kind of warnings. [Thu Jul 24 11:41:37 2014] [error] [client 10.10.24.30] PHP Warning: assert(): Assertion failed in /var/www/html/mediawiki-1.23.1/extensions/SphinxSearch/sphinxapi.php on line 850, referer: http://famed-wiki/wiki/index.php?search=FAHF-637&title=Speciaal%3AZoeken&go=OK

When I search by hand it can find things.

[root@wiki SphinxSearch]# search --config /etc/sphinx/sphinx.conf ICT Operations Sphinx 2.1.9-id64-release (rel21-r4761) Copyright (c) 2001-2014, Andrew Aksyonoff Copyright (c) 2008-2014, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinx/sphinx.conf'... index 'wiki_main': query 'ICT Operations ': returned 72 matches of 72 total in 0.000 sec

displaying matches: 1. document=2304, weight=4635, page_namespace=0, page_is_redirect=0, old_id=36833, category=()

       page_title=Werkprocedure_ICT_Operations
       page_namespace=0

words: 1. 'ict': 143 documents, 477 hits 2. 'oper': 110 documents, 282 hits

index 'wiki_incremental': query 'ICT Operations ': returned 0 matches of 0 total in 0.000 sec

words: 1. 'ict': 0 documents, 0 hits 2. 'oper': 3 documents, 8 hits

Any ideas?

Server specs: PHP 5.3.3, Apache 2.2, RHEL 6. 62.177.161.242 09:58, 24 July 2014 (UTC)

try to run bellow command:

setsebool -P httpd_can_network_connect 1

running time a bit long, wait patiently :) Zhoujinghui (talk) 03:39, 31 October 2014 (UTC)

How to create new MW page?

I am on MW 1.23, Sphinx 2.2.4 and sphinxsearch 0.8.5 (tried 0.9.0 also).

The link for creating a new page is missing in case a search term is not found.

How can I create a new page (without writing it in the URL)?

Thanks,

Juergen 92.50.121.166 14:25, 13 August 2014 (UTC)

Zero search results using SphinxSearch a couple weeks after install

Hi there,

I'm running MediaWiki 1.21.2 on Ubuntu Server 12.04.3 LTS. I'm also using SphinxSearch. It worked for a couple weeks, but now no matter what I search for on the Wiki, the results are nothing. I'm not sure why it would randomly stop working. Maybe I skipped a step? Did I not configure the "refresh" or "update" part of things? There's a word for it, but I'm not a Linux guy so I don't quite remember. Thank you!!

Mark Enkei (talk) 20:59, 19 August 2014 (UTC)

This is better late than never, but it might help someone else.

If SphinxSearch suddenly stopped working on your Wiki, make sure your search daemon is running:

ps -ef | grep searchd

If you need to restart the daemon, you can use a command similar to this:

searchd --config /etc/sphinxsearch/sphinx.conf >> /var/log/sphinxsearch/sphinx-startup.log 2>&1 50.203.11.18 23:17, 23 March 2015 (UTC)

incategory parameter return fatal error

When I type to search incategory:word then it returns server blank page with php fatal error:

Fatal error: Call to a member function selectField() on a non-object in E:\usr\Apache2.2\htdocs\wiki\extensions\SphinxSearch\SphinxMWSearch.php on line 298

SphinxMWSearch.php, line 298:

		$page_id = $this->db->selectField( 'page', 'page_id',

it's within function filterByCategory:

	function filterByCategory( $matches ) {
		$page_id = $this->db->selectField( 'page', 'page_id',
			array(
				'page_title' => $matches[ 3 ],
				'page_namespace' => NS_CATEGORY
			),
			__METHOD__
		);
		$category = intval( $page_id );
		if ( $matches[ 1 ] === '-' ) {
			$this->exc_categories[ ] = $category;
		} else {
			$this->categories[ ] = $category;
		}
		return '';
	}

My configuration:

Sphinx     2.1.9
SphinxSearch extension: 0.8.5
MediaWiki  1.23.2
PHP	   5.4.27 (apache2handler)
MySQL	   5.6.19-log
Apache	   2.2.25
OS	   Windows XP 64bit

Pit pl (talk) 14:33, 27 August 2014 (UTC)

I'm having the exact same difficulties.

Sphinx 2.2.5-id64-release (r4825)

SphinxSearch: 0.9.0 (87d7247)

MediaWiki: 1.23.2

PHP: 5.3.17

MySQL: 5.5.33.

Apache/2.2.12 (Linux/SUSE) Skjaeveland (talk) 10:57, 20 November 2014 (UTC)

Mediawiki-1.24.0 SphinxSearch Error

Environment：

mediawiki-1.24.0.tar.gz

SphinxSearch-REL1_24-06ae4ec.tar.gz

1. rpm -qa | grep php

php-pecl-memcached-2.1.0-8.fc20.armv7hl

php-pecl-jsonc-1.3.6-1.fc20.armv7hl

php-pdo-5.5.19-3.fc20.armv7hl

php-xml-5.5.19-3.fc20.armv7hl

php-cli-5.5.19-3.fc20.armv7hl

php-mysqlnd-5.5.19-3.fc20.armv7hl

php-gd-5.5.19-3.fc20.armv7hl

php-pecl-sphinx-1.2.0-2.fc20.armv7hl

php-pecl-igbinary-1.2.1-1.fc20.armv7hl

php-common-5.5.19-3.fc20.armv7hl

php-process-5.5.19-3.fc20.armv7hl

php-fpm-5.5.19-3.fc20.armv7hl

php-pecl-jsonc-devel-1.3.6-1.fc20.armv7hl

php-devel-5.5.19-3.fc20.armv7hl

php-pear-1.9.5-3.fc20.noarch

Log:

2014/12/02 22:56:16 [error] 11643#0: *465 FastCGI sent in stderr: “PHP message: PHP Fatal error: Cannot call constructor in /opt/www/extensions/SphinxSearch/SphinxMWSearch.php on line 549” while reading response header from upstream, client: 122.97.252.140, server: wiki.atyu30.com, request: “GET /index.php?search=+%E5%88%A0%E9%99%A4%E9%9D%9E%E7%A9%BA%E6%96%87%E4%BB%B6%E5%A4%B9&title=Special%3A%E6%90%9C%E7%B4%A2&fulltext=%E6%90%9C%E7%B4%A2 HTTP/1.0”, upstream: “fastcgi://unix:/var/run/php-fpm/php5-fpm.sock:”, host: “wiki.atyu30.com”, referrer: “http://wiki.atyu30.com/%E8%AE%A1%E7%AE%97%E6%9C%BA%E5%AE%9E%E9%99%85%E4%B8%8A%E6%98%AF%E5%A6%82%E4%BD%95%E5%B7%A5%E4%BD%9C%E7%9A%84” 58.215.221.179 07:09, 5 December 2014 (UTC)

I had the same issue which I solved by adding the following line to the start of the filterByCategory function in SphinxMWSearch.php:

 $this->db = wfGetDB( DB_SLAVE );

The resulting function is as followings:

  function filterByCategory( $matches ) {
                $this->db = wfGetDB( DB_SLAVE );
                $page_id = $this->db->selectField( 'page', 'page_id',
                        array(
                                'page_title' => $matches[ 3 ],
                                'page_namespace' => NS_CATEGORY
                        ),
                        __METHOD__
                );
                $category = intval( $page_id );
                if ( $matches[ 1 ] === '-' ) {
                        $this->exc_categories[ ] = $category;
                } else {
                        $this->categories[ ] = $category;
                }
                return '';
        }

My Configuration:

Spinx 2.2.9
SphinxSearch MW Extension  0.9
MediaWiki 1.24.1

Wmurphy93 (talk) 09:22, 22 May 2015 (UTC)

It seems that the real problem is in that error message: Cannot call constructor in /opt/www/extensions/SphinxSearch/SphinxMWSearch.php on line 549” while reading response header from upstream

If constructor got called, $this->db would have been setup. I will try to replicate this somehow, but if not, I guess what you did would work too, just better to use $this->db = wfGetDB( DB_REPLICA ); (all this may depend on the MW version too) Svemir Brkic (talk) 03:13, 17 September 2019 (UTC)

MW 1.23.3 vs. SphinxSearch 0.8.5 or 0.9.0: variable showRedirects missing

What is the difference between Ranking, Sorting, Matching modes and Filtering in Sphinxsearch?

I want to know what is the difference between ranking, sorting, matching modes and filtering in Sphinx and how can I do more than one thing at a time.

In documentation also, it is written you can do ranking and sorting simultaneously. How is it possible because if I rank then results will be arranged in some order and if I do sorting the results will be arranged in some different order.

If possible please explain using some example. I am using version 2.1.9.

Please don't refer me to Sphinx documentation. I have already read it.

Every answer is appreciated.

Thanks in advance. Ankitgoyal91 (talk) 05:53, 6 September 2014 (UTC)

Ranking controls how the weight of each match is calculated. Sorting will by default sort by that ranking, but you can use advanced sorting mode to sort by things other then the ranking (or by something else in addition to the ranking, so that two articles with the same @weight are further sorted by something you specify, such as page_title or old_id.)

Filtering will filter things out not to show at all, so in the above scenarios it happens first, and therefore you can filter "at the same time" with ranking and sorting. Svemir Brkic (talk) 01:52, 23 September 2019 (UTC)

sphinx search only search main namespace

We have mediawiki 1.23 and SphinxSearch-REL1_23-6afde48 installed. We could search, however, it only search pages under main namespace although other namespaces are selected.

Any suggestion? Thanks a lot! 148.87.19.222 19:30, 22 September 2014 (UTC)

example

example

MediaWiki Doesn't Appear To Be Using Sphinx For Search

       page_title=Test_Page
       page_namespace=0

MediaWiki Doesn't Appear To Be Using Sphinx For Search

       page_title=Test_Page
       page_namespace=0

Search not working after upgrade to MW 1.24