New cases should no longer be occurring, but we need to fix existing cases. Please add them here with an empty check box.
- https://www.wikidata.org/wiki/User_talk:Aude
- https://www.wikidata.org/wiki/User_talk:BDavis_(WMF)
- https://www.wikidata.org/wiki/User_talk:Doror
- https://fr.wikipedia.org/wiki/Discussion_utilisateur:Robur15
You can reproduce and test the issue that the script is intended to fix with:
- Create a Flow board
- Do an UPDATE adding '/Flow_Archive_1' to workflow_title_text in the flow_workflow table. E.g.: UPDATE flow_workflow SET workflow_title_text = 'Test_2016-12-01/Flow_Archive_1' WHERE workflow_title_text = 'Test_2016-12-01';
- Bump $wgFlowCacheVersion.
- Run the script (for all namespaces, or including that namespace). E.g.: mwscript extensions/Flow/maintenance/FlowFixInconsistentBoards.php --wiki=wiki
You should see one or more INCONSISTENT lines, and then an indication that they are fixed. When you query, it should be back to the original title text: SELECT * FROM flow_workflow WHERE workflow_title_text = 'Test_2016-12-01';
Template for manual fixes until we have the script.
To cross-check affected workflows:
SELECT workflow_wiki, workflow_namespace, workflow_title_text, workflow_page_id, HEX(workflow_id) FROM flow_workflow WHERE workflow_wiki = '<>' AND workflow_namespace = 3 AND workflow_title_text = '<>/Flow_Archive_1';
To update:
UPDATE flow_workflow SET workflow_title_text = '' WHERE HEX(workflow_id) IN ('') AND workflow_wiki = '' AND workflow_namespace = 3 AND workflow_title_text = '';- beta foreachwiki
- beta enwiki and en_rtlwiki
- production dry run
- production one-off non-dry run script with limit (just in case of surprises) (https://fr.wikipedia.org/wiki/Discussion_utilisateur:Jucarl86 and https://www.mediawiki.org/wiki/User_talk:Wikimech_org/Flow_Archive_1)
- production run