932078 - Migrate satdav's old suggested events

Status: RESOLVED DUPLICATE of bug 914842

(Webtools Graveyard :: Air Mozilla, defect)

Description

[Peter Bengtsson [:peterbe]]

A contributor has started using another email and can't log in to the old account any more where he created suggested events. 

We need to transfer all suggested events and suggest event comments from belonging to:
[e-mail]
to instead belong to:
[e-mail]

Comment 1

[Peter Bengtsson [:peterbe]]

We can change this by running this query:


UPDATE main_suggestedevent
SET user_id=(select id from auth_user where email='[e-mail]')
WHERE
  user_id in (select id from auth_user where email='[e-mail]');

UPDATE main_suggestedeventcomment
SET user_id=(select id from auth_user where email='[e-mail]')
WHERE
  user_id in (select id from auth_user where email='[e-mail]');

Comment 2

[Peter Bengtsson [:peterbe]]

oops. We already had a bug filed.