Manual:resetPageRandom.php

Translate this page

MediaWiki file: resetPageRandom.php
Location:	maintenance/
Source code:	master • 1.43.0 • 1.42.4 • 1.39.11
Classes:	ResetPageRandom

Details

resetPageRandom.php maintenance script resets the page_random field for articles in the provided time range. The page_random field in the page table is responsible for returning random pages. This is useful when you want to refresh your random article sequence.

Options

Option		Required
--from	From date range selector to select articles to update, ex: 20041011000000	Required
--to	To date range selector to select articles to update, ex: 20050708000000	Required
--dry	Do not update column. Just do dry run.	Optional
--batch-start	Use when you need to restart the reset process from a given page ID offset in case a previous reset failed or was stopped	Optional

Usage

php maintenance/run.php resetPageRandom --from fromDate --to toDate [ --dry | --batch-start ]

In MediaWiki version 1.39.10 and earlier, you must invoke maintenance scripts using php maintenance/scriptName.php instead of php maintenance/run.php scriptName.

Dry run to test

Terminal

$ php maintenance/run.php resetPageRandom --from 20210901000000 --to 20211018000000 --dry

Resetting page_random column within date range from 20210901000000 to 20211018000000. dry run
  ...doing chunk of 200 from 0
  ...doing chunk of 200 from 207
page_random reset complete ... changed 206 rows

Actual run to update the column