Jump to content

Topic on Manual talk:Upgrading

Upgrade from 1.42.1 to 1.42.2

5
RuWid (talkcontribs)

I have tried to upgrade the MediaWiki installation on wikigenialogie.ch to version 1.42.2. When updating the 'genwiki' database, the update was cancelled with the following error message:

An error occurred:

Error 1044: Access denied for user 'genwiki'@'localhost' to database 'virtual'

Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain

Query: USE `virtual`

My hoster says, «Unfortunately we cannot offer you support for MediaWiki updates. We cannot do anything with the error message.»

This is the first time I've tried to upgrade in the production environment. The upgrade in the local installation on my PC worked straight away.

I am grateful for any useful information from the community that helps to solve the problem.

Installed software

Software Version
MediaWiki 1.42.1
PHP 8.2.20 (fpm-fcgi)
ICU 50.2
MariaDB 10.6.18-MariaDB
MarkAHershberger (talkcontribs)

Turn on debug logging for your upgrade. As a first step, I would add the following to the end of your LocalSettings.php:

$wgDebugDumpSql = true;
$wgDebugLogGroups['rdbms'] = "/tmp/sql.log";

When the upgrade fails, post the last few lines from the /tmp/sql.log file here.

RuWid (talkcontribs)

I added the two lines to the end of my LocalSettings.php. The folder 'tmp' remained empty. Instead of the 'sql.log' I insert the last lines from the output window.


...site_type key doesn't exist.

...iwl_prefix_from_title key doesn't exist.

...video table already exists.

...oldvideo table already exists.

...abuse_filter table already exists.

...index afl_ip_timestamp already set on abuse_filter_log table.

...index afl_wiki_timestamp already set on abuse_filter_log table.

...skipping: index filter_timestamp doesn't exist.

...abuse_filter_log table does not contain afl_filter field.

...have af_actor field in abuse_filter table.

...have afh_actor field in abuse_filter_history table.

An error occurred:

Error 1044: Access denied for user 'genwiki'@'localhost' to database 'virtual'

Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain

Query: USE `virtual`

Ciencia Al Poder (talkcontribs)

Does the word "virtual" appear anywhere in your LocalSettings.php?

138.248.59.99 (talkcontribs)

No 'virtual' does not appear in LocalSettings.php.

Reply to "Upgrade from 1.42.1 to 1.42.2"