Editing Manual/Upgrading (section)

=== Command line === <!--T:84-->
</translate>
<translate><!--T:594--> Access the command line of your server or an SSH shell or similar. You can access the command line by connecting to your server via SSH.</translate>
<translate><!--T:600--> Current versions of all major operating systems (including Windows 10 and 11) contain a command-line [[w:OpenSSH|OpenSSH]] client either by default or as an installable feature.</translate>
<translate><!--T:601--> If the local PC you are working on runs Microsoft Windows, you may want to (or, if it's 8.1 or older, have to) install <tvar name=putty>[https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html PuTTY]</tvar>, which features a wizard-like interface (or a similar tool).</translate>
<translate><!--T:602--> From the command line or the Shell, execute the [[<tvar name=script>Special:MyLanguage/Manual:update.php</tvar>|update script]]:</translate>


 $ php maintenance/run.php update


 $ php maintenance/update.php

<translate><!--T:86--> On a Linux server if you get an error, try performing the same command as root (by using the <tvar name=1><kbd>sudo</kbd></tvar> command).</translate>
<translate><!--T:214--> Note for simple installations on Windows (e.g. with <tvar name=xampp></tvar>):</translate>
<translate><!--T:215--> First make sure that your web server (such as Apache) and your database (such as MySQL) are running.</translate>
<translate><!--T:216--> Then run <tvar name=1><code>update.php</code></tvar>: right-click it, select Open With, and browse to <tvar name=2>PHP.exe</tvar>.</translate>
<translate><!--T:217--> The resulting command prompt window will likely autoclose when the schema upgrade completes.</translate>

<translate>
<!--T:88-->
MediaWiki will inspect the existing schema and update it to work with the new code, adding tables and columns as needed.</translate>

{{Note|1=<translate><!--T:150--> If you use a [[<tvar name=shared-db>Special:MyLanguage/Manual:Shared database</tvar>|Shared database]], you should pass the <tvar name=doshared><code>--doshared</code></tvar> parameter if you want the shared tables to be updated. Otherwise, they won't be touched by the update script.</translate>}}

<translate>
==== What to do if it says "MediaWiki requires PHP x.y.z or higher; you are using PHP x.w.v" ==== <!--T:606-->

<!--T:607-->
See {{<tvar name=1>ll|Manual:Common errors and symptoms#MediaWiki requires PHP 7.4.3 or higher; you are using PHP 7.3.17</tvar>|Manual:Common errors and symptoms#MediaWiki requires PHP 7.4.3 or higher; you are using PHP 7.3.17}}

==== What to do if php update.php fails to do anything, resulting in a quick pause and then return to command prompt ==== <!--T:219-->

<!--T:220-->
This can be caused by a malfunctioning extension or skin.

<!--T:221-->
* Check that all extensions and skins called for in <tvar name=1>LocalSettings.php</tvar> are present</translate>
<translate>
<!--T:222-->
* Check that extensions are using the correct registration method (<tvar name=1>wfLoadExtension</tvar> vs. <tvar name=2>require_once</tvar>)</translate>
<translate>
<!--T:556-->
* Comment out the first half of the extensions in <tvar name=1>LocalSettings.php</tvar>.</translate> <translate><!--T:557--> If this causes <tvar name=1>update.php</tvar> to work, uncomment half of that half (so 1/4 of the extensions).</translate> <translate><!--T:558--> If this does NOT cause <tvar name=1>update.php</tvar> to work, uncomment the first half but comment out the second half, and then comment out half of the second half, etc.</translate> <translate><!--T:223--> Repeat until <tvar name=1>update.php</tvar> works to find the one that is failing.</translate>

<translate>
==== What to do in case of "ALTER command denied to user" error (or similar) ==== <!--T:89-->

<!--T:90-->
In case the scripts abort with a message similar to:
</translate>

<pre>
Error: 1142 ALTER command denied to user 'wiki'@'localhost' for table 'mytable' (localhost)
ERROR: must be the owner of the mytable relation 
</pre>

<translate>
<!--T:91-->
This means that you should check that you have defined <tvar name=1></tvar> and <tvar name=2></tvar> in your <tvar name=3></tvar> file (in the main directory). These are the user and password needed by this script in order to access to the database.
</translate>

<translate><!--T:200--> In some cases, an old $wgDBmwschema variable (for Postgres) seems to be read for the table name to update instead of $wgDBname, even when MySQL is used.</translate>
<translate><!--T:598--> If this is the case, just get rid of the <tvar name=1><code>$wgDBmwschema</code></tvar> definition in <tvar name=2><code>LocalSettings.php</code></tvar>.</translate>

<translate>
====What to do in case of 'register_argc_argv is set to false' error==== <!--T:100-->

<!--T:101-->
You may encounter the error:
</translate>

<pre style="overflow:auto;">
Cannot get command line arguments, register_argc_argv is set to false
</pre>

# <translate><!--T:102--> Go to <tvar name=1>~/maintenance</tvar>.</translate> <translate><!--T:613--> Either edit an existing <tvar name=2>php.ini</tvar> file, or create one.</translate>
# <translate><!--T:103--> Add a line as follows:</translate>

<pre style="overflow:auto;">
register_argc_argv=true
</pre>

# <translate><!--T:104--> Re-run <tvar name=1><code>php update.php</code></tvar></translate>


<translate>