Topic on Project:Support desk

MediaWiki 1.32.0-RC0 fails with MSSQL

6
132.170.216.182 (talkcontribs)

Windows 2008 R2 IIS 7.5

MS-SQL 2012

MediaWiki 1.32.0-RC0 (11-09-2018)

I had tried 1.31.1 but from reading found it doesn't support MS-SQL at all because of issues with it and it was being fixed in 1.32.0 release. Looking in GIT I saw most of those issues resolved. When I first try to install there's an error on table creation, it looks like a comma was left out of the tables.sql file.

maintenance\mssql\tables.sql line 1044

rc_patrolled tinyint NOT NULL CONSTRAINT DF_rc_patrolled DEFAULT 0

I added the comma to the end in that file and started the entire process over after deleting and remaking a blank DB. After fixing that though it installs the DB and moves on but errors after that.

Install

Setting up database... 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.

Malyacko (talkcontribs)
Brentil (talkcontribs)
Brentil (talkcontribs)

I enabled full error capability in the php.ini as because this is a new install there is no LocalSettings.php yet. There are no errors being dropped just a notice.

PHP Notice:  Undefined index: UseWindowsAuth in \includes\libs\rdbms\database\DatabaseMssql.php on line 75

I went hunting from through the code and found that "Could not create a new page. It already exists." is for when error edit-already-exists is called. Which appears to be related to storage to the pages table. I went into the DB looking for what might already exist that is causing it problems. I found this in the pages table. The page_id 0 is created by the tables.sql file on line 183-184 so the page_id 1 must then be created by the code and then something is colliding.

page_id page_namespace page_title page_restrictions page_is_redirect page_is_new page_random page_touched page_links_updated page_latest page_len page_content_model page_lang
0 -1 0 0 0.7088203 NULL 0 0 NULL NULL
1 0 Main_Page 0 1 0.5898378 2.01811E+13 NULL 0 0 NULL NULL
Brentil (talkcontribs)

I started over with MediaWiki 1.32.0 stable release which has the MS-SQL fix in it. I still get the same error the the Install step of installation. I've enabled debugging and I don't believe this is an error in written code but a collision of the default page being created maybe during DB creation which then breaks during installation process as it thinks the page already exists and fails which also prevents me from moving on.


Creating administrator user account... done

Creating main page with default content... failed

Could not create a new page. It already exists.

ThirdStarr (talkcontribs)

Has there been any updated information regarding this issue? I have MediaWiki 1.32.0 stable release also and still getting the same error:


Install

  • Setting up database... 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
  • Could not create a new page. It already exists.
Reply to "MediaWiki 1.32.0-RC0 fails with MSSQL"