https://bugzilla.wikimedia.org/show_bug.cgi?id=69360
Bug ID: 69360
Summary: missing 'patch-add_interwiki.sql' for the
includes/installer/PostgresqlUpdater.php
Product: MediaWiki
Version: 1.24-git
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: anton.koch...@gmail.com
Web browser: ---
Mobile Platform: ---
See the last functions in the file 'includes/installer/PostgresqlUpdater.php':
protected function addInterwikiType() {
$this->applyPatch( 'patch-add_interwiki.sql', false, "Refreshing
add_interwiki()" );
}
protected function tsearchFixes() {
# Tweak the page_title tsearch2 trigger to filter out slashes
# This is create or replace, so harmless to call if not needed
$this->applyPatch( 'patch-ts2pagetitle.sql', false, "Refreshing
ts2_page_title()" );
# If the server is 8.3 or higher, rewrite the tsearch2 triggers
# in case they have the old 'default' versions
# Gather version numbers in case we need them
if ( $this->db->getServerVersion() >= 8.3 ) {
$this->applyPatch( 'patch-tsearch2funcs.sql', false, "Rewriting tsearch2
triggers" );
}
}
All these *.sql files are missing. Moreover, addInterwikiType() calls even if
interwiki table already exists.
Also patch-interwiki.sql for PostgreSQL should be:
CREATE TABLE /*$wgDBprefix*/interwiki (
-- The interwiki prefix, (e.g. "Meatball", or the language prefix "de")
iw_prefix varchar(32) NOT NULL,
-- The URL of the wiki, with "$1" as a placeholder for an article name.
-- Any spaces in the name will be transformed to underscores before
-- insertion.
iw_url byteea NOT NULL,
-- A boolean value indicating whether the wiki is in this project
-- (used, for example, to detect redirect loops)
iw_local BOOL NOT NULL,
PRIMARY KEY (iw_prefix),
UNIQUE (iw_prefix)
) /*$wgDBTableOptions*/;
But this is could be wrong too - upgrade script suggests that iw_local column
translating into smallint type, so it should be already smallint from the start
(bool->smallint translation is not allowed, afair).
So these SQL files and updater scripts should be syncronised for consistency.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
