UESPWiki:Upgrade History/2017

22 Nov 2017
Installed the MwEmbedSupport and TimedMediaHandler on content1/2 (was testing on content3). Note that only the client side portion of the TimedMediaHandler extension is working as I cannot get the server side portion to fully compile. -- Daveh   15:07, 22 November 2017 (UTC)

17 Nov 2017
Installed the UespLegendCardData extension on content1/2/3. -- Daveh   15:07, 22 November 2017 (UTC)

8 August 2017
config/Extensions.php: Tweaked captcha to see if it's enough to throw off bulk account creations.  &ndash;       17:36, 8 August 2017 (UTC), and again at 18:08, 8 August 2017 (UTC)

13 July 2017
Permissions.php: Added   group and allowed admins to add/remove members.  &ndash;       21:57, 13 July 2017 (UTC)
UespMonobook.skin.php:
Temporarily wrapped top ad in   so it can be suppressed on a user-by-user basis until the design issues can be worked out.  &ndash;       21:33, 13 July 2017 (UTC)
Re-applied 16 April 2017 changes to fix sidebar headers.  &ndash;       03:00, 13 July 2017 (UTC)

19 June 2017
A few more tweaks to config/Mobile.php to redirect www.uesp.net and m.uesp.net correctly to en.m.uesp.net on a mobile device. Also now redirects to http or https depending on the original URL. -- Daveh   12:47, 19 June 2017 (UTC)

17 June 2017
Running   due to incorrect counts on some categories.  &ndash;       20:20, 17 June 2017 (UTC)

16 June 2017
A small change to config/Mobile.php on content1/2/3 to try and prevent the 302 redirect itself from being cached by Squid. -- Daveh   19:12, 16 June 2017 (UTC)
Installed a new wildcard SSL certificate for the *.m.uesp.net domains. -- Daveh   20:16, 16 June 2017 (UTC)
The mobile site en.m.uesp.net no longer goes through Squid but is directed to content2. Squid 2.x doesn't seem to be able to handle multiple SSL certificates going to the same IP address. -- Daveh   20:16, 16 June 2017 (UTC)

15 June 2017
Modified config/Mobile.php on content1/2/3 to force a redirect to the mobile if required. This should prevent mobile users from poisoning the cache of desktop users as MobileFrontEnd was not handling the mobile redirects as I assumed it was. -- Daveh   19:32, 15 June 2017 (UTC)

14 June 2017
php.ini: Temporarily increased   and   maximum sizes from 60MB to 200MB on content3 only.  &ndash;       19:28, 14 June 2017 (UTC)

30 April 2017
Extensions.php: Disabled really old StringFunctions extension in favour of ParserFunctions with  .  &ndash;       08:32, 30 April 2017 (UTC)
Extensions.php: Added   to allow template string functions to work on really long strings.  &ndash;       09:18, 30 April 2017 (UTC)

27 April 2017
IP banned a dozen+ addresses on squid1 that were repeatedly requesting Special:RecentChangesLinkedHere/... pages to the point of overloading content1/content2. -- Daveh   20:34, 27 April 2017 (UTC)

20 April 2017
Changed the negative_ttl on squid1 from 0 to 1 seconds to try and prevent 500 responses from being cached by Squid.  -- Daveh   13:44, 20 April 2017 (UTC)
Restarted Squid to reset the large (500GB) access log which also seems to have fixed Main_Page from returning blank on HTTPS conections. -- Daveh   13:44, 20 April 2017 (UTC)

17 April 2017
Updated all old MySQL passwords on db1/db2 to the latest password hash. Removed a bunch of users that were no longer being used. Basic process is just:
::* Use select User, Host, Password from mysql.user; to see which users have short password hashes.
::* Delete a user with ''drop user 'name'@'host';.
::* Reset any password with set password for 'user'@'host' = PASSWORD('password');.
:: -- Daveh   14:25, 17 April 2017 (UTC)

16 April 2017
UespMonobook.skin.php: fixed an errant set of   tags to   so all sidebar titles are aligned the same.  &ndash;       01:28, 16 April 2017 (UTC)

15 April 2017
Updated UespVector to load numerous styles that are loaded outside of Vector.php in 1.23 (most of this bizarreness is fixed in 1.24). This fixes display of numerous pages, most notably, .  &ndash;       21:23, 15 April 2017 (UTC)
Disabled built-in Vector skin.  &ndash;       19:44, 15 April 2017 (UTC)
Added UespVector skin.  &ndash;       00:07, 15 April 2017 (UTC)

13 April 2017
config/CommonSettings.php: Disabled built-in Monobook skin in   so only our custom Monobook is available.  &ndash;       20:48, 13 April 2017 (UTC)
SiteSpecialSearch.php'':
Added Legends to Other ES sites section.
Fixed search shortcut links like  not doing anything.  &ndash;       06:40, 13 April 2017 (UTC)

6 April 2017
Fixed the preferences "Default Settings" link which wasn't working due to changes in the MediaWiki base code relating to preferences. -- Daveh   13:50, 6 April 2017 (UTC)
Enabled HTTPS on most UESP sites including the wiki. Needs more testing to ensure all URLs are used according to the relevant protocol (i.e., HTTPS doesn't try to load resources/files from HTTP). -- Daveh   20:58, 6 April 2017 (UTC)

15 March 2017
Ran   to re-update   table, which is missing older entries. This caused some special pages, such as , to be missing historical information, even though it was available in the log.  &ndash;       17:42, 15 March 2017 (UTC)
::Note: ineffective - populateLogSearch only handles old RevisionDelete logs currently.  &ndash;       18:00, 15 March 2017 (UTC)

11 March 2017
Completely dumped all databases on content3, dropped all databases, deleted the large ibdata1 MySQL file, restarted MySQL and reimported the database dump. Restarted slave replication from db1 which took a few hours to catchup. With all the recent database optimization free space on content3 has improved from 40GB to 320GB free. -- Daveh   00:16, 12 March 2017 (UTC)

10 March 2017
Moved the uesp_esolog database from content3 to db1. Temporarily made db1 the 100% read database due to slave replication delay on db2 causing issues. -- Daveh   01:21, 11 March 2017 (UTC)
After moving the database made db1/db2 50% read databases each for wikis. -- Daveh   01:21, 11 March 2017 (UTC)

9 March 2017
Moved the uesp_esosalesdata database from content3 to db1. -- Daveh   17:19, 9 March 2017 (UTC)
Increased the query cache size and a few other buffer sizes on db1/db2/content3 (based on available free memory). -- Daveh   17:19, 9 March 2017 (UTC)

3 March 2017
config/CommonSettings.php: Added   to block proxy addresses that travel through blocked proxy IPs, in addition to those that come directly from those IPs. See .

1 March 2017
config/Extensions.php: Added   as an interim fix for problem with   calls in  .  &ndash;       22:44, 1 March 2017 (UTC)
: Although no longer required by the template, I've left this setting in place for now, against future need, since text replacement is somewhat common in our templates.  &ndash;       20:51, 3 March 2017 (UTC)

25 February 2017
Changed Squid cache to never cache Wiki edit links (queries containing action=edit) due to issues with some edits returning 500 error codes. -- Daveh   19:28, 25 February 2017 (UTC)

9 February 2017
Removed the dev wiki from content3. Both the files and database have been copied to backup1 but it is not currently setup.

3 February 2017
Added the new server backup1 to the cluster intended mainly as a standalone backup file repository for all other servers. All backups previously done on content3 are being moved to backup1 to increase the available free drive space on content3. The offsite backup server has been renamed to backup2. -- Daveh   17:33, 3 February 2017 (UTC)
qwebirChat.php: Commented out chat tab hook on all servers.  &ndash;       21:46, 3 February 2017 (UTC)

23 January 2017
config/Extensions.php: Removed SpamBlacklist configuration which led to having two pages performing the same function ( and  ).  &ndash;       03:12, 23 January 2017 (UTC)
Spam Blacklist subsequently deleted on 6 Feb.      23:08, 14 February 2017 (UTC)

5 January 2017
LocalSettings.php: Increased $wgMaxImageArea to 2.5e7 to allow thumbnails to be generated for the larger images that are allowed on that server.  &ndash;       18:34, 5 January 2017 (UTC)