X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=update.php;h=b5d17848941bfa18994dc445454c910a72f2c799;hb=4cc52cef6b84e02687be5e306ef333060dcc8f53;hp=285252770a36090e3930655a299db8f43b2507d0;hpb=21af40b2f904a4b720342097789cd3f01905445e;p=friendica.git diff --git a/update.php b/update.php index 285252770a..b5d1784894 100644 --- a/update.php +++ b/update.php @@ -831,6 +831,18 @@ function pre_update_1377() return Update::FAILED; } + if (DBStructure::existsTable('diaspora-interaction') && !DBA::e("DELETE FROM `diaspora-interaction` WHERE `uri-id` NOT IN (SELECT `id` FROM `item-uri`)")) { + return Update::FAILED; + } + + if (DBStructure::existsTable('item-activity') && !DBA::e("DELETE FROM `item-activity` WHERE `uri-id` NOT IN (SELECT `id` FROM `item-uri`)")) { + return Update::FAILED; + } + + if (DBStructure::existsTable('item-content') && !DBA::e("DELETE FROM `item-content` WHERE `uri-id` NOT IN (SELECT `id` FROM `item-uri`)")) { + return Update::FAILED; + } + if (!DBA::e("DELETE FROM `notify` WHERE `uri-id` NOT IN (SELECT `id` FROM `item-uri`)")) { return Update::FAILED; } @@ -838,7 +850,6 @@ function pre_update_1377() if (!DBA::e("UPDATE `notify` SET `parent-uri-id` = NULL WHERE `parent-uri-id` = 0")) { return Update::FAILED; } - if (!DBA::e("DELETE FROM `notify` WHERE `parent-uri-id` NOT IN (SELECT `id` FROM `item-uri`)")) { return Update::FAILED; }