500527 - Run SQL from bug 495740 on support-stage for testing

Status: VERIFIED FIXED

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

Description

[Matthew Middleton (:zzxc)]

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

[Laura Thomson :laura]

This was a last minute fix, sorry for the extra pressure.

Comment 2

[Phong Tran [:phong]]

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>

Comment 3

[Phong Tran [:phong]]

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>

Comment 4

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

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!)