Closed
Bug 542025
Opened 15 years ago
Closed 15 years ago
Run query on support-stage to clear livechat_id field
Categories
(mozilla.org Graveyard :: Server Operations, task)
Tracking
(Not tracked)
RESOLVED
DUPLICATE
of bug 541982
People
(Reporter: zzxc, Assigned: oremj)
References
Details
After support-stage has been upgraded to head, a query should be run to clear any livechat_id fields from newly registered users before automatic migration starts.
The query to run is: UPDATE users_users SET livechat_id=NULL;
This query will also need to be run on production right before turning on migration, after 1.5.1 ships.
Reporter | ||
Comment 2•15 years ago
|
||
This query should be run before the automatic migration is done. (Running it after would undo the automatic migration)
Comment 3•15 years ago
|
||
So do you want it run right now, or should it wait until just before the migration?
Comment 4•15 years ago
|
||
Please re-open this if there is some pending action on our side.
Status: NEW → RESOLVED
Closed: 15 years ago
Resolution: --- → FIXED
Updated•15 years ago
|
Resolution: FIXED → INCOMPLETE
Comment 5•15 years ago
|
||
Matthew, please see comment 3.
Status: RESOLVED → REOPENED
Resolution: INCOMPLETE → ---
Reporter | ||
Comment 6•15 years ago
|
||
This query resets the login migration, so it needs to run before the migration script is executed on support-stage.
The same query will need to be executed on production before the migration happens there, but this will be a new bug.
Assignee | ||
Updated•15 years ago
|
Assignee: aravind → jeremy.orem+bugs
Assignee | ||
Comment 7•15 years ago
|
||
mysql> UPDATE users_users SET livechat_id=NULL;
Query OK, 149200 rows affected (11.86 sec)
Rows matched: 149739 Changed: 149200 Warnings: 0
Status: REOPENED → RESOLVED
Closed: 15 years ago → 15 years ago
Resolution: --- → FIXED
Assignee | ||
Updated•15 years ago
|
Resolution: FIXED → DUPLICATE
Updated•10 years ago
|
Product: mozilla.org → mozilla.org Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•