Created attachment 10493
Feedback Page - Hidden Filter Loading Error for Obama page

Here's a screenshot showing this problem on the Obama page. I also have screenshots for Mitt Romney and Golden Sparrow, if you like.

Attached:

reha wrote:

Here's the error message from prototype:

Exception Caught: Non-string key given","*":"#0 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/includes\/GlobalFunctions.php(1426): MessageCache->get(NULL, true, Object(Language))#1 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/includes\/GlobalFunctions.php(1551): wfMsgGetKey(NULL, true, Object(Language), false)#2 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/languages\/Language.php(709): wfMsgExt(NULL, Array)#3 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/languages\/Language.php(731): Language->getMessageFromDB(NULL)#4 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/languages\/Language.php(989): Language->getMonthName(false)#5 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/languages\/Language.php(1819): Language->sprintfDate('j F Y', false)#6 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/extensions\/ArticleFeedbackv5\/api\/ApiArticleFeedbackv5Utils.php(340): Language->date('??????????????')#7 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/extensions\/ArticleFeedbackv5\/ArticleFeedbackv5.render.php(117): ApiArticleFeedbackv5Utils::renderStatusLine('autohide', '0', '??????????????')#8 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/extensions\/ArticleFeedbackv5\/api\/ApiViewFeedbackArticleFeedbackv5.php(58): ArticleFeedbackv5Render->run(Array)
#9 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/includes\/api\/ApiQuery.php(266): ApiViewFeedbackArticleFeedbackv5->execute()
#10 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/includes\/api\/ApiMain.php(705): ApiQuery->execute()
#11 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/includes\/api\/ApiMain.php(360): ApiMain->executeAction()
#12 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/includes\/api\/ApiMain.php(344): ApiMain->executeActionWithErrorHandling()
#13 \/srv\/org\/wikimedia\/prototype\/wikis\/rc\/api.php(117): ApiMain->execute()
#14 {main}

I think we must have some places in the database where "??????????????" is in the last status timestamp field.

reha wrote:

NB: the string is not actually "??????????????" but a series of characters that look like question marks.

Thanks, Reha.

Do we know which field and/or record in the DB could be causing this problem?

Is this something that could have been introduced when we ran the SQL script for adding relevance scores to older posts last week?

If so, could this be solved by asking Roan to re-run an SQL script for us?

Or is this something you could solve on your end?

Please let us know what you think can be done on our end.

reha wrote:

The problem is in the last status timestamp field, so the relevance score wouldn't have affected it. I'm afraid I don't know how to determine which rows are causing the problem -- using the binary field for a timestamp is a non-standard MediaWiki variant, and I'm not quite sure how to search for a series of messed-up unicode characters -- but Roan is much more familiar with this usage and could probably figure it out.

yoni wrote:

mike, reha - please make sure the SQL deploy script is updated and the bug is no longer reproducible.
in this case, close the bug

Sorry, I didn't see the last note from Yoni above, so I just re-opened this bug.

Also, on the off chance that fixing this bug introduced new issues, I would like to point out that we now are having $ signs show up again on the central activity log:

https://en.wikipedia.org/w/index.php?title=Special%3ALog&type=articlefeedbackv5

Not sure if it's related to the recent SQL fix by Roan, but wanted to mention it, just in case.

Oliver is opening up a separate bug for this.

reha wrote:

The log issues are unrelated. Marking fixed.