Manual:resetPageRandom.php

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

MediaWiki file: resetPageRandom.php
Location:	maintenance/
Source code:	master • 1.41.1 • 1.40.3 • 1.39.7
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	<translate> Required</translate>
--to	To date range selector to select articles to update, ex: 20050708000000	<translate> Required</translate>
--dry	Do not update column. Just do dry run.	<translate> Optional</translate>
--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	<translate> Optional</translate>

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