521512 - Run SQL patch from bug 520640 on support-stage

Status: RESOLVED FIXED

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

Description

[James Socol [:jsocol, :james]]

That'd be this patch: https://bugzilla.mozilla.org/attachment.cgi?id=405301

Comment 1

[Shyam Mani [:fox2mike]]

mysql> INSERT INTO tiki_urlt_regex_out (regexid,regex_left,regex_right) VALUES
    -> (95,'^\\/?tiki-view_forum.php\\?locale=([\\-a-zA-Z]+)&(?:amp;)?forumId=([0-9]+)(?:&(?:amp;)?(.*))?$','/$1/forum/$2?$3');
Query OK, 1 row affected (0.00 sec)

mysql> 
mysql> UPDATE tiki_urlt_regex_out SET regex_left = '^\\/?tiki-view_forum_thread\\.php\\?comments_parentId=([0-9]+)&(?:amp;)?forumId=([0-9]+)(?:(?:&(?:amp;)?)(.*))?$', regex_right = '/en-US/forum/$2/$1?$3' WHERE regexid = 90;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0