I spoke too soon...(2) is patently false. I imagine there's a bug in detecting if tables.sql should be used vs. doing the updaters.
-Chad On Fri, Sep 1, 2017 at 10:04 AM Chad <[email protected]> wrote: > 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 <[email protected]> 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 >> > _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
