CZ:Technical/Upgrades: Difference between revisions

From Citizendium
Jump to navigation Jump to search
imported>Pat Palmer
imported>John Stephenson
(can't unblock user)
 
(20 intermediate revisions by 2 users not shown)
Line 5: Line 5:


== Nov 25, 2020 tests performed for test server at [http://czdev.dotdo.us/ http://czdev.dotdo.us/] ==
== Nov 25, 2020 tests performed for test server at [http://czdev.dotdo.us/ http://czdev.dotdo.us/] ==
Things to add:
* tbd
* tbd
----


{|width=90% align=center border="3" cellpadding="4" cellspacing="0" style="border-bottom:1px solid #dddddd; border-top:1px solid #dddddd; border-left:1px solid #aaaaaa; border-right:1px solid #dddddd; margin:0 auto; clear: both;"
{|width=90% align=center border="3" cellpadding="4" cellspacing="0" style="border-bottom:1px solid #dddddd; border-top:1px solid #dddddd; border-left:1px solid #aaaaaa; border-right:1px solid #dddddd; margin:0 auto; clear: both;"
Line 16: Line 22:
!ERROR<br />
!ERROR<br />
!''PASS''/'''fail'''<br />
!''PASS''/'''fail'''<br />
|-align=left
|0<br />
|Subpages template works when present<br />
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 23 November 2020 (UTC)<br />
|none<br />
|''PASS''<br />


|-align=left
|-align=left
Line 27: Line 40:
|2<br />
|2<br />
|Check article history for edit just made<br />
|Check article history for edit just made<br />
|&nbsp;<br />
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 23 November 2020 (UTC)<br />
|&nbsp;<br />
|none<br />
|&nbsp;<br />
|''PASS''<br />


|-align=left
|-align=left
Line 92: Line 105:
|Test the Forum<br />
|Test the Forum<br />
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 18:22, 27 November 2020 (UTC)<br />
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 18:22, 27 November 2020 (UTC)<br />
|I edited the Style forum, but home page of Forum did not show that mine was the last edit.<br />
|I edited the Style forum, but home page of Forum did not show that mine was the last edit.
''This kind of edit shows up later and seems to be quicker when logged-in.<br />Same thing often happens on the existing wiki. [[User:John Stephenson|John Stephenson]] ([[User talk:John Stephenson|talk]]) 19:37, 28 November 2020 (UTC)''
|'''fail'''<br />
|'''fail'''<br />


Line 112: Line 126:
|12<br />
|12<br />
|Test [[Special:ListUsers]]<br />
|Test [[Special:ListUsers]]<br />
|&nbsp;<br />
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 23 November 2020 (UTC)<br />
|&nbsp;<br />
| [2af9157e969f07cd5ec8211c] /index.php/Special:ListUsers Wikimedia\Rdbms\DBQueryError from line 1603
|&nbsp;<br />
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) <br />
|'''fail'''<br />


|-align=left
|-align=left
|13<br />
|13<br />
|Test [[Special:ActiveUsers]]<br />
|Test [[Special:ActiveUsers]]<br />
|&nbsp;<br />
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 23 November 2020 (UTC)<br />
|&nbsp;<br />
| A database query error has occurred. This may indicate a bug in the software.
|&nbsp;<br />
[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}<br />
|'''fail'''<br />


|-align=left
|-align=left
Line 140: Line 206:
|16<br />
|16<br />
|Mouse over link to an existing article.  Pop-up should show the /Definition contents (if any).<br />
|Mouse over link to an existing article.  Pop-up should show the /Definition contents (if any).<br />
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 23 November 2020 (UTC)<br />
|Mousing over a link to an existing article, I only see the article name and not the /Definition page (if one exists)<br />
|'''fail'''<br />
|-align=left
|17<br />
|Do "[[:Template:R|R]]" and "[[:Template:Rpl|Rpl]]" templates on Disambig page and Related Articles tabs display definitions correctly?<br />
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 23 November 2020 (UTC)<br />
|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<br />
|'''fail'''<br />
|-align=left
|18<br />
|Test the watchlist.  Can a user manually change it?  Do page changes emailing "watching" users?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
|-align=left
|19<br />
|Can we block a user?<br />
|[[User:John Stephenson|John Stephenson]] ([[User talk:John Stephenson|talk]]) 19:44, 28 November 2020 (UTC)<br />
|[bcf907776095084e265129f4] /index.php/Special:Block/Citizendium_Technical Wikimedia\Rdbms\DBQueryError from line 1603 of /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php: <br />A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: INSERT INTO "ipblocks" (ipb_address,ipb_user,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_range_start,ipb_range_end,ipb_deleted,ipb_block_email,ipb_allow_usertalk,ipb_parent_block_id,ipb_sitewide,ipb_reason_id,ipb_by_actor) VALUES ('Citizendium Technical','34436','2020-11-28 19:39:00+00',0,0,1,0,'infinity','','','0',1,0,NULL,1,'2903','507') ON CONFLICT DO NOTHING
Function: MediaWiki\Block\DatabaseBlock::insert
Error: 42804 ERROR: column "ipb_sitewide" is of type boolean but expression is of type integer
LINE 1: ...9:39:00+00',0,0,1,0,'infinity','','','0',1,0,NULL,1,'2903','...
^
HINT: You will need to rewrite or cast the expression.
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/DatabasePostgres.php(586): Wikimedia\Rdbms\Database->query()
#3 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\DatabasePostgres->insert()
#4 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DBConnRef.php(371): Wikimedia\Rdbms\DBConnRef->__call()
#5 /var/www/czdev/mediawiki/includes/block/DatabaseBlock.php(516): Wikimedia\Rdbms\DBConnRef->insert()
#6 /var/www/czdev/mediawiki/includes/specials/SpecialBlock.php(929): MediaWiki\Block\DatabaseBlock->insert()
#7 /var/www/czdev/mediawiki/includes/specials/SpecialBlock.php(1254): SpecialBlock::processForm()
#8 /var/www/czdev/mediawiki/includes/htmlform/HTMLForm.php(690): SpecialBlock->onSubmit()
#9 /var/www/czdev/mediawiki/includes/htmlform/HTMLForm.php(582): HTMLForm->trySubmit()
#10 /var/www/czdev/mediawiki/includes/htmlform/HTMLForm.php(597): HTMLForm->tryAuthorizedSubmit()
#11 /var/www/czdev/mediawiki/includes/specialpage/FormSpecialPage.php(185): HTMLForm->show()
#12 /var/www/czdev/mediawiki/includes/specialpage/SpecialPage.php(575): FormSpecialPage->execute()
#13 /var/www/czdev/mediawiki/includes/specialpage/SpecialPageFactory.php(611): SpecialPage->run()
#14 /var/www/czdev/mediawiki/includes/MediaWiki.php(296): MediaWiki\Special\SpecialPageFactory->executePath()
#15 /var/www/czdev/mediawiki/includes/MediaWiki.php(900): MediaWiki->performRequest()
#16 /var/www/czdev/mediawiki/includes/MediaWiki.php(527): MediaWiki->main()
#17 /var/www/czdev/mediawiki/index.php(44): MediaWiki->run()
#18 {main}<br />
|'''fail'''<br />
|-align=left
|20<br />
|Can we unblock a user?<br />
|[[User:John Stephenson|John Stephenson]] ([[User talk:John Stephenson|talk]]) 19:47, 28 November 2020 (UTC)<br />
|[fc42b12ae814ba926dab287d] /index.php/Special:Unblock/CZ_Tester_2020 Wikimedia\Rdbms\DBQueryError from line 1603 of /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php: <br />A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: DELETE FROM "ipblocks_restrictions" WHERE ir_ipb_id IN (SELECT ipb_id FROM "ipblocks" WHERE ipb_parent_block_id = '2313')
Function: MediaWiki\Block\BlockRestrictionStore::deleteByParentBlockId
Error: 42P01 ERROR: relation "ipblocks_restrictions" does not exist
LINE 1: ...kRestrictionStore::deleteByParentBlockId */ FROM "ipblocks_...
^
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(2993): Wikimedia\Rdbms\Database->query()
#3 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->deleteJoin()
#4 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DBConnRef.php(506): Wikimedia\Rdbms\DBConnRef->__call()
#5 /var/www/czdev/mediawiki/includes/block/BlockRestrictionStore.php(287): Wikimedia\Rdbms\DBConnRef->deleteJoin()
#6 /var/www/czdev/mediawiki/includes/block/DatabaseBlock.php(482): MediaWiki\Block\BlockRestrictionStore->deleteByParentBlockId()
#7 /var/www/czdev/mediawiki/includes/specials/SpecialUnblock.php(225): MediaWiki\Block\DatabaseBlock->delete()
#8 /var/www/czdev/mediawiki/includes/specials/SpecialUnblock.php(170): SpecialUnblock::processUnblock()
#9 /var/www/czdev/mediawiki/includes/htmlform/HTMLForm.php(690): SpecialUnblock::processUIUnblock()
#10 /var/www/czdev/mediawiki/includes/htmlform/HTMLForm.php(582): HTMLForm->trySubmit()
#11 /var/www/czdev/mediawiki/includes/htmlform/HTMLForm.php(597): HTMLForm->tryAuthorizedSubmit()
#12 /var/www/czdev/mediawiki/includes/specials/SpecialUnblock.php(72): HTMLForm->show()
#13 /var/www/czdev/mediawiki/includes/specialpage/SpecialPage.php(575): SpecialUnblock->execute()
#14 /var/www/czdev/mediawiki/includes/specialpage/SpecialPageFactory.php(611): SpecialPage->run()
#15 /var/www/czdev/mediawiki/includes/MediaWiki.php(296): MediaWiki\Special\SpecialPageFactory->executePath()
#16 /var/www/czdev/mediawiki/includes/MediaWiki.php(900): MediaWiki->performRequest()
#17 /var/www/czdev/mediawiki/includes/MediaWiki.php(527): MediaWiki->main()
#18 /var/www/czdev/mediawiki/index.php(44): MediaWiki->run()
#19 {main}<br />
|'''fail'''<br />
|-align=left
|21<br />
|Can we add a user?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
|-align=left
|22<br />
|Can we upload an image?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
Line 145: Line 310:


|-align=left
|-align=left
|17<br />
|23<br />
|Do "[[:Template:R|R]]" and "[[:Template:Rpl|Rpl]]" templates on Disambig page and Related Articles tabs display definitions correctly?<br />
|Can we replace an image?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
Line 158: Line 323:
== List of tests to add to empty grid (at bottom) ==
== List of tests to add to empty grid (at bottom) ==


(nothing here right now)
For adding to the empty table:
* tbd
* tbd


==Empty test grid ==
==Empty test grid ==
Line 169: Line 336:


|-align=left
|-align=left
|#<br />
!#<br />
|WHAT<br />
!WHAT<br />
|WHO/WHEN<br />
!WHO/WHEN<br />
|ERROR<br />
!ERROR<br />
|''PASS''/'''FAIL'''<br />
!''PASS''/'''FAIL'''<br />
 
|-align=left
|0<br />
|Subpages template works when present<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />


|-align=left
|-align=left
Line 296: Line 470:
|-align=left
|-align=left
|18<br />
|18<br />
|Test the watchlist.  Can a user manually change it?  Do page changes emailing "watching" users?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
|-align=left
|19<br />
|Can we block a user?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
|-align=left
|20<br />
|Can we unblock a user?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
|-align=left
|21<br />
|Can we add a user?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
|-align=left
|22<br />
|Can we upload an image?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
|-align=left
|23<br />
|Can we replace an image?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
|-align=left
|24<br />
|tbd<br />
|tbd<br />
|&nbsp;<br />
|&nbsp;<br />
Line 302: Line 518:


|-align=left
|-align=left
|19<br />
|25<br />
|tbd<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|26<br />
|tbd<br />
|tbd<br />
|&nbsp;<br />
|&nbsp;<br />

Latest revision as of 13:47, 28 November 2020

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 add:

  • tbd
  • tbd
Things to test after a Wikimedia upgrade
#
 WHAT
 WHO/WHEN
 ERROR
 PASS/fail
0
 Subpages template works when present
 Pat Palmer (talk) 23 November 2020 (UTC)
 none
 PASS
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.

This kind of edit shows up later and seems to be quicker when logged-in.
Same thing often happens on the existing wiki. John Stephenson (talk) 19:37, 28 November 2020 (UTC)

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
18
 Test the watchlist. Can a user manually change it? Do page changes emailing "watching" users?
  
  
  


19
 Can we block a user?
 John Stephenson (talk) 19:44, 28 November 2020 (UTC)
 [bcf907776095084e265129f4] /index.php/Special:Block/Citizendium_Technical 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: INSERT INTO "ipblocks" (ipb_address,ipb_user,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_range_start,ipb_range_end,ipb_deleted,ipb_block_email,ipb_allow_usertalk,ipb_parent_block_id,ipb_sitewide,ipb_reason_id,ipb_by_actor) VALUES ('Citizendium Technical','34436','2020-11-28 19:39:00+00',0,0,1,0,'infinity',,,'0',1,0,NULL,1,'2903','507') ON CONFLICT DO NOTHING Function: MediaWiki\Block\DatabaseBlock::insert Error: 42804 ERROR: column "ipb_sitewide" is of type boolean but expression is of type integer LINE 1: ...9:39:00+00',0,0,1,0,'infinity',,,'0',1,0,NULL,1,'2903','... ^ HINT: You will need to rewrite or cast the expression.

Backtrace:

  1. 0 /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
  2. 1 /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError()
  3. 2 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DatabasePostgres.php(586): Wikimedia\Rdbms\Database->query()
  4. 3 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\DatabasePostgres->insert()
  5. 4 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DBConnRef.php(371): Wikimedia\Rdbms\DBConnRef->__call()
  6. 5 /var/www/czdev/mediawiki/includes/block/DatabaseBlock.php(516): Wikimedia\Rdbms\DBConnRef->insert()
  7. 6 /var/www/czdev/mediawiki/includes/specials/SpecialBlock.php(929): MediaWiki\Block\DatabaseBlock->insert()
  8. 7 /var/www/czdev/mediawiki/includes/specials/SpecialBlock.php(1254): SpecialBlock::processForm()
  9. 8 /var/www/czdev/mediawiki/includes/htmlform/HTMLForm.php(690): SpecialBlock->onSubmit()
  10. 9 /var/www/czdev/mediawiki/includes/htmlform/HTMLForm.php(582): HTMLForm->trySubmit()
  11. 10 /var/www/czdev/mediawiki/includes/htmlform/HTMLForm.php(597): HTMLForm->tryAuthorizedSubmit()
  12. 11 /var/www/czdev/mediawiki/includes/specialpage/FormSpecialPage.php(185): HTMLForm->show()
  13. 12 /var/www/czdev/mediawiki/includes/specialpage/SpecialPage.php(575): FormSpecialPage->execute()
  14. 13 /var/www/czdev/mediawiki/includes/specialpage/SpecialPageFactory.php(611): SpecialPage->run()
  15. 14 /var/www/czdev/mediawiki/includes/MediaWiki.php(296): MediaWiki\Special\SpecialPageFactory->executePath()
  16. 15 /var/www/czdev/mediawiki/includes/MediaWiki.php(900): MediaWiki->performRequest()
  17. 16 /var/www/czdev/mediawiki/includes/MediaWiki.php(527): MediaWiki->main()
  18. 17 /var/www/czdev/mediawiki/index.php(44): MediaWiki->run()
  19. 18 {main}
 fail
20
 Can we unblock a user?
 John Stephenson (talk) 19:47, 28 November 2020 (UTC)
 [fc42b12ae814ba926dab287d] /index.php/Special:Unblock/CZ_Tester_2020 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: DELETE FROM "ipblocks_restrictions" WHERE ir_ipb_id IN (SELECT ipb_id FROM "ipblocks" WHERE ipb_parent_block_id = '2313') Function: MediaWiki\Block\BlockRestrictionStore::deleteByParentBlockId Error: 42P01 ERROR: relation "ipblocks_restrictions" does not exist LINE 1: ...kRestrictionStore::deleteByParentBlockId */ FROM "ipblocks_... ^

Backtrace:

  1. 0 /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
  2. 1 /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError()
  3. 2 /var/www/czdev/mediawiki/includes/libs/rdbms/database/Database.php(2993): Wikimedia\Rdbms\Database->query()
  4. 3 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->deleteJoin()
  5. 4 /var/www/czdev/mediawiki/includes/libs/rdbms/database/DBConnRef.php(506): Wikimedia\Rdbms\DBConnRef->__call()
  6. 5 /var/www/czdev/mediawiki/includes/block/BlockRestrictionStore.php(287): Wikimedia\Rdbms\DBConnRef->deleteJoin()
  7. 6 /var/www/czdev/mediawiki/includes/block/DatabaseBlock.php(482): MediaWiki\Block\BlockRestrictionStore->deleteByParentBlockId()
  8. 7 /var/www/czdev/mediawiki/includes/specials/SpecialUnblock.php(225): MediaWiki\Block\DatabaseBlock->delete()
  9. 8 /var/www/czdev/mediawiki/includes/specials/SpecialUnblock.php(170): SpecialUnblock::processUnblock()
  10. 9 /var/www/czdev/mediawiki/includes/htmlform/HTMLForm.php(690): SpecialUnblock::processUIUnblock()
  11. 10 /var/www/czdev/mediawiki/includes/htmlform/HTMLForm.php(582): HTMLForm->trySubmit()
  12. 11 /var/www/czdev/mediawiki/includes/htmlform/HTMLForm.php(597): HTMLForm->tryAuthorizedSubmit()
  13. 12 /var/www/czdev/mediawiki/includes/specials/SpecialUnblock.php(72): HTMLForm->show()
  14. 13 /var/www/czdev/mediawiki/includes/specialpage/SpecialPage.php(575): SpecialUnblock->execute()
  15. 14 /var/www/czdev/mediawiki/includes/specialpage/SpecialPageFactory.php(611): SpecialPage->run()
  16. 15 /var/www/czdev/mediawiki/includes/MediaWiki.php(296): MediaWiki\Special\SpecialPageFactory->executePath()
  17. 16 /var/www/czdev/mediawiki/includes/MediaWiki.php(900): MediaWiki->performRequest()
  18. 17 /var/www/czdev/mediawiki/includes/MediaWiki.php(527): MediaWiki->main()
  19. 18 /var/www/czdev/mediawiki/index.php(44): MediaWiki->run()
  20. 19 {main}
 fail
21
 Can we add a user?
  
  
  
22
 Can we upload an image?
  
  
  
23
 Can we replace an image?
  
  
  

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

For adding to the empty table:

  • tbd
  • tbd

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
0
 Subpages template works when present
  
  
  
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
 Can we block a user?
  
  
  
20
 Can we unblock a user?
  
  
  
21
 Can we add a user?
  
  
  
22
 Can we upload an image?
  
  
  
23
 Can we replace an image?
  
  
  
24
 tbd
  
  
  
25
 tbd
  
  
  
26
 tbd
  
  
  
Retrieved from "https://citizendium.org/wiki/index.php?title=CZ:Technical/Upgrades&oldid=777739"