Profile fields don't get picked up by views if serialized before conversion

Moved from Node Profile. It didn't belong there.

This appears to be related to a Drupal core bug that is being fixed in 5.2.

See http://drupal.org/node/119114

Well, here's one way to "fix" the problem, but it may not be the most efficient. Just put it into a node with php filter assigned and visit the node. One word of warning, though: if you have notify set to, er, notify folks (like the site administrator) when a user edits their profile, this snippet will generate an email for each user FOR EACH CATEGORY. So, if you have 1000 users and 10 categories of information on their profile page, you are looking for 10000 emails each time you run this code. YOU HAVE BEEN WARNED - if I knew of a way to set notify off temporarily, I would do that (disable the SMTP settings might work). In any event, here it is:

$categories = profile_categories();

  $output .= "Starting user profile update";
// next line can be modified if you want to just run one first as a test
  $result = db_query("SELECT uid FROM {users} WHERE uid>1 AND uid<10000");
  $list = array();
  while ($record = db_fetch_object($result)) {
    if ($record->uid == 0) continue;
    $account = user_load(array('uid' => $record->uid));
    profile_load_profile($account);

    $userdata = db_query("SELECT data FROM {users} WHERE uid = %d", $record->uid);

// The userdata fetch is different in different versions. I forget which works where, although I suspect that the one I have left uncommented is for 5.1 and the other is for 4.7.

//    $userdata = unserialize(db_fetch_object($userdata)->data);

$test = db_fetch_object($userdata);
$userdata = unserialize($test->data);

    if (!$userdata) $userdata = array();
   
    foreach ($categories as $category) {
      $data = array();
      $values = db_query("SELECT * FROM {profile_fields} pf INNER JOIN {profile_values} pv ON (pf.fid = pv.fid) WHERE pf.category = '%s' && pv.uid = %d", $category['name'], $account->uid);
      while ($value = db_fetch_object($values)) {
        $data[$value->name] =  $value->value;
      }
      $data = array_merge($data, (array)$userdata);
      user_save($account, $data, $category['name']);
    }
    $list[] = ("Updated " . theme('username', $account));
  }
  $output .= theme('item_list', $list);
  return $output;