Manual:resetPageRandom.php

MediaWiki file: resetPageRandom.php
Location:	maintenance/
Source code:	master • 1.42.3 • 1.41.4 • 1.39.10
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	Default value
--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/resetPageRandom.php --from fromDate --to toDate [ --dry | --batch-start ]

Dry run to test

Terminal

$ php maintenance/resetPageRandom.php --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

Terminal

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

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

See also

• Manual:MakeTestEdits.php
• Manual:ResetUserEmail.php
• Manual:ResetUserTokens.php