CZ:Technical/Upgrades: Difference between revisions

From Citizendium
Jump to navigation Jump to search
imported>Pat Palmer
mNo edit summary
imported>John Stephenson
(can't unblock user)
 
(47 intermediate revisions by 2 users not shown)
Line 1: Line 1:
* Edit existing article


* Create a new article without metadata
This is a catalog of needed '''MediaWiki software upgrade tests'''.
* Create a new article "with metadata"
** as per the second line, rightmost cell at http://czdev.dotdo.us/index.php/CZ:Start_Article ("Click here to start")
** which led to http://czdev.dotdo.us/index.php/Special:MetadataForm


* Check a User page
__TOC__
** Is history shown?
** Are recent contributions shown?


* Mouse over a link to an existing article which has a /Definition page.
== Nov 25, 2020 tests performed for test server at [http://czdev.dotdo.us/ http://czdev.dotdo.us/] ==
** Definition should pop up when link is moused over


* [[Special:ActiveUsers]]
Things to add:
* [[Special:ListUsers]]
* tbd
* tbd


* Can we delete a page (and is it logged okay)?
----
* Can we rollback a change (and is it logged okay)?
 
{|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;"
 
!align=center colspan=5 style="background:#CCFFCC"| '''Things to test after a Wikimedia upgrade'''
 
|-align=left
!#<br />
!WHAT<br />
!WHO/WHEN<br />
!ERROR<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
|1<br />
|Edit an article<br />
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 23 November 2020 (UTC)<br />
|none<br />
|''PASS''<br />


* TEMPLATES
|-align=left
** Check the list of writers at http://czdev.dotdo.us/index.php/CZ:Literature_Workgroup
|2<br />
** Do "[[:Template:R|R]]" and "[[:Template:Rpl|Rpl]]" templates on Disambig page and Related Articles tabs display definitions correctly?
|Check article history for edit just made<br />
{{rpl|Theodor Fontane||:}}
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 23 November 2020 (UTC)<br />
{{rpl|Theodor Fontane}}
|none<br />
{{r|Theodor Fontane}}
|''PASS''<br />
 
|-align=left
|3<br />
|Roll back the edit just made<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|4<br />
|Create a [[CZ:Start_Article|new article ''without'' metadata]]<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|5<br />
|Create a [[CZ:Start_Article|new article ''with'' metadata]]<br />
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 23 November 2020 (UTC)<br />
|
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}
<br />
|'''fail'''<br />
 
|-align=left
|6<br />
|Delete the new article with metadata (check delete log)<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|7<br />
|Rename the new article without metadata (check log)<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|8<br />
|Check Recent Changes for all the above<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|9<br />
|Test the Forum<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.
''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 />
 
|-align=left
|10<br />
|Are archives okay?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|11<br />
|Go to a User Page and look for User Contributions<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|12<br />
|Test [[Special:ListUsers]]<br />
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 23 November 2020 (UTC)<br />
| [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) <br />
|'''fail'''<br />
 
|-align=left
|13<br />
|Test [[Special:ActiveUsers]]<br />
|[[User:Pat Palmer|Pat Palmer]] ([[User talk:Pat Palmer|talk]]) 23 November 2020 (UTC)<br />
| 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}<br />
|'''fail'''<br />
 
|-align=left
|14<br />
|Try to change a User skin<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|15<br />
|Look at home page on mobile device<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|16<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 />
 
|-align=left
|23<br />
|Can we replace an image?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|}


----
----
----
== 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.


{|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;"


!align=center colspan=3 style="background:#CCFFCC"| '''Things to test after a Wikimedia upgrade'''
!align=center colspan=5 style="background:#CCFFCC"| '''Things to test after a Wikimedia upgrade'''
 
|-align=left
!#<br />
!WHAT<br />
!WHO/WHEN<br />
!ERROR<br />
!''PASS''/'''FAIL'''<br />


|-align=left
|-align=left
|Edit any article<br />
|0<br />
|blah<br />
|Subpages template works when present<br />
|blah<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />


|-align=left
|-align=left
|Check article history to see if edit correctly reflected<br />
|1<br />
|blah<br />
|Edit an article<br />
|blah<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />


|-align=left
|2<br />
|Check article history for edit just made<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />


|-align=left
|-align=left
|3<br />
|Roll back the edit just made<br />
|Roll back the edit just made<br />
|blah<br />
|&nbsp;<br />
|blah<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|4<br />
|Create a [[CZ:Start_Article|new article ''without'' metadata]]<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|5<br />
|Create a [[CZ:Start_Article|new article ''with'' metadata]]<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|6<br />
|Delete the new article with metadata (check delete log)<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|7<br />
|Rename the new article without metadata (check log)<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|8<br />
|Check Recent Changes for all the above<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|9<br />
|Test the Forum<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|10<br />
|Are archives okay?<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|11<br />
|Go to a User Page and look for User Contributions<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|12<br />
|Test [[Special:ListUsers]]<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|13<br />
|Test [[Special:ActiveUsers]]<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|14<br />
|Try to change a User skin<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|15<br />
|Look at home page on mobile device<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|16<br />
|Mouse over link to an existing article.  Pop-up should show the /Definition contents (if any).<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<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 />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />


|-align=left
|-align=left
|Create a new article without metadata<br />
|18<br />
|blah<br />
|Test the watchlist.  Can a user manually change it?  Do page changes emailing "watching" users?<br />
|blah<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />


|-align=left
|-align=left
|Create a new article with metadata<br />
|19<br />
|blah<br />
|Can we block a user?<br />
|blah<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />


|-align=left
|-align=left
|blah<br />
|20<br />
|blah<br />
|Can we unblock a user?<br />
|blah<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />


|-align=left
|-align=left
|blah<br />
|21<br />
|blah<br />
|Can we add a user?<br />
|blah<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />


|-align=left
|-align=left
|blah<br />
|22<br />
|blah<br />
|Can we upload an image?<br />
|blah<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 />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|25<br />
|tbd<br />
|&nbsp;<br />
|&nbsp;<br />
|&nbsp;<br />
 
|-align=left
|26<br />
|tbd<br />
|&nbsp;<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"