Two things here:
1) The installer gives you a chance to change these settings on upgrade.
Not all should be changeable though I suppose--there's no real way to
differentiate though...maybe an upgrade shouldn't allow changing them at
all...
2) That sounds like the postgres installer should wrap its table creations
with something like IF NOT EXISTS.
Neither are really specific to 1.27.3--or Postgres for that matter, beyond
the bug probably only being in its schema. Basically MediaWiki from 1.17.0
and beyond (new installer) would have this issue.
-Chad
On Fri, Sep 1, 2017 at 7:30 AM Victor Sudakov <vas(a)mpeks.tomsk.su> wrote:
Dear Colleagues,
I'm trying to upgrade my Wiki to MediaWiki 1.27.3 (FreeBSD 10.3,
PostgreSQL 9.2).
The wiki/mw-config script correctly finds the existing
LocalSettings.php, I enter the upgrade key, then it says "The
environment has been checked. You can install MediaWiki."
On the next page I check "Use the same account as for installation"
On the next page, the installer asks me to enter "Name of wiki",
"Project namespace", administrator username/password etc. Why? I'm
upgrading, not installing from scratch. Everything's already there in
LocalSettings.php!
Never mind, I enter all this anew. On the next step: a database error.
Please see the traceback below.
It looks like the installer is trying to create a new wiki instead of
upgrading the existing one.
Can you please help?
A database query error has occurred. This may indicate a bug in the
software.
Query:
CREATE TABLE mwuser ( -- replace reserved word 'user'
user_id INTEGER NOT NULL PRIMARY KEY DEFAULT
nextval('user_user_id_seq'),
user_name TEXT NOT NULL UNIQUE,
user_real_name TEXT,
user_password TEXT,
user_newpassword TEXT,
user_newpass_time TIMESTAMPTZ,
user_token TEXT,
user_email TEXT,
user_email_token TEXT,
user_email_token_expires TIMESTAMPTZ,
user_email_authenticated TIMESTAMPTZ,
user_touched TIMESTAMPTZ,
user_registration TIMESTAMPTZ,
user_editcount INTEGER,
user_password_expires TIMESTAMPTZ NULL
)
Function: DatabaseBase::sourceFile(
/usr/local/www/mediawiki/maintenance/postgres/tables.sql )
Error: 42P07 ERROR: relation "mwuser" already exists
Backtrace:
#0 /usr/local/www/mediawiki/includes/db/DatabasePostgres.php(448):
DatabaseBase->reportQueryError('ERROR: relatio...', '42P07',
'CREATE TABLE
mw...', 'DatabaseBase::s...', false)
#1 /usr/local/www/mediawiki/includes/db/Database.php(901):
DatabasePostgres->reportQueryError('ERROR: relatio...', '42P07',
'CREATE
TABLE mw...', 'DatabaseBase::s...', false)
#2 /usr/local/www/mediawiki/includes/db/Database.php(3057):
DatabaseBase->query('CREATE TABLE mw...', 'DatabaseBase::s...')
#3 /usr/local/www/mediawiki/includes/db/Database.php(2978):
DatabaseBase->sourceStream(Resource id #51, false, false,
'DatabaseBase::s...', false)
#4
/usr/local/www/mediawiki/includes/installer/PostgresInstaller.php(609):
DatabaseBase->sourceFile('/usr/local/www/...')
#5 [internal function]:
PostgresInstaller->createTables(Object(PostgresInstaller))
#6 /usr/local/www/mediawiki/includes/installer/Installer.php(1476):
call_user_func(Array, Object(PostgresInstaller))
#7
/usr/local/www/mediawiki/includes/installer/WebInstallerInstall.php(45):
Installer->performInstallation(Array, Array)
#8 /usr/local/www/mediawiki/includes/installer/WebInstaller.php(279):
WebInstallerInstall->execute()
#9 /usr/local/www/mediawiki/mw-config/index.php(81):
WebInstaller->execute(Array)
#10 /usr/local/www/mediawiki/mw-config/index.php(39): wfInstallerMain()
#11 {main}
--
Victor Sudakov, VAS4-RIPE, VAS47-RIPN
AS43859
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l