Last modified: 2012-08-04 20:48:44 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 12732 - tsearch changes in PostgreSQL 8.3
tsearch changes in PostgreSQL 8.3
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
All All
: High major with 1 vote (vote)
: ---
Assigned To: Nobody - You can work on this!
: 12821 (view as bug list)
Depends on:
Blocks: postgres
  Show dependency treegraph
Reported: 2008-01-21 22:04 UTC by OverlordQ
Modified: 2012-08-04 20:48 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description OverlordQ 2008-01-21 22:04:57 UTC
In PostgreSQL 8.3 all of the tsearch functionality is now integrated.

Thankfully since this only affects Postgres, changes should (AFAIK) be minimal.
Comment 1 OverlordQ 2008-01-21 23:11:15 UTC
Oh I guess I should have mentioned this completely breaks a new install. Not sure about existing installations, everything but searches should work.

Don't really know where this should go on the priority or severity list as Postgres 8.3 is at RC2.
Comment 2 OverlordQ 2008-01-26 03:17:02 UTC
I stand corrected, this affects editing pages as well.

A database error has occurred Query: INSERT INTO page (page_id,page_namespace,page_title,page_counter,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len) VALUES ('3','0','Main_Page','0','','0','1','0.830391437959','2008-01-26 03:15:23 GMT','0','0') Function: Article::insertOn Error: 1 ERROR: text search configuration "default" does not exist CONTEXT: PL/pgSQL function "ts2_page_title" line 3 at assignment


#0 /home/wiki/includes/Database.php(799): DatabasePostgres->reportQueryError('ERROR: text se...', 1, 'INSERT INTO pag...', 'Article::insert...', 0)
#1 /home/wiki/includes/DatabasePostgres.php(767): Database->query('INSERT INTO pag...', 'Article::insert...', 0)
#2 /home/wiki/includes/Article.php(1011): DatabasePostgres->insert('page', Array, 'Article::insert...')
#3 /home/wiki/includes/Article.php(1425): Article->insertOn(Object(DatabasePostgres))
#4 /home/wiki/includes/Article.php(1202): Article->doEdit('asdfasdf', 'asdf', 97)
#5 /home/wiki/includes/EditPage.php(820): Article->insertNewArticle('asdfasdf', 'asdf', false, false, false, false, false)
#6 /home/wiki/includes/EditPage.php(2180): EditPage->internalAttemptSave(false, false)
#7 /home/wiki/includes/EditPage.php(463): EditPage->attemptSave()
#8 /home/wiki/includes/EditPage.php(323): EditPage->edit()
#9 /home/wiki/includes/Wiki.php(444): EditPage->submit()
#10 /home/wiki/includes/Wiki.php(48): MediaWiki->performAction(Object(OutputPage), Object(Article), Object(Title), Object(User), Object(WebRequest))
#11 /home/wiki/index.php(89): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User), Object(WebRequest))
#12 {main}
Comment 3 Shuugo 2008-01-28 18:45:07 UTC
*** Bug 12821 has been marked as a duplicate of this bug. ***
Comment 4 Shuugo 2008-01-28 18:47:46 UTC
Final version of postgresql 8.3 is planned to be in a month as maximum and servers depending only on postgresql can't use mediawiki.

I need to be in version 8.3 for other software I have so downgrading is something that can't be done.
Comment 5 Greg Sabino Mullane 2008-02-10 15:49:34 UTC
This is fixed for new installs as of r30795, but no provision for upgrading from pre 8.3 installations yet.

Note You need to log in before you can comment on or make changes to this bug.