519582 - Run sql for mobile.support-stage to enable polls

Status: VERIFIED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[[:Cww]]

Attachment: tiki_poll_questions

We need to have this table populated to enable polls on mobile.support and we want it on stage to test first.

Comment 1

[[:Cww]]

Blocker because it needs to be tested prior to push (bug 519449)

Comment 2

[Derek Moore [:dmoore]]

Executed as requested.

mysql> \. ~/tiki_questions.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 6 rows affected, 2 warnings (0.00 sec)
Records: 6  Duplicates: 0  Warnings: 2

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Comment 3

[Chris Ilias [:cilias]]

How long will this take for us to see the polls on <https://mobile.support-stage.mozilla.org/tiki-admin_poll_questions.php?locale=en-US>? I still don't see polls there.

Comment 4

[Paul Craciunoiu [:paulc]]

I think this bug fixes bug 517012.

Comment 5

[[:Cww]]

Attachment: the right sql

That's because I'm an idiot and attached the wrong sql.  Man, I swear I have too many of them.

Comment 6

[Laura Thomson :laura]

(In reply to comment #5)
> Created an attachment (id=403675) [details]
> the right sql
> 
> That's because I'm an idiot and attached the wrong sql.  Man, I swear I have
> too many of them.

Do we need to roll the first one back?

Why wasn't this reviewed?

Comment 7

[Shyam Mani [:fox2mike]]

Ran the right SQL. Lemme know if you still see issues.

Comment 8

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

Verified FIXED on https://mobile.support-stage.mozilla.org/tiki-admin_poll_questions.php?locale=en-US, according to our testing tonight in #sumodev.