Issues (4122)

Security Analysis    not enabled

This project does not seem to handle request data directly as such no vulnerable execution paths were found.

  Cross-Site Scripting
Cross-Site Scripting enables an attacker to inject code into the response of a web-request that is viewed by other users. It can for example be used to bypass access controls, or even to take over other users' accounts.
  File Exposure
File Exposure allows an attacker to gain access to local files that he should not be able to access. These files can for example include database credentials, or other configuration files.
  File Manipulation
File Manipulation enables an attacker to write custom data to files. This potentially leads to injection of arbitrary code on the server.
  Object Injection
Object Injection enables an attacker to inject an object into PHP code, and can lead to arbitrary code execution, file exposure, or file manipulation attacks.
  Code Injection
Code Injection enables an attacker to execute arbitrary code on the server.
  Response Splitting
Response Splitting can be used to send arbitrary responses.
  File Inclusion
File Inclusion enables an attacker to inject custom files into PHP's file loading mechanism, either explicitly passed to include, or for example via PHP's auto-loading mechanism.
  Command Injection
Command Injection enables an attacker to inject a shell command that is execute with the privileges of the web-server. This can be used to expose sensitive data, or gain access of your server.
  SQL Injection
SQL Injection enables an attacker to execute arbitrary SQL code on your database server gaining access to user data, or manipulating user data.
  XPath Injection
XPath Injection enables an attacker to modify the parts of XML document that are read. If that XML document is for example used for authentication, this can lead to further vulnerabilities similar to SQL Injection.
  LDAP Injection
LDAP Injection enables an attacker to inject LDAP statements potentially granting permission to run unauthorized queries, or modify content inside the LDAP tree.
  Header Injection
  Other Vulnerability
This category comprises other attack vectors such as manipulating the PHP runtime, loading custom extensions, freezing the runtime, or similar.
  Regex Injection
Regex Injection enables an attacker to execute arbitrary code in your PHP process.
  XML Injection
XML Injection enables an attacker to read files on your local filesystem including configuration files, or can be abused to freeze your web-server process.
  Variable Injection
Variable Injection enables an attacker to overwrite program variables with custom data, and can lead to further vulnerabilities.
Unfortunately, the security analysis is currently not available for your project. If you are a non-commercial open-source project, please contact support to gain access.

maintenance/populateRevisionSha1.php (9 issues)

Upgrade to new PHP Analysis Engine

These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more

1
<?php
0 ignored issues
show
Coding Style Compatibility introduced by
For compatibility and reusability of your code, PSR1 recommends that a file should introduce either new symbols (like classes, functions, etc.) or have side-effects (like outputting something, or including other files), but not both at the same time. The first symbol is defined on line 33 and the first side effect is on line 25.

The PSR-1: Basic Coding Standard recommends that a file should either introduce new symbols, that is classes, functions, constants or similar, or have side effects. Side effects are anything that executes logic, like for example printing output, changing ini settings or writing to a file.

The idea behind this recommendation is that merely auto-loading a class should not change the state of an application. It also promotes a cleaner style of programming and makes your code less prone to errors, because the logic is not spread out all over the place.

To learn more about the PSR-1, please see the PHP-FIG site on the PSR-1.

Loading history...
2
/**
3
 * Fills the rev_sha1 and ar_sha1 columns of revision
4
 * and archive tables for revisions created before MW 1.19.
5
 *
6
 * This program is free software; you can redistribute it and/or modify
7
 * it under the terms of the GNU General Public License as published by
8
 * the Free Software Foundation; either version 2 of the License, or
9
 * (at your option) any later version.
10
 *
11
 * This program is distributed in the hope that it will be useful,
12
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14
 * GNU General Public License for more details.
15
 *
16
 * You should have received a copy of the GNU General Public License along
17
 * with this program; if not, write to the Free Software Foundation, Inc.,
18
 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
19
 * http://www.gnu.org/copyleft/gpl.html
20
 *
21
 * @file
22
 * @ingroup Maintenance
23
 */
24
25
require_once __DIR__ . '/Maintenance.php';
26
27
/**
28
 * Maintenance script that fills the rev_sha1 and ar_sha1 columns of revision
29
 * and archive tables for revisions created before MW 1.19.
30
 *
31
 * @ingroup Maintenance
32
 */
33
class PopulateRevisionSha1 extends LoggedUpdateMaintenance {
34
	public function __construct() {
35
		parent::__construct();
36
		$this->addDescription( 'Populates the rev_sha1 and ar_sha1 fields' );
37
		$this->setBatchSize( 200 );
38
	}
39
40
	protected function getUpdateKey() {
41
		return 'populate rev_sha1';
42
	}
43
44
	protected function doDBUpdates() {
45
		$db = $this->getDB( DB_MASTER );
46
47 View Code Duplication
		if ( !$db->tableExists( 'revision' ) ) {
48
			$this->error( "revision table does not exist", true );
49
		} elseif ( !$db->tableExists( 'archive' ) ) {
50
			$this->error( "archive table does not exist", true );
51
		} elseif ( !$db->fieldExists( 'revision', 'rev_sha1', __METHOD__ ) ) {
52
			$this->output( "rev_sha1 column does not exist\n\n", true );
53
54
			return false;
55
		}
56
57
		$this->output( "Populating rev_sha1 column\n" );
58
		$rc = $this->doSha1Updates( 'revision', 'rev_id', 'rev' );
59
60
		$this->output( "Populating ar_sha1 column\n" );
61
		$ac = $this->doSha1Updates( 'archive', 'ar_rev_id', 'ar' );
62
		$this->output( "Populating ar_sha1 column legacy rows\n" );
63
		$ac += $this->doSha1LegacyUpdates();
64
65
		$this->output( "rev_sha1 and ar_sha1 population complete "
66
			. "[$rc revision rows, $ac archive rows].\n" );
67
68
		return true;
69
	}
70
71
	/**
72
	 * @param string $table
73
	 * @param string $idCol
74
	 * @param string $prefix
75
	 * @return int Rows changed
76
	 */
77
	protected function doSha1Updates( $table, $idCol, $prefix ) {
78
		$db = $this->getDB( DB_MASTER );
79
		$start = $db->selectField( $table, "MIN($idCol)", false, __METHOD__ );
80
		$end = $db->selectField( $table, "MAX($idCol)", false, __METHOD__ );
81
		if ( !$start || !$end ) {
82
			$this->output( "...$table table seems to be empty.\n" );
83
84
			return 0;
85
		}
86
87
		$count = 0;
88
		# Do remaining chunk
89
		$end += $this->mBatchSize - 1;
90
		$blockStart = $start;
91
		$blockEnd = $start + $this->mBatchSize - 1;
92
		while ( $blockEnd <= $end ) {
93
			$this->output( "...doing $idCol from $blockStart to $blockEnd\n" );
94
			$cond = "$idCol BETWEEN $blockStart AND $blockEnd
95
				AND $idCol IS NOT NULL AND {$prefix}_sha1 = ''";
96
			$res = $db->select( $table, '*', $cond, __METHOD__ );
97
98
			$this->beginTransaction( $db, __METHOD__ );
0 ignored issues
show
It seems like $db defined by $this->getDB(DB_MASTER) on line 78 can be null; however, Maintenance::beginTransaction() does not accept null, maybe add an additional type check?

Unless you are absolutely sure that the expression can never be null because of other conditions, we strongly recommend to add an additional type check to your code:

/** @return stdClass|null */
function mayReturnNull() { }

function doesNotAcceptNull(stdClass $x) { }

// With potential error.
function withoutCheck() {
    $x = mayReturnNull();
    doesNotAcceptNull($x); // Potential error here.
}

// Safe - Alternative 1
function withCheck1() {
    $x = mayReturnNull();
    if ( ! $x instanceof stdClass) {
        throw new \LogicException('$x must be defined.');
    }
    doesNotAcceptNull($x);
}

// Safe - Alternative 2
function withCheck2() {
    $x = mayReturnNull();
    if ($x instanceof stdClass) {
        doesNotAcceptNull($x);
    }
}
Loading history...
99
			foreach ( $res as $row ) {
100
				if ( $this->upgradeRow( $row, $table, $idCol, $prefix ) ) {
101
					$count++;
102
				}
103
			}
104
			$this->commitTransaction( $db, __METHOD__ );
0 ignored issues
show
It seems like $db defined by $this->getDB(DB_MASTER) on line 78 can be null; however, Maintenance::commitTransaction() does not accept null, maybe add an additional type check?

Unless you are absolutely sure that the expression can never be null because of other conditions, we strongly recommend to add an additional type check to your code:

/** @return stdClass|null */
function mayReturnNull() { }

function doesNotAcceptNull(stdClass $x) { }

// With potential error.
function withoutCheck() {
    $x = mayReturnNull();
    doesNotAcceptNull($x); // Potential error here.
}

// Safe - Alternative 1
function withCheck1() {
    $x = mayReturnNull();
    if ( ! $x instanceof stdClass) {
        throw new \LogicException('$x must be defined.');
    }
    doesNotAcceptNull($x);
}

// Safe - Alternative 2
function withCheck2() {
    $x = mayReturnNull();
    if ($x instanceof stdClass) {
        doesNotAcceptNull($x);
    }
}
Loading history...
105
106
			$blockStart += $this->mBatchSize;
107
			$blockEnd += $this->mBatchSize;
108
			wfWaitForSlaves();
0 ignored issues
show
Deprecated Code introduced by
The function wfWaitForSlaves() has been deprecated with message: since 1.27 Use LBFactory::waitForReplication

This function has been deprecated. The supplier of the file has supplied an explanatory message.

The explanatory message should give you some clue as to whether and when the function will be removed from the class and what other function to use instead.

Loading history...
109
		}
110
111
		return $count;
112
	}
113
114
	/**
115
	 * @return int
116
	 */
117
	protected function doSha1LegacyUpdates() {
118
		$count = 0;
119
		$db = $this->getDB( DB_MASTER );
120
		$res = $db->select( 'archive', '*',
121
			[ 'ar_rev_id IS NULL', 'ar_sha1' => '' ], __METHOD__ );
122
123
		$updateSize = 0;
124
		$this->beginTransaction( $db, __METHOD__ );
0 ignored issues
show
It seems like $db defined by $this->getDB(DB_MASTER) on line 119 can be null; however, Maintenance::beginTransaction() does not accept null, maybe add an additional type check?

Unless you are absolutely sure that the expression can never be null because of other conditions, we strongly recommend to add an additional type check to your code:

/** @return stdClass|null */
function mayReturnNull() { }

function doesNotAcceptNull(stdClass $x) { }

// With potential error.
function withoutCheck() {
    $x = mayReturnNull();
    doesNotAcceptNull($x); // Potential error here.
}

// Safe - Alternative 1
function withCheck1() {
    $x = mayReturnNull();
    if ( ! $x instanceof stdClass) {
        throw new \LogicException('$x must be defined.');
    }
    doesNotAcceptNull($x);
}

// Safe - Alternative 2
function withCheck2() {
    $x = mayReturnNull();
    if ($x instanceof stdClass) {
        doesNotAcceptNull($x);
    }
}
Loading history...
125
		foreach ( $res as $row ) {
126
			if ( $this->upgradeLegacyArchiveRow( $row ) ) {
127
				++$count;
128
			}
129
			if ( ++$updateSize >= 100 ) {
130
				$updateSize = 0;
131
				$this->commitTransaction( $db, __METHOD__ );
0 ignored issues
show
It seems like $db defined by $this->getDB(DB_MASTER) on line 119 can be null; however, Maintenance::commitTransaction() does not accept null, maybe add an additional type check?

Unless you are absolutely sure that the expression can never be null because of other conditions, we strongly recommend to add an additional type check to your code:

/** @return stdClass|null */
function mayReturnNull() { }

function doesNotAcceptNull(stdClass $x) { }

// With potential error.
function withoutCheck() {
    $x = mayReturnNull();
    doesNotAcceptNull($x); // Potential error here.
}

// Safe - Alternative 1
function withCheck1() {
    $x = mayReturnNull();
    if ( ! $x instanceof stdClass) {
        throw new \LogicException('$x must be defined.');
    }
    doesNotAcceptNull($x);
}

// Safe - Alternative 2
function withCheck2() {
    $x = mayReturnNull();
    if ($x instanceof stdClass) {
        doesNotAcceptNull($x);
    }
}
Loading history...
132
				$this->output( "Commited row with ar_timestamp={$row->ar_timestamp}\n" );
133
				wfWaitForSlaves();
0 ignored issues
show
Deprecated Code introduced by
The function wfWaitForSlaves() has been deprecated with message: since 1.27 Use LBFactory::waitForReplication

This function has been deprecated. The supplier of the file has supplied an explanatory message.

The explanatory message should give you some clue as to whether and when the function will be removed from the class and what other function to use instead.

Loading history...
134
				$this->beginTransaction( $db, __METHOD__ );
0 ignored issues
show
It seems like $db defined by $this->getDB(DB_MASTER) on line 119 can be null; however, Maintenance::beginTransaction() does not accept null, maybe add an additional type check?

Unless you are absolutely sure that the expression can never be null because of other conditions, we strongly recommend to add an additional type check to your code:

/** @return stdClass|null */
function mayReturnNull() { }

function doesNotAcceptNull(stdClass $x) { }

// With potential error.
function withoutCheck() {
    $x = mayReturnNull();
    doesNotAcceptNull($x); // Potential error here.
}

// Safe - Alternative 1
function withCheck1() {
    $x = mayReturnNull();
    if ( ! $x instanceof stdClass) {
        throw new \LogicException('$x must be defined.');
    }
    doesNotAcceptNull($x);
}

// Safe - Alternative 2
function withCheck2() {
    $x = mayReturnNull();
    if ($x instanceof stdClass) {
        doesNotAcceptNull($x);
    }
}
Loading history...
135
			}
136
		}
137
		$this->commitTransaction( $db, __METHOD__ );
0 ignored issues
show
It seems like $db defined by $this->getDB(DB_MASTER) on line 119 can be null; however, Maintenance::commitTransaction() does not accept null, maybe add an additional type check?

Unless you are absolutely sure that the expression can never be null because of other conditions, we strongly recommend to add an additional type check to your code:

/** @return stdClass|null */
function mayReturnNull() { }

function doesNotAcceptNull(stdClass $x) { }

// With potential error.
function withoutCheck() {
    $x = mayReturnNull();
    doesNotAcceptNull($x); // Potential error here.
}

// Safe - Alternative 1
function withCheck1() {
    $x = mayReturnNull();
    if ( ! $x instanceof stdClass) {
        throw new \LogicException('$x must be defined.');
    }
    doesNotAcceptNull($x);
}

// Safe - Alternative 2
function withCheck2() {
    $x = mayReturnNull();
    if ($x instanceof stdClass) {
        doesNotAcceptNull($x);
    }
}
Loading history...
138
139
		return $count;
140
	}
141
142
	/**
143
	 * @param stdClass $row
144
	 * @param string $table
145
	 * @param string $idCol
146
	 * @param string $prefix
147
	 * @return bool
148
	 */
149
	protected function upgradeRow( $row, $table, $idCol, $prefix ) {
150
		$db = $this->getDB( DB_MASTER );
151
		try {
152
			$rev = ( $table === 'archive' )
153
				? Revision::newFromArchiveRow( $row )
154
				: new Revision( $row );
155
			$text = $rev->getSerializedData();
156
		} catch ( Exception $e ) {
157
			$this->output( "Data of revision with {$idCol}={$row->$idCol} unavailable!\n" );
158
159
			return false; // bug 22624?
160
		}
161
		if ( !is_string( $text ) ) {
162
			# This should not happen, but sometimes does (bug 20757)
163
			$this->output( "Data of revision with {$idCol}={$row->$idCol} unavailable!\n" );
164
165
			return false;
166
		} else {
167
			$db->update( $table,
168
				[ "{$prefix}_sha1" => Revision::base36Sha1( $text ) ],
169
				[ $idCol => $row->$idCol ],
170
				__METHOD__
171
			);
172
173
			return true;
174
		}
175
	}
176
177
	/**
178
	 * @param stdClass $row
179
	 * @return bool
180
	 */
181
	protected function upgradeLegacyArchiveRow( $row ) {
182
		$db = $this->getDB( DB_MASTER );
183
		try {
184
			$rev = Revision::newFromArchiveRow( $row );
185
		} catch ( Exception $e ) {
186
			$this->output( "Text of revision with timestamp {$row->ar_timestamp} unavailable!\n" );
187
188
			return false; // bug 22624?
189
		}
190
		$text = $rev->getSerializedData();
191
		if ( !is_string( $text ) ) {
192
			# This should not happen, but sometimes does (bug 20757)
193
			$this->output( "Data of revision with timestamp {$row->ar_timestamp} unavailable!\n" );
194
195
			return false;
196
		} else {
197
			# Archive table as no PK, but (NS,title,time) should be near unique.
198
			# Any duplicates on those should also have duplicated text anyway.
199
			$db->update( 'archive',
200
				[ 'ar_sha1' => Revision::base36Sha1( $text ) ],
201
				[
202
					'ar_namespace' => $row->ar_namespace,
203
					'ar_title' => $row->ar_title,
204
					'ar_timestamp' => $row->ar_timestamp,
205
					'ar_len' => $row->ar_len // extra sanity
206
				],
207
				__METHOD__
208
			);
209
210
			return true;
211
		}
212
	}
213
}
214
215
$maintClass = "PopulateRevisionSha1";
216
require_once RUN_MAINTENANCE_IF_MAIN;
217