X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FWorker%2FExpire.php;h=7c304a5b249227f5bcb11a3e4313107993128e02;hb=bf8fb215a9cc554b5ec5b774168a52fb56fa43e6;hp=e1e671532b40111bd7e218c4e1191b6b44b22253;hpb=097620b62799c96d610d73410ec07a6b8cdf82f0;p=friendica.git

diff --git a/src/Worker/Expire.php b/src/Worker/Expire.php
index e1e671532b..7c304a5b24 100644
--- a/src/Worker/Expire.php
+++ b/src/Worker/Expire.php
@@ -43,19 +43,15 @@ class Expire
 			Logger::log('Delete expired items', Logger::DEBUG);
 			// physically remove anything that has been deleted for more than two months
 			$condition = ["`deleted` AND `changed` < UTC_TIMESTAMP() - INTERVAL 60 DAY"];
-			$rows = DBA::select('item', ['id'],  $condition);
+			$rows = DBA::select('item', ['id', 'guid'],  $condition);
 			while ($row = DBA::fetch($rows)) {
+				Logger::info('Delete expired item', ['id' => $row['id'], 'guid' => $row['guid']]);
 				DBA::delete('item', ['id' => $row['id']]);
 			}
 			DBA::close($rows);
 
 			// Normally we shouldn't have orphaned data at all.
 			// If we do have some, then we have to check why.
-			Logger::log('Deleting orphaned item activities - start', Logger::DEBUG);
-			$condition = ["NOT EXISTS (SELECT `iaid` FROM `item` WHERE `item`.`iaid` = `item-activity`.`id`)"];
-			DBA::delete('item-activity', $condition);
-			Logger::log('Orphaned item activities deleted: ' . DBA::affectedRows(), Logger::DEBUG);
-
 			Logger::log('Deleting orphaned item content - start', Logger::DEBUG);
 			$condition = ["NOT EXISTS (SELECT `icid` FROM `item` WHERE `item`.`icid` = `item-content`.`id`)"];
 			DBA::delete('item-content', $condition);