P1. Fix problems with importing translatewiki.net Support page
Closed, ResolvedPublic5 Estimated Story Points
Actions

Description

Fix importer script problems exposed by importing the TranslateWiki.Net support page.

Already implemented in general (file tasks about specific issues if found, and not already present):

Preserve content
Preserve all subscriptions
Preserve all thread summaries
Preserve history of threads and summaries
Preserve LQT logs for antivandalism purposes (history is preserved, other logs will remain in the logging table, but if logs are specifically an issue, we should file another task to investigate how accessible the old LQT logs would be with LQT not installed).

Details

	Subject	Repo	Branch	Lines +/-
	Record topic imports to Special:Log	mediawiki/extensions/Flow	master	+161 -9

Customize query in gerrit

Related Objects
Search...

Status	Assigned	Task
Resolved	• DannyH	T171977 Annual Plan 2017-2018, Audiences 5: Increase current editor retention and engagement
Resolved	• DannyH	T171982 Annual Plan 2017-2018, Audiences 5, Goal 3: Provide better workflow and communication experiences
Open	None	T167928 Improve structured discussion features for the communities that use them, based on user feedback and prioritising technical debt
Open	None	T89426 Allow to uninstall all LiquidThreads code except the parts necessary for the remaining content, to be moved into (?)WikimediaMessages
Resolved	Catrope	T106302 Convert LQT->Flow on se.wikimedia.org
Resolved	• Mattflaschen-WMF	T92303 Convert LQT pages on MediaWiki.org to Flow (tracking)
Resolved	• Mattflaschen-WMF	T85816 Enable Flow for talkpage for Extension:MobileFrontend on mediawiki.org (convert from LQT)
Invalid	Nemo_bis	T88102 Consider possibility of enabling Flow on translatewiki.net
Resolved	None	T47088 Create a script to extract all data from LiquidThreads and import into Flow
Resolved	EBernhardson	T87795 P1. Fix problems with importing translatewiki.net Support page

Event Timeline

• Mattflaschen-WMF created this task.Jan 28 2015, 8:22 PM

• Mattflaschen-WMF raised the priority of this task from to Needs Triage.

• Mattflaschen-WMF updated the task description. (Show Details)

• Mattflaschen-WMF added a project: Collaboration-Team-Sprint-P-2015-02-11/q3.

• Mattflaschen-WMF subscribed.

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 28 2015, 8:22 PM

• Mattflaschen-WMF renamed this task from Figure out problem with importing TranslateWiki Support page to [5] Fix problems with importing TranslateWiki Support page.Jan 28 2015, 8:22 PM

• Mattflaschen-WMF set Security to None.

• Mattflaschen-WMF edited a custom field.

Aklapper added a project: translatewiki.net.Jan 29 2015, 5:44 PM

Nikerabbit renamed this task from [5] Fix problems with importing TranslateWiki Support page to [5] Fix problems with importing translatewiki.net Support page.Jan 30 2015, 3:08 AM

Nikerabbit moved this task from Backlog to External on the translatewiki.net board.Jan 30 2015, 3:10 AM

Nemo_bis removed a project: translatewiki.net.Jan 30 2015, 12:15 PM

Nemo_bis added a parent task: T88102: Consider possibility of enabling Flow on translatewiki.net.

Nemo_bis renamed this task from [5] Fix problems with importing translatewiki.net Support page to [5] Fix problems with importing translatewiki.net Support page and other LQT threads.Jan 30 2015, 12:20 PM

Nemo_bis updated the task description. (Show Details)

Nemo_bis added a parent task: T47088: Create a script to extract all data from LiquidThreads and import into Flow.Jan 30 2015, 1:07 PM

• DannyH renamed this task from [5] Fix problems with importing translatewiki.net Support page and other LQT threads to [5] P1. Fix problems with importing translatewiki.net Support page and other LQT threads.Jan 30 2015, 6:37 PM

All seemed similar on translatewiki's end. This is what they were getting:

2015-01-28 01:17:29 translatewiki.net translatewiki_net-bw_:
[0d09c70a] /w/api.php?action=query&list=threads&thprop=id%7Csubject%7Cpage%7Cparent%7Cancestor%7Ccreated%7Cmodified%7Cauthor%7Csummaryid%7Ctype%7Crootid%7Creplies&format=json&limit=500&thid=1195
 MWException from line 2170 of
/srv/mediawiki/tags/2015-01-23_18:23:22/includes/db/Database.php:
DatabaseBase::makeList: empty input for field thread_parent
#0 /srv/mediawiki/tags/2015-01-23_18:23:22/includes/db/Database.php(1743):
DatabaseBase->makeList(Array, 1)
#1 /srv/mediawiki/tags/2015-01-23_18:23:22/includes/db/Database.php(1691):
DatabaseBase->selectSQLText('thread', Array, Array,
'ApiQueryLQTThre...', Array, Array)
#2 /srv/mediawiki/tags/2015-01-23_18:23:22/extensions/LiquidThreads/api/ApiQueryLQTThreads.php(183):
DatabaseBase->select('thread', Array, Array, 'ApiQueryLQTThre...')
#3 /srv/mediawiki/tags/2015-01-23_18:23:22/extensions/LiquidThreads/api/ApiQueryLQTThreads.php(164):
ApiQueryLQTThreads->addSubItems('thread', 'thread_id',
'thread_parent', 'replies', Object(Closure), 'reply')
#4 /srv/mediawiki/tags/2015-01-23_18:23:22/includes/api/ApiQuery.php(297):
ApiQueryLQTThreads->execute()
#5 /srv/mediawiki/tags/2015-01-23_18:23:22/includes/api/ApiMain.php(1024):
ApiQuery->execute()
#6 /srv/mediawiki/tags/2015-01-23_18:23:22/includes/api/ApiMain.php(393):
ApiMain->executeAction()
#7 /srv/mediawiki/tags/2015-01-23_18:23:22/includes/api/ApiMain.php(364):
ApiMain->executeActionWithErrorHandling()
#8 /srv/mediawiki/tags/2015-01-23_18:23:22/api.php(84): ApiMain->execute()
#9 {main}

2015-01-28 01:19:22 translatewiki.net translatewiki_net-bw_:
[5386f7db] /w/api.php?action=query&list=threads&thprop=id%7Csubject%7Cpage%7Cparent%7Cancestor%7Ccreated%7Cmodified%7Cauthor%7Csummaryid%7Ctype%7Crootid%7Creplies&format=json&limit=500&thid=2035
 MWException from line 2170 of
/srv/mediawiki/tags/2015-01-23_18:23:22/includes/db/Database.php:
DatabaseBase::makeList: empty input for field thread_parent
#0 /srv/mediawiki/tags/2015-01-23_18:23:22/includes/db/Database.php(1743):
DatabaseBase->makeList(Array, 1)
#1 /srv/mediawiki/tags/2015-01-23_18:23:22/includes/db/Database.php(1691):
DatabaseBase->selectSQLText('thread', Array, Array,
'ApiQueryLQTThre...', Array, Array)
#2 /srv/mediawiki/tags/2015-01-23_18:23:22/extensions/LiquidThreads/api/ApiQueryLQTThreads.php(183):
DatabaseBase->select('thread', Array, Array, 'ApiQueryLQTThre...')
#3 /srv/mediawiki/tags/2015-01-23_18:23:22/extensions/LiquidThreads/api/ApiQueryLQTThreads.php(164):
ApiQueryLQTThreads->addSubItems('thread', 'thread_id',
'thread_parent', 'replies', Object(Closure), 'reply')
#4 /srv/mediawiki/tags/2015-01-23_18:23:22/includes/api/ApiQuery.php(297):
ApiQueryLQTThreads->execute()
#5 /srv/mediawiki/tags/2015-01-23_18:23:22/includes/api/ApiMain.php(1024):
ApiQuery->execute()
#6 /srv/mediawiki/tags/2015-01-23_18:23:22/includes/api/ApiMain.php(393):
ApiMain->executeAction()
#7 /srv/mediawiki/tags/2015-01-23_18:23:22/includes/api/ApiMain.php(364):
ApiMain->executeActionWithErrorHandling()
#8 /srv/mediawiki/tags/2015-01-23_18:23:22/api.php(84): ApiMain->execute()
#9 {main}

• DannyH renamed this task from [5] P1. Fix problems with importing translatewiki.net Support page and other LQT threads to P1. Fix problems with importing translatewiki.net Support page and other LQT threads.Feb 3 2015, 6:52 PM

• DannyH assigned this task to EBernhardson.Feb 6 2015, 6:37 PM

• DannyH moved this task from Sprint P - ends Feb 11 to In Development on the Collaboration-Team-Sprint-P-2015-02-11/q3 board.

EBernhardson moved this task from In Development to Code Review on the Collaboration-Team-Sprint-P-2015-02-11/q3 board.Feb 11 2015, 7:20 PM

• DannyH added a project: Collaboration-Team-Sprint-Q-2015-02-25.Feb 11 2015, 9:23 PM

• DannyH moved this task from Sprint Q - ends Feb 25 to Code Review on the Collaboration-Team-Sprint-Q-2015-02-25 board.Feb 11 2015, 9:27 PM

Change 189909 had a related patch set uploaded (by EBernhardson):
Record topic imports to Special:Log

https://gerrit.wikimedia.org/r/189909

Patch-For-Review

We're not going to expand the scope of this task to all the things in the new description. It is specifically about fixing problems related to importing the support page (some of which apply to other pages). However, other things, like "Set up a development wiki", should be a different task.

• Mattflaschen-WMF renamed this task from P1. Fix problems with importing translatewiki.net Support page and other LQT threads to P1. Fix problems with importing translatewiki.net Support page.Feb 11 2015, 11:10 PM

• Mattflaschen-WMF updated the task description. (Show Details)

• Mattflaschen-WMF added a project: StructuredDiscussions.Feb 12 2015, 12:08 AM

EBernhardson triaged this task as Medium priority.Feb 17 2015, 6:47 PM

Change 189909 merged by jenkins-bot:
Record topic imports to Special:Log

https://gerrit.wikimedia.org/r/189909

• Mattflaschen-WMF mentioned this in rEFLW971bf9b06bf7: Record topic imports to Special:Log.Feb 18 2015, 5:11 AM

EBernhardson moved this task from Code Review to Product Review on the Collaboration-Team-Sprint-Q-2015-02-25 board.Feb 18 2015, 6:06 PM

• DannyH closed this task as Resolved.Feb 24 2015, 6:24 PM

• DannyH subscribed.

Diffusion mentioned this in rMEXT5deb24cc48c5: Updated mediawiki/extensions Project: mediawiki/extensions/Flow….Mar 11 2015, 6:26 AM