Main Page: Difference between revisions

From MediaWiki-1.39
Jump to navigation Jump to search
Line 123: Line 123:
** <code>mw_tag_pages</code> — one row per approved page.
** <code>mw_tag_pages</code> — one row per approved page.
* If needed, run: <code>php maintenance/update.php --quick</code>
* If needed, run: <code>php maintenance/update.php --quick</code>
{{Note|Only run <code>update.php</code> if <code>mw_customquerypage_settings</code> doesn't exist yet.}}
{{Note|Note: Only run <code>update.php</code> if <code>mw_customquerypage_settings</code> does not exist yet, or if you are intentionally applying the CustomQueryPage schema changes in a controlled maintenance window.}}
 
=== 2. Use the Special Page to Switch or Clone ===
=== 2. Use the Special Page to Switch or Clone ===



Revision as of 20:39, 13 March 2026


Info: Updated March 12, 2026.


Reset ROUTINE manually

ROUTINE issue patch to fallback settings

Method 1: Change the fallback ROUTINE in LocalSettings.php

Use this as a quick test or temporary recovery step.

Edit this line in LocalSettings.php:

<syntaxhighlight lang="php"> $wgCustomQueryPageDefaultTag = 'ROUTINE_4.111'; </syntaxhighlight>

Then:

  1. Save the file.
  2. Reload Special:RoutineTags.
  3. Reload Special:ApprovedManuals.

If nothing changes:

  1. Do a hard refresh in the browser.
  2. If it is still unchanged, ask the sysadmin to restart PHP or the container.
  3. Reload both special pages again.

Expected result:

  • If the page starts showing ROUTINE_4.111, the extension is reading the fallback value from configuration.
  • If it still shows ROUTINE_4.110, this change did not affect the current read path.

Method 2: Quick page check

After Method 1, check both pages, not just one:

Things to confirm:

  • Does Special:RoutineTags show ROUTINE_4.111 as the visible current or default tag?
  • Does the heading on Special:ApprovedManuals change to the new ROUTINE?
  • Does the document list appear to match the intended release?

This is the easiest check available when direct SQL access is not available.

Method 3: See documentation

Link TBD

Use the ROUTINE workflow and recovery notes for deeper troubleshooting.

Known points:

  • ROUTINE labels are stored in mw_tags.
  • ROUTINE membership is stored in mw_tag_pages.
  • The current approved set is stored in mw_approved_revs.
  • The active selected ROUTINE is stored in mw_customquerypage_settings.
  • Activating a ROUTINE rebuilds mw_approved_revs.
  • Rollback is done by reactivating the previous ROUTINE.

If the manual LocalSettings.php edit and page refresh do not restore expected behaviour, continue with the documented extension workflow and technical recovery notes.


Info: Released Vesion 1.0 is available as Latest Version released Feb 26, 2026

CustomQueryPage – latest deployment bundle

File:CustomQueryPage-latest.tgz

Data model summary: page_latest tracks the most recent edit, mw_approved_revs identifies the revision currently approved for display, and each ROUTINE snapshot in mw_tag_pages records which revision belongs to that release.


The following information can be used as an installation guide. Only download files tagged latest


OBSOLETE Pre-release

MediaWiki has been installed.

   Upcoming Event: Wiki launch 
Scheduled for: February 12th at Lisa's Desk

Count down to the retirement of the efs3 server!

content is content

Import CustomQueryPage

This install is originally intended for the ROUTINE Manuals publication workflow. That's all it does now, but hey, it's a good place to keep notes too. Did you know for MediaWiki you create a page by writing the name in the address bar? How tricky is that?

NOTE

Nice to have: the Special:CustomQuerySettings page has a [Clone ROUTINE] button it should also have a [Reset] button in case I want to do it again.

Let's Get Started


CustomQueryPage – latest deployment bundle

Installing CustomQueryPage

  • Download the bundle: wget https://mw.eckford.ca/downloads/CustomQueryPage-mw1359.tar.gz
  • Extract it into your extensions folder:
    • tar -xzf CustomQueryPage-mw1359.tar.gz -C /srv/mediawiki/extensions
  • Edit LocalSettings.php and add wfLoadExtension( 'CustomQueryPage' );
  • Run php maintenance/update.php --quick.
  • Visit Special:CustomQuerySettings, set the ROUTINE tag (e.g., ROUTINE_4.110), and confirm Special:ApprovedManuals.

Quick Start: ROUTINE Management

1. Seed the ROUTINE in the DB

Before Lisa touches the UI, make sure the database has ROUTINE data.

  • Use the import script or manual SQL method.
  • Required tables:
    • mw_tags — one row per ROUTINE (e.g., ROUTINE_4.111).
    • mw_tag_pages — one row per approved page.
  • If needed, run: php maintenance/update.php --quick

Note: Note: Only run update.php if mw_customquerypage_settings does not exist yet, or if you are intentionally applying the CustomQueryPage schema changes in a controlled maintenance window.


2. Use the Special Page to Switch or Clone

Please note that the Revision is part of this query and display. Any documents that have been approved since the last release should have a new revision and this new revision should be included in the ROUTINE_tag

  • Go to: Special:CustomQuerySettings
  • Two options:
    • Set Active Tag — type ROUTINE_4.111, then Save.
    • Clone ROUTINE → New ROUTINE:
      • From: ROUTINE_4.110
      • To: ROUTINE_4.111
      • Submit → this copies rows and updates the active tag.

3. Verify the Result

  • Visit: Special:ApprovedManuals
  • Confirm the listing shows ROUTINE_4.111
  • Lisa can now publish or review the approved manuals.
  • No DB access required.

Optional: JSON/API Importer

If you're ready to skip the SQL import:

  • Define a JSON payload that includes:
    • page_id, rev_id, deploy_comment, wikitext, etc.
  • Build a:
    • REST endpoint, or
    • Action API module, or
    • Maintenance script that reads JSON

Once defined, MediaWiki can import directly into mw_tags / mw_tag_pages.

⚠️

Warning: Avoid touching the database manually if you want to adopt the JSON route. The importer will safely handle all insertions.