Page MenuHomePhabricator

MSSQLTag
ArchivedPublic

Watchers

  • This project does not have any watchers.
  • View All

Details

Description

OBSOLETE - MediaWiki's MSSQL database backend was removed in 1.34 (see T230418).

Recent Activity

Dec 22 2023

Ladsgroup removed a subtask for T191231: RFC: Abstract schemas and schema changes: T237839: Wire abstract schema and schema changes for extension.
Dec 22 2023, 3:56 PM · User-Ladsgroup, MW-1.36-notes (1.36.0-wmf.38; 2021-04-06), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.32; 2020-05-12), Platform Team Workboards (Initiatives), Platform Team Initiatives (Abstract Schema), TechCom-RFC (TechCom-RFC-Closed), MediaWiki-Installer, User-Addshore, SQLite, Oracle Database, MSSQL, PostgreSQL, Epic

Jan 12 2023

Tgr added a comment to T191231: RFC: Abstract schemas and schema changes.

Probably depends on your $wgDBTableOptions settings? Doctrine can generate a schema update command given an actual and a desired schema, but that will probably result in character conversion which is not what you want...
In any case, not really related to this task.

Jan 12 2023, 2:23 AM · User-Ladsgroup, MW-1.36-notes (1.36.0-wmf.38; 2021-04-06), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.32; 2020-05-12), Platform Team Workboards (Initiatives), Platform Team Initiatives (Abstract Schema), TechCom-RFC (TechCom-RFC-Closed), MediaWiki-Installer, User-Addshore, SQLite, Oracle Database, MSSQL, PostgreSQL, Epic

Jan 10 2023

Reedy added a comment to T191231: RFC: Abstract schemas and schema changes.

@Reedy wrote:
update.php? ;)
What version are you upgrading from?

Hah no, I wish it were that simple. I already run update.php when I upgraded from 1.35 to 1.39 and the wiki has been working ok for some weeks now. However, tracking down [https://www.mediawiki.org/wiki/Topic:X9zviki367qeczo5 this bug with DiscussionTools], I narrowed it down to a database or data issue, and noticed that many of the tables and fields were latin1_swedish_ci rather than binary (both before and after the upgrade). Should this have been fixed by some update.php? Is there some other recommended way to fix it? Thanks again!

Jan 10 2023, 2:47 PM · User-Ladsgroup, MW-1.36-notes (1.36.0-wmf.38; 2021-04-06), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.32; 2020-05-12), Platform Team Workboards (Initiatives), Platform Team Initiatives (Abstract Schema), TechCom-RFC (TechCom-RFC-Closed), MediaWiki-Installer, User-Addshore, SQLite, Oracle Database, MSSQL, PostgreSQL, Epic
Sophivorus added a comment to T191231: RFC: Abstract schemas and schema changes.

@Reedy wrote:
update.php? ;)
What version are you upgrading from?

Jan 10 2023, 2:43 PM · User-Ladsgroup, MW-1.36-notes (1.36.0-wmf.38; 2021-04-06), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.32; 2020-05-12), Platform Team Workboards (Initiatives), Platform Team Initiatives (Abstract Schema), TechCom-RFC (TechCom-RFC-Closed), MediaWiki-Installer, User-Addshore, SQLite, Oracle Database, MSSQL, PostgreSQL, Epic

Jan 9 2023

Reedy added a comment to T191231: RFC: Abstract schemas and schema changes.

Is there a maintenance script, procedure or advice to update an old database schema to the current one?

Jan 9 2023, 8:48 PM · User-Ladsgroup, MW-1.36-notes (1.36.0-wmf.38; 2021-04-06), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.32; 2020-05-12), Platform Team Workboards (Initiatives), Platform Team Initiatives (Abstract Schema), TechCom-RFC (TechCom-RFC-Closed), MediaWiki-Installer, User-Addshore, SQLite, Oracle Database, MSSQL, PostgreSQL, Epic
Sophivorus added a comment to T191231: RFC: Abstract schemas and schema changes.

Is there a maintenance script, procedure or advice to update an old database schema to the current one?

Jan 9 2023, 6:44 PM · User-Ladsgroup, MW-1.36-notes (1.36.0-wmf.38; 2021-04-06), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.32; 2020-05-12), Platform Team Workboards (Initiatives), Platform Team Initiatives (Abstract Schema), TechCom-RFC (TechCom-RFC-Closed), MediaWiki-Installer, User-Addshore, SQLite, Oracle Database, MSSQL, PostgreSQL, Epic

Jul 28 2022

gerritbot added a comment to T191231: RFC: Abstract schemas and schema changes.

Change 496421 abandoned by Ladsgroup:

[mediawiki/core@master] [POC] USe of Doctrine DBAL for oracle schema and schema changes

Reason:

Abstract schema has been long deployed \o/

https://gerrit.wikimedia.org/r/496421

Jul 28 2022, 4:53 PM · User-Ladsgroup, MW-1.36-notes (1.36.0-wmf.38; 2021-04-06), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.32; 2020-05-12), Platform Team Workboards (Initiatives), Platform Team Initiatives (Abstract Schema), TechCom-RFC (TechCom-RFC-Closed), MediaWiki-Installer, User-Addshore, SQLite, Oracle Database, MSSQL, PostgreSQL, Epic

Jul 13 2022

Jdforrester-WMF closed T261912: Convert WMF Deployed Extensions to Abstract Schema, a subtask of T191231: RFC: Abstract schemas and schema changes, as Resolved.
Jul 13 2022, 7:14 PM · User-Ladsgroup, MW-1.36-notes (1.36.0-wmf.38; 2021-04-06), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.32; 2020-05-12), Platform Team Workboards (Initiatives), Platform Team Initiatives (Abstract Schema), TechCom-RFC (TechCom-RFC-Closed), MediaWiki-Installer, User-Addshore, SQLite, Oracle Database, MSSQL, PostgreSQL, Epic
Jdforrester-WMF closed T261911: Convert Bundled Extensions to Abstract Schema, a subtask of T191231: RFC: Abstract schemas and schema changes, as Resolved.
Jul 13 2022, 5:46 PM · User-Ladsgroup, MW-1.36-notes (1.36.0-wmf.38; 2021-04-06), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.32; 2020-05-12), Platform Team Workboards (Initiatives), Platform Team Initiatives (Abstract Schema), TechCom-RFC (TechCom-RFC-Closed), MediaWiki-Installer, User-Addshore, SQLite, Oracle Database, MSSQL, PostgreSQL, Epic

May 28 2022

ReleaseTaggerBot added a project to T230418: Drop support for MSSQL and Oracle from core: MW-1.39-notes (1.39.0-wmf.14; 2022-05-30).
May 28 2022, 1:00 AM · MW-1.39-notes (1.39.0-wmf.14; 2022-05-30), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), MW-1.34-notes (1.34.0-wmf.21; 2019-09-03), Wikimania-Hackathon-2019, User-Ladsgroup, MediaWiki-Installer, Oracle Database, MSSQL
gerritbot added a comment to T230418: Drop support for MSSQL and Oracle from core.

Change 791654 merged by jenkins-bot:

[mediawiki/core@master] installer,rdbms: Remove hints to Oracle and Microsoft SQL Server

https://gerrit.wikimedia.org/r/791654

May 28 2022, 12:06 AM · MW-1.39-notes (1.39.0-wmf.14; 2022-05-30), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), MW-1.34-notes (1.34.0-wmf.21; 2019-09-03), Wikimania-Hackathon-2019, User-Ladsgroup, MediaWiki-Installer, Oracle Database, MSSQL

May 13 2022

gerritbot added a project to T230418: Drop support for MSSQL and Oracle from core: Patch-For-Review.
May 13 2022, 6:34 PM · MW-1.39-notes (1.39.0-wmf.14; 2022-05-30), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), MW-1.34-notes (1.34.0-wmf.21; 2019-09-03), Wikimania-Hackathon-2019, User-Ladsgroup, MediaWiki-Installer, Oracle Database, MSSQL
gerritbot added a comment to T230418: Drop support for MSSQL and Oracle from core.

Change 791654 had a related patch set uploaded (by Umherirrender; author: Umherirrender):

[mediawiki/core@master] Remove hints to Oracle and Microsoft SQL Server

https://gerrit.wikimedia.org/r/791654

May 13 2022, 6:34 PM · MW-1.39-notes (1.39.0-wmf.14; 2022-05-30), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), MW-1.34-notes (1.34.0-wmf.21; 2019-09-03), Wikimania-Hackathon-2019, User-Ladsgroup, MediaWiki-Installer, Oracle Database, MSSQL

Feb 6 2022

alex-mashin closed T287101: Enable {{#get_db_data:}} to connect to MS SQL Server as Resolved.
Feb 6 2022, 5:25 PM · MSSQL, MediaWiki-extensions-ExternalData

Feb 3 2022

Maintenance_bot removed a project from T287101: Enable {{#get_db_data:}} to connect to MS SQL Server: Patch-For-Review.
Feb 3 2022, 6:10 AM · MSSQL, MediaWiki-extensions-ExternalData
gerritbot added a comment to T287101: Enable {{#get_db_data:}} to connect to MS SQL Server.

Change 759372 merged by jenkins-bot:

[mediawiki/extensions/ExternalData@master] Correct messages for absent libraries

https://gerrit.wikimedia.org/r/759372

Feb 3 2022, 5:15 AM · MSSQL, MediaWiki-extensions-ExternalData
gerritbot added a project to T287101: Enable {{#get_db_data:}} to connect to MS SQL Server: Patch-For-Review.
Feb 3 2022, 3:56 AM · MSSQL, MediaWiki-extensions-ExternalData
gerritbot added a comment to T287101: Enable {{#get_db_data:}} to connect to MS SQL Server.

Change 759372 had a related patch set uploaded (by Alex Mashin; author: mashin):

[mediawiki/extensions/ExternalData@master] Correct messages for absent libraries

https://gerrit.wikimedia.org/r/759372

Feb 3 2022, 3:56 AM · MSSQL, MediaWiki-extensions-ExternalData

Feb 2 2022

Maintenance_bot removed a project from T287101: Enable {{#get_db_data:}} to connect to MS SQL Server: Patch-For-Review.
Feb 2 2022, 2:10 PM · MSSQL, MediaWiki-extensions-ExternalData
gerritbot added a comment to T287101: Enable {{#get_db_data:}} to connect to MS SQL Server.

Change 759143 merged by jenkins-bot:

[mediawiki/extensions/ExternalData@master] Handle absence of odbc and pgsql libraries in PHP gracefully

https://gerrit.wikimedia.org/r/759143

Feb 2 2022, 1:57 PM · MSSQL, MediaWiki-extensions-ExternalData
gerritbot added a project to T287101: Enable {{#get_db_data:}} to connect to MS SQL Server: Patch-For-Review.
Feb 2 2022, 6:13 AM · MSSQL, MediaWiki-extensions-ExternalData
gerritbot added a comment to T287101: Enable {{#get_db_data:}} to connect to MS SQL Server.

Change 759143 had a related patch set uploaded (by Alex Mashin; author: mashin):

[mediawiki/extensions/ExternalData@master] Handle absence of ODBC library in PHP gracefully

https://gerrit.wikimedia.org/r/759143

Feb 2 2022, 6:13 AM · MSSQL, MediaWiki-extensions-ExternalData
alex-mashin reopened T287101: Enable {{#get_db_data:}} to connect to MS SQL Server as "In Progress".
Feb 2 2022, 5:28 AM · MSSQL, MediaWiki-extensions-ExternalData

Feb 1 2022

alex-mashin closed T287101: Enable {{#get_db_data:}} to connect to MS SQL Server as Resolved.
Feb 1 2022, 1:54 AM · MSSQL, MediaWiki-extensions-ExternalData

Jan 30 2022

Maintenance_bot removed a project from T287101: Enable {{#get_db_data:}} to connect to MS SQL Server: Patch-For-Review.
Jan 30 2022, 3:10 PM · MSSQL, MediaWiki-extensions-ExternalData
gerritbot added a comment to T287101: Enable {{#get_db_data:}} to connect to MS SQL Server.

Change 758035 merged by jenkins-bot:

[mediawiki/extensions/ExternalData@master] Enable {{#get_db_data:}} to connect to MS SQL Server

https://gerrit.wikimedia.org/r/758035

Jan 30 2022, 2:22 PM · MSSQL, MediaWiki-extensions-ExternalData

Jan 29 2022

gerritbot added a project to T287101: Enable {{#get_db_data:}} to connect to MS SQL Server: Patch-For-Review.
Jan 29 2022, 8:40 AM · MSSQL, MediaWiki-extensions-ExternalData
gerritbot added a comment to T287101: Enable {{#get_db_data:}} to connect to MS SQL Server.

Change 758035 had a related patch set uploaded (by Alex Mashin; author: mashin):

[mediawiki/extensions/ExternalData@master] Enable {{#get_db_data:}} to connect to MS SQL Server

https://gerrit.wikimedia.org/r/758035

Jan 29 2022, 8:40 AM · MSSQL, MediaWiki-extensions-ExternalData

Dec 26 2021

Maintenance_bot moved T191231: RFC: Abstract schemas and schema changes from Incoming to Done on the User-Ladsgroup board.
Dec 26 2021, 1:15 AM · User-Ladsgroup, MW-1.36-notes (1.36.0-wmf.38; 2021-04-06), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.32; 2020-05-12), Platform Team Workboards (Initiatives), Platform Team Initiatives (Abstract Schema), TechCom-RFC (TechCom-RFC-Closed), MediaWiki-Installer, User-Addshore, SQLite, Oracle Database, MSSQL, PostgreSQL, Epic

Sep 30 2021

Reedy closed T279858: Formally EOL REL1_31, a subtask of T230583: Archive MSSQL project, as Resolved.
Sep 30 2021, 6:23 PM · MSSQL, Project-Admins

Sep 29 2021

Reedy changed the status of T279858: Formally EOL REL1_31, a subtask of T230583: Archive MSSQL project, from Open to In Progress.
Sep 29 2021, 2:55 PM · MSSQL, Project-Admins

Jul 24 2021

Aklapper closed T252313: Document mapping of SQL data types across DBMS, a subtask of T191231: RFC: Abstract schemas and schema changes, as Resolved.
Jul 24 2021, 6:15 PM · User-Ladsgroup, MW-1.36-notes (1.36.0-wmf.38; 2021-04-06), Patch-For-Review, MW-1.35-notes (1.35.0-wmf.32; 2020-05-12), Platform Team Workboards (Initiatives), Platform Team Initiatives (Abstract Schema), TechCom-RFC (TechCom-RFC-Closed), MediaWiki-Installer, User-Addshore, SQLite, Oracle Database, MSSQL, PostgreSQL, Epic

Jul 22 2021

Aklapper changed the subtype of T287101: Enable {{#get_db_data:}} to connect to MS SQL Server from "Task" to "Feature Request".
Jul 22 2021, 10:19 AM · MSSQL, MediaWiki-extensions-ExternalData

Jul 21 2021

alex-mashin updated the task description for T287101: Enable {{#get_db_data:}} to connect to MS SQL Server.
Jul 21 2021, 4:40 PM · MSSQL, MediaWiki-extensions-ExternalData
alex-mashin created T287101: Enable {{#get_db_data:}} to connect to MS SQL Server.
Jul 21 2021, 4:39 PM · MSSQL, MediaWiki-extensions-ExternalData

Jul 15 2021

Aklapper added a comment to T166133: MSSQL: Fulltext search doesn’t work.

@Arskrigicioniec: This ticket is specifically about MSSQL and declined; see the previous comments.

Jul 15 2021, 11:25 AM · patch-welcome, Discovery-Search, MediaWiki-Search, Discovery-ARCHIVED, MSSQL
Arskrigicioniec added a comment to T166133: MSSQL: Fulltext search doesn’t work.

I have the same problem with my MySQL shared hosting on clean 1.34 MediaWiki. I use Russian local. The search results give me only headers, despite of search by key words actually works.

Jul 15 2021, 11:02 AM · patch-welcome, Discovery-Search, MediaWiki-Search, Discovery-ARCHIVED, MSSQL

Jun 7 2021

Maintenance_bot removed a project from T283021: Remove MSSQL support from Replace Text: Patch-For-Review.
Jun 7 2021, 8:10 PM · MSSQL, MediaWiki-extensions-ReplaceText
Umherirrender closed T283021: Remove MSSQL support from Replace Text as Resolved.
Jun 7 2021, 7:49 PM · MSSQL, MediaWiki-extensions-ReplaceText
gerritbot added a comment to T283021: Remove MSSQL support from Replace Text.

Change 697147 merged by jenkins-bot:

[mediawiki/extensions/ReplaceText@master] Remove MSSQL support

https://gerrit.wikimedia.org/r/697147

Jun 7 2021, 7:48 PM · MSSQL, MediaWiki-extensions-ReplaceText

May 30 2021

Aklapper closed T230583: Archive MSSQL project as Resolved.
May 30 2021, 2:12 AM · MSSQL, Project-Admins
Aklapper archived MSSQL.
May 30 2021, 2:11 AM
Aklapper edited Description on MSSQL.
May 30 2021, 2:11 AM

May 29 2021

gerritbot added a project to T283021: Remove MSSQL support from Replace Text: Patch-For-Review.
May 29 2021, 6:29 PM · MSSQL, MediaWiki-extensions-ReplaceText
gerritbot added a comment to T283021: Remove MSSQL support from Replace Text.

Change 697147 had a related patch set uploaded (by Umherirrender; author: Umherirrender):

[mediawiki/extensions/ReplaceText@master] Remove MSSQL support

https://gerrit.wikimedia.org/r/697147

May 29 2021, 6:29 PM · MSSQL, MediaWiki-extensions-ReplaceText
Umherirrender closed T283020: Remove MSSQL support from Cargo as Resolved.
May 29 2021, 6:22 PM · Patch-For-Review, MSSQL, MediaWiki-extensions-Cargo
Umherirrender closed T230855: MSSQL Setup failing during installation with error "Schema must be null if database is null" as Declined.
May 29 2021, 6:21 PM · MediaWiki-Installer, MSSQL
Umherirrender closed T228079: SqlBagOStuff Unserialize Error: Error at offset 133 of 724 bytes in includes\objectcache\SqlBagOStuff.php:697 as Declined.
May 29 2021, 6:20 PM · MSSQL, MediaWiki-libs-BagOStuff
Umherirrender closed T228740: DBConnectionError on MSSQL: Cannot access the database: Unknown error as Declined.
May 29 2021, 6:20 PM · MediaWiki-General, MSSQL
Umherirrender closed T227607: Foreign key "FK_page_latest_page_id" breaks ability to delete pages on Mssql installs as Declined.
May 29 2021, 6:19 PM · MediaWiki-Page-deletion, MSSQL