Page MenuHomePhabricator

Fix sql_query in sphinx.conf
Open, Needs TriagePublic

Description

After upgrading our wiki to MW 1.34, we noticed updated pages dropping from the index.

Using recent versions of MW, the sql_query parameter should be changed to:

sql_query = SELECT page_id, page_title, page_namespace, page_is_redirect, old_id, old_text FROM page, slots, content, text WHERE slots.slot_revision_id=page.page_latest AND content.content_id=slots.slot_content_id AND text.old_id=REPLACE(content.content_address, 'tt:', '')

Initially posted to: https://www.mediawiki.org/wiki/Topic:Vkmeh7v01ai6p3ka

Event Timeline

Hi @Lavamind, thanks for taking the time to report this and welcome to Wikimedia Phabricator!
And also thanks for taking a look at the code! You are welcome to use developer access to submit the proposed code changes as a Git branch directly into Gerrit which makes it easier to review and provide feedback. If you don't want to set up Git/Gerrit, you can also use the Gerrit Patch Uploader. Thanks again!