Main Page

From MediaWiki-1.39
Revision as of 08:49, 17 March 2026 by 172.97.51.228 (talk) (→‎1. Seed the ROUTINE in the DB)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Info: Updated March 16, 2026.


ROUTINE troubleshooting notes

These notes are for checking or changing the active ROUTINE in the Manual Procedures workflow.

Normal workflow

  1. Log in.
  2. Open Approved manuals.
  3. Note the ROUTINE shown at the top of the page.
  4. Open ROUTINE tags.

To activate or roll back to an existing ROUTINE

Use the top ROUTINE field.

Enter the exact existing ROUTINE value you want to use, for example:

ROUTINE_4.110

Then click Activate tag.

This can be used to:

  • activate the current working ROUTINE
  • return to a previous ROUTINE
  • confirm that an existing ROUTINE bundle still works

Do not use Clone ROUTINE release for rollback.

To create the next ROUTINE

First make sure the current ROUTINE is correct in the top ROUTINE field. If needed, enter the current ROUTINE there and click Activate tag first.

Then use Clone ROUTINE release.

Enter:

  • Source ROUTINE: the current active release, for example ROUTINE_4.110
  • New ROUTINE: the new release, for example ROUTINE_4.111

Then submit the form.

This should:

  • create the new ROUTINE tag
  • copy the current bundle into the new ROUTINE
  • activate the new ROUTINE automatically

What to check immediately after

After activating or cloning:

  1. Stay on the page and note the message shown at the top.
  2. Open Approved manuals again.
  3. Confirm whether the ROUTINE heading changed.
  4. Confirm whether the manual list changed as expected.

Important

  • Activate tag uses an existing ROUTINE.
  • Clone ROUTINE release creates a new ROUTINE from an existing one.
  • Rollback means activating an existing ROUTINE in the top field.
  • Enter the ROUTINE exactly as written, for example ROUTINE_4.110.
  • Changing approved document revisions does not by itself create a new ROUTINE label.
  • A new ROUTINE appears only after it is cloned or otherwise created in the ROUTINE tables.

Emergency fallback test in LocalSettings.php

Use this only if the normal ROUTINE activation path is not working and you need to test whether the wiki is falling back to configuration.

Method 1: Change the fallback ROUTINE in LocalSettings.php

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?

Method 3: See documentation

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.

---

DEBUG STEPS

In a nutshell

  • What ROUTINE is showing on Approved manuals?
  • What ROUTINE tag displays on the ROUTINE tags page?
  • What exact message appeared after clicking the button?

Tech Fixes

Please let me know if this is fixed or if you need another step. Based on what's happening, I can probably help :)


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

See procedure for rollback to reset to a previous version. Set tag ONLY.

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 first run of 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.