CZ:Technical/Upgrades: Difference between revisions
imported>John Stephenson (can't block user) |
imported>John Stephenson (can't unblock user) |
||
Line 259: | Line 259: | ||
#18 {main}<br /> | #18 {main}<br /> | ||
|'''fail'''<br /> | |'''fail'''<br /> | ||
|-align=left | |-align=left | ||
|20<br /> | |20<br /> | ||
|Can we unblock a user?<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 | |-align=left |
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. |
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:
|
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:
|
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 |
|
|
|