function fixupConversationURIs()
{
printfnq("Ensuring all conversations have a URI...");
$conv = new Conversation();
$conv->whereAdd('uri IS NULL');
if ($conv->find()) {
$rounds = 0;
while ($conv->fetch()) {
$uri = common_local_url('conversation', array('id' => $conv->id));
$sql = sprintf('UPDATE conversation SET uri="%1$s" WHERE id="%2$d";', $conv->escape($uri), $conv->id);
$conv->query($sql);
if (($conv->N - ++$rounds) % 500 == 0) {
printfnq(sprintf(' %d items left...', $conv->N - $rounds));
}
}
}
printfnq("DONE.\n");
}