Page MenuHomePhabricator

MediaWiki fresh install fails on Creating main page with default content during install: "Could not create a new page. It already exists."
Closed, DeclinedPublic

Description

Windows 2008 R2 IIS 7.5
MS-SQL 2012
PHP 7.1.26
MediaWiki 1.32.0 (stable)

Environmental checks

PHP 7.1.26 is installed.
Warning: Could not find APCu or WinCache.
Object caching is not enabled.
GNU diff3 not found.
Could not find GD library or ImageMagick.
Image thumbnailing will be disabled.
Git version control software not found.
Using server name "https://myurl.com".
Using server URL "https://myurl.com".
Using the intl PECL extension for Unicode normalization.

The environment has been checked. You can install MediaWiki.

When we try to install MediaWiki as a fresh installation it now makes it past the DB issues previous reported and fixed in 1.32.0 stable but when it tries to do the data installation portion it fails stating it can't creating main page with default content because it already exists. I've filled out the information for DB and account info up to the "Ask me more questions" page and go on to it and only change the return email address on that page and then click install. I was getting this same issue with the 1.32.0-RC series as well. I've blown away this install and repeated it several times and come to the same error each time.

I've gone through the Manual:How_to_debug page and enabled everything I can that does not require the LocalSettings.php settings since I don't have a LocalSettings.php file yet as the install has not completed. The one notice below in the process is the only output being dropped during the process, no other errors.

Install
Setting up database...
Notice: Undefined index: UseWindowsAuth in D:\clients\MSGuideBook\www\includes\libs\rdbms\database\DatabaseMssql.php on line 75
done
Creating tables... done
Creating database user... done
Populating default interwiki table... done
Initializing statistics... done
Generating secret keys... done
Prevent running unneeded updates... done
Creating administrator user account... done
Creating main page with default content... failed
Information
Could not create a new page. It already exists.

Event Timeline

Aklapper renamed this task from MediaWiki fresh install fails on Creating main page with default content during install to MediaWiki fresh install fails on Creating main page with default content during install: "Could not create a new page. It already exists.".Jan 17 2019, 4:01 PM

For validation I setup a MySQL 8.0.14 server and used the same website & install media and even used the same username/password for connecting to MySQL and it installs without issue to that system. I wanted to verify the install media, our server config, and username/password were not causing problems and they apparently do not so it does appear to be something specific to the MS-SQL installation.

Another instance of this error on 1.32: Topic:Uvchvjq4moxr5prh

The patch provided by Kevin71246 in that thread did allow us to finally install a fresh installation on an MSSQL server using MediaWiki 1.32.1.

Heads-up: As per RFC discussion in August 2019, the previously experimental support for using Oracle or MSSQL as database backends in MediaWiki core has been removed in MediaWiki 1.34, so this task might end up as declined in the future.