Editing Quake Wiki:Log

This page lists administrative tasks and suchs.
2022-03-27/28: Upgraded the server OS, installed php-dom to fix "Class 'DOMDocument' not found". Tried to upgrade to 1.37 but the upgrade process is broken for SQLite. [[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 19:34, 28 March 2022 (CEST)

2021-10-15: Restored a backup from the day before after some kid vandalised all pages. [[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 13:15, 15 October 2021 (CEST)

2019-09-19: Wiki was constantly slow, so I added a daily cronjob to `DELETE FROM MODULE_DEPS; DELETE FROM l10n_cache; VACUUM;`. Wtf is wrong. [[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 22:46, 19 September 2019 (CEST)

2019-07-09: msg_resource table does not exist anymore but we had slowness again. "DELETE FROM MODULE_DEPS; VACUUM;" fixed it.

Also, l10n_cache was 500 megabytes. WTF mediawiki, wtf... DELETEd FROM that too.

2019-04-20: Moved to new server, changed outgoing mail setup, published [https://quakewiki.org/static/awffull/ statistics] --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 18:18, 21 April 2019 (CEST)

2017-02-05: Moved to new server --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 20:46, 5 February 2017 (UTC)

2015-12-21: Vacuumed msg_resource table again. Had 4 seconds of page rendering time... --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 18:55, 21 December 2015 (UTC)

2015-12-03: Installed Let's Encrypt certificate and set the site to HTTPS. Copied Google Fonts to local /static/ directory to protect user privacy. --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 20:04, 3 December 2015 (UTC)

2014-04-16: Set $wgJobRunRate = 0; and now everything is mega slow... --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 21:08, 16 April 2015 (UTC)

2014-04-12: Vacuumed msg_resource table again. --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 17:07, 12 April 2015 (UTC)

2014-01-02: Vacuumed msg_resource table again, the site was locked into some maintenance tasks. --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 21:05, 24 November 2014 (UTC)

2014-05-12: Added favicon by Scampie. Thanks! --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 10:26, 12 May 2014 (UTC)

2014-05-07: Site moved to new server. --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 10:26, 12 May 2014 (UTC)

2014-01-02: Vacuumed msg_resource table again. --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 10:26, 12 May 2014 (UTC)

2013-05-28: I moved Starbuck's CSS to the Wiki at http://quakewiki.org/wiki/MediaWiki:Common.css and also used local links for all the images. The fonts remain hosted at Google for now.

2013-04-27: The wiki was incredibly slow. Profiling showed "query: SELECT mr_blob,mr_resource,mr_timestamp FROM msg_resource WHERE mr_r" as offender. The table had 80k entries. I simply did "DELETE FROM msg_resource; vacuum;" and it seems to have fixed it. [[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 19:26, 27 April 2013 (UTC)
@@ Line 30: / Line 30: @@
 -01-02: Vacuumed msg_resource table again. --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 10:26, 12 May 2014 (UTC)
--09-14: Domain renewed for another year. --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 11:35, 14 September 2013 (UTC)
+-05-28: I moved Starbuck's CSS to the Wiki at http://quakewiki.org/wiki/MediaWiki:Common.css and also used local links for all the images. The fonts remain hosted at Google for now.
--05-28: I moved Starbuck's CSS to the Wiki at http://quakewiki.org/wiki/MediaWiki:Common.css and also used local links for all the images. The fonts remain hosted at Google for now. --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 00:00, 28 May 2013 (UTC)
+-04-27: The wiki was incredibly slow. Profiling showed "query: SELECT mr_blob,mr_resource,mr_timestamp FROM msg_resource WHERE mr_r" as offender. The table had 80k entries. I simply did "DELETE FROM msg_resource; vacuum;" and it seems to have fixed it. [[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 19:26, 27 April 2013 (UTC)
--04-27: The wiki was incredibly slow. Profiling showed "query: SELECT mr_blob,mr_resource,mr_timestamp FROM msg_resource WHERE mr_r" as offender. The table had 80k entries. I simply did "DELETE FROM msg_resource; vacuum;" and it seems to have fixed it. --[[User:Spirit|Spirit]] ([[User talk:Spirit|talk]]) 19:26, 27 April 2013 (UTC)