CZ:Technical/Upgrades

From Citizendium
< CZ:Technical
Revision as of 13:18, 27 November 2020 by imported>Pat Palmer (→‎Empty test grid)
Jump to navigation Jump to search

This is a catalog of needed MediaWiki software upgrade tests.

Nov 25, 2020 tests performed for test server at http://czdev.dotdo.us/

Things to test after a Wikimedia upgrade
#
WHAT
WHO/WHEN
ERROR
PASS/fail
1
Edit an article
Pat Palmer (talk) 23 November 2020 (UTC)
none
PASS
2
Check article history for edit just made
Pat Palmer (talk) 23 November 2020 (UTC)
none
PASS
3
Roll back the edit just made
 
 
 
4
Create a new article without metadata
 
 
 
5
Create a new article with metadata
Pat Palmer (talk) 23 November 2020 (UTC)
Jump to navigation
Jump to search[18e88d8085b8325734f6c4bf] /index.php/Special:MetadataForm MediaWiki\Storage\PageUpdateException from line 1127 
  of /var/www/czdev/mediawiki/includes/Storage/PageUpdater.php: Failed to update   page row to use new revision.Backtrace:#0 
  /var/www/czdev/mediawiki/includes/Storage/PageUpdater.php(758): MediaWiki\Storage\PageUpdater->doCreate()
#1 /var/www/czdev/mediawiki/includes/page/WikiPage.php(1930): MediaWiki\Storage\PageUpdater->saveRevision()
#2 /var/www/czdev/mediawiki/extensions/MetadataForm/includes/SpecialMetadataForm.php(194): WikiPage->doEditContent()
#3 /var/www/czdev/mediawiki/extensions/MetadataForm/includes/SpecialMetadataForm.php(39): SpecialMetadataForm->createMetadata()
#4 /var/www/czdev/mediawiki/includes/specialpage/SpecialPage.php(575): SpecialMetadataForm->execute()
#5 /var/www/czdev/mediawiki/includes/specialpage/SpecialPageFactory.php(611): SpecialPage->run()
#6 /var/www/czdev/mediawiki/includes/MediaWiki.php(296): MediaWiki\Special\SpecialPageFactory->executePath()
#7 /var/www/czdev/mediawiki/includes/MediaWiki.php(900): MediaWiki->performRequest()
#8 /var/www/czdev/mediawiki/includes/MediaWiki.php(527): MediaWiki->main()
#9 /var/www/czdev/mediawiki/index.php(44): MediaWiki->run()
#10 {main}


fail
6
Delete the new article with metadata (check delete log)
 
 
 
7
Rename the new article without metadata (check log)
 
 
 
8
Check Recent Changes for all the above
 
 
 
9
Test the Forum
Pat Palmer (talk) 18:22, 27 November 2020 (UTC)
I edited the Style forum, but home page of Forum did not show that mine was the last edit.
fail
10
Are archives okay?
 
 
 
11
Go to a User Page and look for User Contributions
 
 
 
12
Test Special:ListUsers
Pat Palmer (talk) 23 November 2020 (UTC)
[2af9157e969f07cd5ec8211c] /index.php/Special:ListUsers Wikimedia\Rdbms\DBQueryError from line 1603
of /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. 
Did you forget to run your application's database schema updater after upgrading?
Query: SELECT user_name,MAX(user_id) AS "user_id",MAX(user_editcount) AS "edits",MIN(user_registration) AS 
   "creation",MAX(ipb_deleted) AS "ipb_deleted",MAX(ipb_sitewide) AS "ipb_sitewide" FROM "mwuser" 
   LEFT JOIN "user_groups" ON ((user_id=ug_user)) LEFT JOIN "ipblocks" ON ((user_id=ipb_user) AND 
   ipb_auto = '0') WHERE (ipb_deleted IS NULL OR ipb_deleted = 0) GROUP BY user_name ORDER BY user_name LIMIT 201
Function: IndexPager::buildQueryInfo (UsersPager)
Error: 42883 ERROR: function max(boolean) does not exist
LINE 1: ...) AS "creation",MAX(ipb_deleted) AS "ipb_deleted",MAX(ipb_si...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.Backtrace:
#0 /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#1 /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError()
#2 /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php(1807): Wikimedia\Rdbms\Database->query()
#3 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select()
#4 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DBConnRef.php(315): Wikimedia\Rdbms\DBConnRef->__call()
#5 /var/www/czdev/mediawiki/includes/pager/IndexPager.php(418): Wikimedia\Rdbms\DBConnRef->select()
#6 /var/www/czdev/mediawiki/includes/pager/IndexPager.php(261): IndexPager->reallyDoQuery()
#7 /var/www/czdev/mediawiki/includes/pager/IndexPager.php(474): IndexPager->doQuery()
#8 /var/www/czdev/mediawiki/includes/specials/SpecialListUsers.php(47): IndexPager->getBody()
#9 /var/www/czdev/mediawiki/includes/specialpage/SpecialPage.php(575): SpecialListUsers->execute()
#10 /var/www/czdev/mediawiki/includes/specialpage/SpecialPageFactory.php(611): SpecialPage->run()
#11 /var/www/czdev/mediawiki/includes/MediaWiki.php(296): MediaWiki\Special\SpecialPageFactory->executePath()
#12 /var/www/czdev/mediawiki/includes/MediaWiki.php(900): MediaWiki->performRequest()
#13 /var/www/czdev/mediawiki/includes/MediaWiki.php(527): MediaWiki->main()
#14 /var/www/czdev/mediawiki/index.php(44): MediaWiki->run()
#15 {main} (edited) 
fail
13
Test Special:ActiveUsers
Pat Palmer (talk) 23 November 2020 (UTC)
A database query error has occurred. This may indicate a bug in the software.
[3549525febafeafa9a527a7f] /index.php/Special:ActiveUsers Wikimedia\Rdbms\DBQueryError 
from line 1603 of /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php: 
A database query error has occurred. Did you forget to run your application's database 
schema updater after upgrading?   Query: SELECT ipb_user,MAX(ipb_deleted) AS deleted,  
  MAX(ipb_sitewide) AS sitewide FROM "ipblocks" WHERE ipb_user IN ('34395','30696') GROUP BY ipb_user
Function: ActiveUsersPager::doBatchLookups
Error: 42883 ERROR: function max(boolean) does not exist
LINE 1: ...ookups */ ipb_user,MAX(ipb_deleted) AS deleted, MAX(ipb_si...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.Backtrace:
#0 /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#1 /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError()
#2 /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php(1807): Wikimedia\Rdbms\Database->query()
#3 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select()
#4 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DBConnRef.php(315): Wikimedia\Rdbms\DBConnRef->__call()
#5 /var/www/czdev/mediawiki/includes/specials/pagers/ActiveUsersPager.php(212): Wikimedia\Rdbms\DBConnRef->select()
#6 /var/www/czdev/mediawiki/includes/pager/IndexPager.php(479): ActiveUsersPager->doBatchLookups()
#7 /var/www/czdev/mediawiki/includes/specials/SpecialActiveUsers.php(60): IndexPager->getBody()
#8 /var/www/czdev/mediawiki/includes/specialpage/SpecialPage.php(575): SpecialActiveUsers->execute()
#9 /var/www/czdev/mediawiki/includes/specialpage/SpecialPageFactory.php(611): SpecialPage->run()
#10 /var/www/czdev/mediawiki/includes/MediaWiki.php(296): MediaWiki\Special\SpecialPageFactory->executePath()
#11 /var/www/czdev/mediawiki/includes/MediaWiki.php(900): MediaWiki->performRequest()
#12 /var/www/czdev/mediawiki/includes/MediaWiki.php(527): MediaWiki->main()
#13 /var/www/czdev/mediawiki/index.php(44): MediaWiki->run()
#14 {main}
fail
14
Try to change a User skin
 
 
 
15
Look at home page on mobile device
 
 
 
16
Mouse over link to an existing article. Pop-up should show the /Definition contents (if any).
Pat Palmer (talk) 23 November 2020 (UTC)
Mousing over a link to an existing article, I only see the article name and not the /Definition page (if one exists)
fail
17
Do "R" and "Rpl" templates on Disambig page and Related Articles tabs display definitions correctly?
Pat Palmer (talk) 23 November 2020 (UTC)
Does not display the contents of the /Definition page (even when it exists); i.e., look at any disambig page or the list of writers at http://czdev.dotdo.us/index.php/CZ:Literature_Workgroup
fail


List of tests to add to empty grid (at bottom)

(nothing here right now)

Empty test grid

Copy this to top (and identify platform tested) before using, leaving this clean one for future use.

Things to test after a Wikimedia upgrade
#
WHAT
WHO/WHEN
ERROR
PASS/FAIL
1
Edit an article
 
 
 
2
Check article history for edit just made
 
 
 
3
Roll back the edit just made
 
 
 
4
Create a new article without metadata
 
 
 
5
Create a new article with metadata
 
 
 
6
Delete the new article with metadata (check delete log)
 
 
 
7
Rename the new article without metadata (check log)
 
 
 
8
Check Recent Changes for all the above
 
 
 
9
Test the Forum
 
 
 
10
Are archives okay?
 
 
 
11
Go to a User Page and look for User Contributions
 
 
 
12
Test Special:ListUsers
 
 
 
13
Test Special:ActiveUsers
 
 
 
14
Try to change a User skin
 
 
 
15
Look at home page on mobile device
 
 
 
16
Mouse over link to an existing article. Pop-up should show the /Definition contents (if any).
 
 
 
17
Do "R" and "Rpl" templates on Disambig page and Related Articles tabs display definitions correctly?
 
 
 
18
Test the watchlist. Can a user manually change it? Do page changes emailing "watching" users?
 
 
 
19
tbd
 
 
 
20
tbd