@Pigsonthewing: Setting project to Wikimedia-Site-requests, as this request is about settings / configuration of a Wikimedia website. In the future, please always follow https://meta.wikimedia.org/wiki/Requesting_wiki_configuration_changes when requesting such site configuration changes. Thanks!

Change 863442 had a related patch set uploaded (by Stang; author: Stang):

[mediawiki/extensions/WikimediaMaintenance@master] createExtensionTables: Add extension GeoData

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

Change 865766 had a related patch set uploaded (by Stang; author: Stang):

[operations/mediawiki-config@master] specieswiki: Install GeoData extension

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

Change 865766 merged by jenkins-bot:

[operations/mediawiki-config@master] specieswiki: Install GeoData extension

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

Mentioned in SAL (#wikimedia-operations) [2022-12-07T21:41:47Z] <samtar@deploy1002> Started scap: Backport for [[gerrit:865766|specieswiki: Install GeoData extension (T324348)]]

Mentioned in SAL (#wikimedia-operations) [2022-12-07T21:43:39Z] <samtar@deploy1002> samtar and stang: Backport for [[gerrit:865766|specieswiki: Install GeoData extension (T324348)]] synced to the testservers: mwdebug1001.eqiad.wmnet, mwdebug2002.codfw.wmnet, mwdebug2001.codfw.wmnet, mwdebug1002.eqiad.wmnet

Change 863442 merged by jenkins-bot:

[mediawiki/extensions/WikimediaMaintenance@master] createExtensionTables: Add extension GeoData

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

Change 865748 had a related patch set uploaded (by Stang; author: Stang):

[mediawiki/extensions/WikimediaMaintenance@wmf/1.40.0-wmf.13] createExtensionTables: Add extension GeoData

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

Change 865763 had a related patch set uploaded (by Stang; author: Stang):

[operations/mediawiki-config@master] specieswiki: Install GeoData extension"

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

Change 865748 merged by jenkins-bot:

[mediawiki/extensions/WikimediaMaintenance@wmf/1.40.0-wmf.13] createExtensionTables: Add extension GeoData

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

Mentioned in SAL (#wikimedia-operations) [2022-12-08T21:29:42Z] <samtar@deploy1002> Started scap: Backport for [[gerrit:865748|createExtensionTables: Add extension GeoData (T324348)]]

Mentioned in SAL (#wikimedia-operations) [2022-12-08T21:31:28Z] <samtar@deploy1002> samtar and stang: Backport for [[gerrit:865748|createExtensionTables: Add extension GeoData (T324348)]] synced to the testservers: mwdebug2002.codfw.wmnet, mwdebug1001.eqiad.wmnet, mwdebug2001.codfw.wmnet, mwdebug1002.eqiad.wmnet

Mentioned in SAL (#wikimedia-operations) [2022-12-08T21:37:43Z] <samtar@deploy1002> Finished scap: Backport for [[gerrit:865748|createExtensionTables: Add extension GeoData (T324348)]] (duration: 08m 01s)

Mentioned in SAL (#wikimedia-operations) [2022-12-08T21:39:36Z] <TheresNoTime> T324348 : [samtar@mwmaint1002 ~]$ mwscript extensions/WikimediaMaintenance/createExtensionTables.php specieswiki geodata

Interestingly Table 'geo_tags' already exists for specieswiki

[samtar@mwmaint1002 ~]$ mwscript extensions/WikimediaMaintenance/createExtensionTables.php specieswiki geodata
Creating geodata tables...
  sourcing tables-generated.sql
Wikimedia\Rdbms\DBQueryError from line 1555 of /srv/mediawiki/php-1.40.0-wmf.13/includes/libs/rdbms/database/Database.php: Error 1050: Table 'geo_tags' already exists
Function: Wikimedia\Rdbms\Database::sourceFile( /srv/mediawiki/php-1.40.0-wmf.13/extensions/GeoData/sql/mysql/tables-generated.sql )
Query: CREATE TABLE `geo_tags` (
 gt_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
 gt_page_id INT UNSIGNED NOT NULL,
 gt_globe VARCHAR(32) NOT NULL,
 gt_primary TINYINT(1) NOT NULL,
 gt_lat_int SMALLINT DEFAULT NULL,
 gt_lon_int SMALLINT DEFAULT NULL,
 gt_lat NUMERIC(11, 8) NOT NULL,
 gt_lon NUMERIC(11, 8) NOT NULL,
 gt_dim INT DEFAULT NULL,
 gt_type VARCHAR(32) DEFAULT NULL,
 gt_name VARBINARY(255) DEFAULT NULL,
 gt_country CHAR(2) DEFAULT NULL,
 gt_region VARCHAR(3) DEFAULT NULL,
 INDEX gt_page_primary (gt_page_id, gt_primary),
 INDEX gt_page_id_id (gt_page_id),
 INDEX gt_spatial (
 gt_lat_int, gt_lon_int, gt_lon, gt_primary
 ),
 PRIMARY KEY(gt_id)
 ) /*$wgDBTableOptions*/


#0 /srv/mediawiki/php-1.40.0-wmf.13/includes/libs/rdbms/database/Database.php(1539): Wikimedia\Rdbms\Database->getQueryException('Table 'geo_tags...', 1050, 'CREATE TABLE `g...', 'Wikimedia\\Rdbms...')
#1 /srv/mediawiki/php-1.40.0-wmf.13/includes/libs/rdbms/database/Database.php(1513): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('Table 'geo_tags...', 1050, 'CREATE TABLE `g...', 'Wikimedia\\Rdbms...')
#2 /srv/mediawiki/php-1.40.0-wmf.13/includes/libs/rdbms/database/Database.php(893): Wikimedia\Rdbms\Database->reportQueryError('Table 'geo_tags...', 1050, 'CREATE TABLE `g...', 'Wikimedia\\Rdbms...', false)
#3 /srv/mediawiki/php-1.40.0-wmf.13/includes/libs/rdbms/database/Database.php(3259): Wikimedia\Rdbms\Database->query('CREATE TABLE `g...', 'Wikimedia\\Rdbms...')
#4 /srv/mediawiki/php-1.40.0-wmf.13/includes/libs/rdbms/database/Database.php(3198): Wikimedia\Rdbms\Database->sourceStream(Resource id #1257, NULL, NULL, 'Wikimedia\\Rdbms...', NULL)
#5 /srv/mediawiki/php-1.40.0-wmf.13/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->sourceFile('/srv/mediawiki/...')
#6 /srv/mediawiki/php-1.40.0-wmf.13/includes/libs/rdbms/database/DBConnRef.php(822): Wikimedia\Rdbms\DBConnRef->__call('sourceFile', Array)
#7 /srv/mediawiki/php-1.40.0-wmf.13/extensions/WikimediaMaintenance/createExtensionTables.php(192): Wikimedia\Rdbms\DBConnRef->sourceFile('/srv/mediawiki/...')
#8 /srv/mediawiki/php-1.40.0-wmf.13/maintenance/includes/MaintenanceRunner.php(309): CreateExtensionTables->execute()
#9 /srv/mediawiki/php-1.40.0-wmf.13/maintenance/doMaintenance.php(85): MediaWiki\Maintenance\MaintenanceRunner->run()
#10 /srv/mediawiki/php-1.40.0-wmf.13/extensions/WikimediaMaintenance/createExtensionTables.php(199): require_once('/srv/mediawiki/...')
#11 /srv/mediawiki/multiversion/MWScript.php(120): require_once('/srv/mediawiki/...')
#12 {main}

Change 865763 merged by jenkins-bot:

[operations/mediawiki-config@master] specieswiki: Install GeoData extension

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

Mentioned in SAL (#wikimedia-operations) [2022-12-08T21:44:21Z] <samtar@deploy1002> Started scap: Backport for [[gerrit:865763|specieswiki: Install GeoData extension (T324348)]]

Mentioned in SAL (#wikimedia-operations) [2022-12-08T21:46:08Z] <samtar@deploy1002> samtar and stang: Backport for [[gerrit:865763|specieswiki: Install GeoData extension (T324348)]] synced to the testservers: mwdebug2002.codfw.wmnet, mwdebug2001.codfw.wmnet, mwdebug1001.eqiad.wmnet, mwdebug1002.eqiad.wmnet

Mentioned in SAL (#wikimedia-operations) [2022-12-08T21:53:38Z] <samtar@deploy1002> Finished scap: Backport for [[gerrit:865763|specieswiki: Install GeoData extension (T324348)]] (duration: 09m 16s)

Thank you, all.

However, most of the above is impenetrable to a lay person. When should this go live on Wikispecies?

In T324348#8457238, @Pigsonthewing wrote:

Thank you, all.

However, most of the above is impenetrable to a lay person. When should this go live on Wikispecies?

Just before 10PM UTC last night.

Confirmed working. Thank you again.