END_OF_UPGRADE_HELP;
-require_once INSTALLDIR.'/scripts/commandline.inc';
+require_once INSTALLDIR.'/scripts/commandline.inc.php';
function main()
{
if (Event::handle('StartUpgrade')) {
+ fixupConversationURIs();
+
updateSchemaCore();
updateSchemaPlugins();
initLocalGroup();
initNoticeReshare();
- initFaveURI();
initSubscriptionURI();
initGroupMemberURI();
printfnq("DONE.\n");
}
+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");
+}
+
function initGroupProfileId()
{
printfnq("Ensuring all User_group entries have a Profile and profile_id...");
printfnq("DONE.\n");
}
-function initFaveURI()
-{
- printfnq("Ensuring all faves have a URI...");
-
- $fave = new Fave();
- $fave->whereAdd('uri IS NULL');
-
- if ($fave->find()) {
- while ($fave->fetch()) {
- try {
- $fave->decache();
- $fave->query(sprintf('update fave '.
- 'set uri = "%s", '.
- ' modified = "%s" '.
- 'where user_id = %d '.
- 'and notice_id = %d',
- Fave::newURI($fave->user_id, $fave->notice_id, $fave->modified),
- common_sql_date(strtotime($fave->modified)),
- $fave->user_id,
- $fave->notice_id));
- } catch (Exception $e) {
- common_log(LOG_ERR, "Error updated fave URI: " . $e->getMessage());
- }
- }
- }
-
- printfnq("DONE.\n");
-}
-
function initSubscriptionURI()
{
printfnq("Ensuring all subscriptions have a URI...");