Run SQL from bug 547846 on mobile-support-stage

RESOLVED FIXED

Status

mozilla.org Graveyard
Server Operations
--
major
RESOLVED FIXED
8 years ago
3 years ago

People

(Reporter: jsocol, Assigned: chizu)

Tracking

Details

(Reporter)

Description

8 years ago
Please run the SQL from bug 547846 on the mobile-support-stage database.

https://bug547846.bugzilla.mozilla.org/attachment.cgi?id=432913

Thanks!
(Reporter)

Updated

8 years ago
Blocks: 547846
(Assignee)

Updated

8 years ago
Assignee: server-ops → thardcastle
(Assignee)

Comment 1

8 years ago
mysql> --
mysql> -- Dumping data for table `tiki_polls`
mysql> --
mysql> -- WHERE:  pollId = 6508
mysql> 
mysql> LOCK TABLES `tiki_polls` WRITE;
Query OK, 0 rows affected (0.00 sec)

mysql> /*!40000 ALTER TABLE `tiki_polls` DISABLE KEYS */;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO `tiki_polls` VALUES (6508,'Firefox Support Forum',0,'o',1222300800,60,3,1);
Query OK, 1 row affected (0.01 sec)

mysql> /*!40000 ALTER TABLE `tiki_polls` ENABLE KEYS */;
Query OK, 0 rows affected (0.00 sec)

mysql> UNLOCK TABLES;
Query OK, 0 rows affected (0.00 sec)

mysql> -- Dumping data for table `tiki_poll_options`
mysql> --
mysql> -- WHERE:  pollId = 6508
mysql> 
mysql> LOCK TABLES `tiki_poll_options` WRITE;
Query OK, 0 rows affected (0.00 sec)

mysql> /*!40000 ALTER TABLE `tiki_poll_options` DISABLE KEYS */;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO `tiki_poll_options` VALUES (6508,19847,'1',1,0),(6508,19848,'2',2,0),(6508,19849,'3',3,0),(6508,19850,'4',4,0),(6508,19851,'5',5,0);
Query OK, 5 rows affected (0.04 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> /*!40000 ALTER TABLE `tiki_poll_options` ENABLE KEYS */;
Query OK, 0 rows affected (0.01 sec)

mysql> UNLOCK TABLES;
Query OK, 0 rows affected (0.00 sec)
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.