User:JimTittsler/MediaWiki Upgrade

Update WikiEducator from 1.23

Plan

• make a dev instance on boer (arm64 Debian 12 bookworm) with PHP5.6, PHP7.4, and PHP8.3
• upgrade to 1.35
  • users -> actors
  • temporarily install Structured Discussions
    • flatten all LiquidThreads talk pages into flat wikitext archives
• upgrade to 1.43 and/or 1.45

Problems

• LiquidThreads is deprecated, and its replacement StructuredDiscussions is also deprecated
  • Plan: flatten LQT pages. in 1.4x enable Extension:DiscussionTools to reenable replies

Obsolete or No longer needed

• the WEtheme extension is presumably no longer necessary since OERf is history and Otago Polytechnic is no longer using their corner of the wiki
• the Collections extension is not useful without a (public) render server other than PediaPress

1.23.14

Dave provided a snapshot of en.Wikieducator and database. He also provided a Docker container (which has problems restarting because it doesn't idempotently install Compose).

• cleaned up LocalSettings.php (and CommonSettings.php) so it would run on the dev instance
• remove deprecated settings
  • $wgDBmysql5

1.35.14

• generate a "fresh" LocalSettings.php
• major DB update (users -> actors)
• migrate from "require" to resource loader for extensions
• disabled (in favor of MultimediaViewer eventually)
  • MWEmbedSupport
  • TimedMediaHandler
• also disabled
  • SimpleMathJAX
  • LicenseByCategory
  • DismissableSiteNotice
  • Collection
  • EditCount
  • WikiArticleFeeds
  • RSS
  • Quiz
  • SimpleTable (VisualEditor removes the need)
  • Widgets
  • WEpoll
  • WEnotes
  • googleAnalytics (sic)
  • Matomo
  • EventLogging
  • UploadWizard
  • WESnapshot
  • OAuth (did anything ever end up using WE as a provider?)
  • ConfirmEdit

• TRUNCATE TABLE mw_l10n_cache;
• php maintenance/rebuildLocalisationCache.php --force

• install LiquidThreads and Flow (StructuredDiscussions)
• install Echo
  • convert LQT to Flow, moving LQT to talk archive pages php7.4 extensions/Flow/maintenance/convertAllLqtPages.php --force-recovery-conversion
  • delete the LQT archives

mysql we_en -N -e "
    SELECT CONCAT(
        CASE page_namespace 
            WHEN 1 THEN 'Talk:' WHEN 3 THEN 'User_talk:' WHEN 5 THEN 'WikiEducator_talk:'
            WHEN 7 THEN 'File_talk:' WHEN 9 THEN 'MediaWiki_talk:' WHEN 11 THEN 'Template_talk:'
            WHEN 13 THEN 'Help_talk:' WHEN 15 THEN 'Category_talk:' WHEN 101 THEN 'Portal_talk:'
            WHEN 103 THEN 'Practice_talk:' WHEN 105 THEN 'OERF_talk:' ELSE '' 
        END, page_title) 
    FROM mw_page 
    WHERE page_title LIKE '%LQT_Archive%';" > lqt_archives_to_delete.txt
php7.4 maintenance/deleteBatch.php --r "Cleanup: remove LQT archives" -u "Flow talk page manager" lqt_archives_to_delete.txt