407770 - update users on newsfx with chances since last update

Status: RESOLVED FIXED

(Websites Graveyard :: spreadfirefox.com, defect)

Description

[Asa Dotzler [:asa]]

Before we make the new spreadfirefox site _the_ spreadfirefox site, bug 407769, we'll need to update users on the new site. Right now, the new site has users up through a month or two ago when we opened up to alpha testers.

Comment 1

[Paul Booker]

Here is whati think needs to be done :

1. Stop further accounts being generated on SFX
2. Compile a list of new accounts that have been added to SFX since we exported a copy to SFX2 (ie user , and email address) . I don't have access to databases so i would need a list of 'user_id' on SFX that correspond to the new accounts on SFX that need to be setup on SFX2 
3  Run a script(s) that will auto create the additional accounts on SFX2 sandbox and later on production 

Ill now,
1. Investigate what records are written when drupal creates a new user account. 2. I'll then start writing the script(s). 

Paul


 

Comment 2

[Paul Booker]

If you would export the records as a little table that would be good for me.

Thanks Paul

Comment 3

[Paul Booker]

I have written a small script which will create the new records for SFX2 given a table 'additional_users' with fields 'name','pass','mail' and 'status'

<?php

/**
 * @file
 */

include_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);


// Generate the array  $additional_user
$result = db_query("SELECT name,pass,mail FROM {additional_users}");
$additional_users = db_fetch_object($result);
 
// Append the additional users.
foreach ( $additional_users as $additional_user) {
	 
$uid = db_next_id('{users}_uid');

db_query("INSERT INTO {users} ('uid','name','pass','mail','status') VALUES (%d,'%s','%s','%s',%d)", $uid ,$additional_user['name'] ,$additional_user['pass'] ,$additional_user['mail'],1);
db_query("INSERT INTO {users_roles} (uid, rid) VALUES (%d, %d)", $additional_user['uid'],DRUPAL_AUTHENTICATED_RID );

}

Awaiting :
1.confirmation that were no longer generating new account records on SFX
2.mysqldump of additional users as described above

Ill then test the above script on SFX2 sandbox .

Thanks Paul

Comment 4

[Paul Booker]

If you feel that this will be quicker to do on mysql directly . Then please go ahead and do so.

Thanks Paul

Comment 5

[Asa Dotzler [:asa]]

OK. We're very, very close here and I'd like for us to do the transition this wednesday, December 19th. The transition is this bug and bug 407769

Comment 6

[Asa Dotzler [:asa]]

Sounds like this is fixed. Paul@glaxstar, can you confirm that we have migrated users from the old sfx to the new?

Comment 7

[Paul Booker]

Asa , the users have been migrated sucessfully .