Page MenuHomePhabricator

warnings thrown during search using Postgresql
Closed, ResolvedPublic

Description

Author: john.andrea

Description:
With Postgresql 8.4.8 as the backend, a search throws up this warning at the top of the results page

"Warning: pg_fetch_result(): supplied argument is not a valid PostgreSQL result resource in /data/services/wiki/mediawiki-1.17.0/includes/search/SearchPostgres.php on line 156"

The page does continue what what seems to be valid results.

Section of code:

function searchQuery( $term,
...
$searchstring = $this->parseQuery( $term );
$SQL = "SELECT to_tsquery($prefix $searchstring)";
$res = $this->db->query($SQL);
$top = pg_fetch_result($res,0,0);


Version: 1.17.x
Severity: normal

Details

Reference
bz31006

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
InvalidNone
ResolvedNone

Event Timeline

bzimport raised the priority of this task from to Low.Nov 21 2014, 11:52 PM
bzimport added a project: MediaWiki-Search.
bzimport set Reference to bz31006.
bzimport added a subscriber: Unknown Object (MLST).

This code has been changed in 1.18 and later. Can you test with a SVN checkout from REL1_18 branch?

http://www.mediawiki.org/wiki/Download_from_SVN#Download

john.andrea wrote:

I may have some time to try 1.18 soon.

  • This bug has been marked as a duplicate of bug 35043 ***
Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.