542025 - Run query on support-stage to clear livechat_id field

Status: RESOLVED DUPLICATE of bug 541982

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

Description

[Matthew Middleton (:zzxc)]

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.

Comment 1

[Aravind Gottipati [:aravind]]

So.. is this bug dependent on 541982 ?

Comment 2

[Matthew Middleton (:zzxc)]

This query should be run before the automatic migration is done.  (Running it after would undo the automatic migration)

Comment 3

[Dave Miller [:justdave]]

So do you want it run right now, or should it wait until just before the migration?

Comment 4

[Aravind Gottipati [:aravind]]

Please re-open this if there is some pending action on our side.

Comment 5

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

Matthew, please see comment 3.

Comment 6

[Matthew Middleton (:zzxc)]

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.

Comment 7

[Jeremy Orem [:oremj]]

mysql> UPDATE users_users SET livechat_id=NULL;


Query OK, 149200 rows affected (11.86 sec)
Rows matched: 149739  Changed: 149200  Warnings: 0