457277 - CSAT: Responses to "Was this article easy to understand?" are not appearing on tiki-poll_results.php

Status: VERIFIED FIXED

(support.mozilla.org :: Knowledge Base Software, task)

Description

[Stephen Donner [:stephend] Not actively reading bugmail]

I've been answering "No" to the "Is this article easy to understand" on http://support-stage.mozilla.org/en-US/kb/Using+Firefox and checking it out via http://support-stage.mozilla.org/tiki-poll_results.php with "All" as a filter, and I only ever see the "Did this article solve" rankings...

Steps to Reproduce:

1. Load http://support-stage.mozilla.org/en-US/kb/Using+Firefox
2. At the bottom, answer "No" to "Was this article easy to understand?"
3. Visit http://support-stage.mozilla.org/tiki-poll_results.php, and either search for "Using Firefox" via the "Find" textfield, or load all of them and CTRL+F your way to the question.

Expected Results:

Immediately after answering "No" to the above question, I should see an entry for that question, along with "No" and the count, in real-time.

Actual Results:

I only ever see counted responses for the "Did this article solve a problem you had with Firefox?"

Comment 1

[Nelson Ko [:nkoth]]

This should be fixed by running:

update tiki_polls set publishDate='1222300800' where publishDate ='1227312000'; 

Mark, can you run this on the staging database whenever possible so as to
facilitate testing by stephend on Monday? I have downgraded this bug to major
to avoid paging or any such things.

The votes are being recorded, but because the poll publishDate is set to
November, they are just not being displayed on the Poll Results page.

I tried some workaround using the polls admin interface on the site but messed
up the "Using Firefox" poll further instead (that polls admin interface needs
some updating)

Comment 2

[Mark Smith [:xb95]]

Query run on staging database.

mysql> update tiki_polls set publishDate='1222300800' where publishDate ='1227312000';
Query OK, 3640 rows affected (0.06 sec)
Rows matched: 3640  Changed: 3640  Warnings: 0

Comment 3

[Stephen Donner [:stephend] Not actively reading bugmail]

While testing this, I filed bug 457492.

Perhaps I caused that bug by going to tiki-poll_results.php instead of the newer one?

Comment 4

[Nelson Ko [:nkoth]]

tiki-poll_results.php is supposed to be used. Please do test that. As for the possible cause of bug 457492, I have commented there.

Comment 5

[Stephen Donner [:stephend] Not actively reading bugmail]

Nelson: if we wontfix bug 457492, will that question be OK in production?  i.e., did we only screw up the staging DB?

Comment 6

[Nelson Ko [:nkoth]]

we only messed up the staging db

Comment 7

[Stephen Donner [:stephend] Not actively reading bugmail]

OK; I haven't seen this with other articles, and so I've tested on rating http://support-stage.mozilla.org/en-US/kb/blah2, and seeing the results successfully up on http://support-stage.mozilla.org/tiki-poll_results.php.

Verified "FIXED".