Run SQL from bug 495740 on support-stage for testing

VERIFIED FIXED

Status

mozilla.org Graveyard
Server Operations
--
blocker
VERIFIED FIXED
9 years ago
3 years ago

People

(Reporter: zzxc, Assigned: phong)

Tracking

Details

(Reporter)

Description

9 years ago
The sql in https://bugzilla.mozilla.org/attachment.cgi?id=383979 needs to be run on support-stage ASAP so that QA can be done for tonight's SUMO 1.2 release.

Comment 1

9 years ago
This was a last minute fix, sorry for the extra pressure.
(Assignee)

Updated

9 years ago
Assignee: server-ops → phong
(Assignee)

Comment 2

9 years ago
Database changed
mysql> DROP TABLE IF EXISTS `tiki_comments_metadata`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CREATE TABLE `tiki_comments_metadata` (
    ->   `threadId` int(14) NOT NULL,
    ->   `name` varchar(255) NOT NULL,
    ->   `value` text,
    ->    PRIMARY KEY  (`threadId`, `name`)
    -> );
Query OK, 0 rows affected (0.02 sec)

mysql>
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
(Assignee)

Comment 3

9 years ago
mysql> use support_wiki ;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> DROP TABLE IF EXISTS `tiki_comments_metadata`;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CREATE TABLE `tiki_comments_metadata` (
    ->   `threadId` int(14) NOT NULL,
    ->   `name` varchar(255) NOT NULL,
    ->   `value` text,
    ->    PRIMARY KEY  (`threadId`, `name`)
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql>
Verified FIXED; this allowed my test posts in http://support-stage.mozilla.org/tiki-view_forum.php?locale=en-US&forumId=3 to go through.

(Thanks, Phong!)
Status: RESOLVED → VERIFIED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.