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?"
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)
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
While testing this, I filed bug 457492. Perhaps I caused that bug by going to tiki-poll_results.php instead of the newer one?
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.
Nelson: if we wontfix bug 457492, will that question be OK in production? i.e., did we only screw up the staging DB?
we only messed up the staging db
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".