X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FWorker%2FRemoveUnusedContacts.php;h=038376c22c925d199edca8d6d49ec13b905e63fe;hb=38cf0666bd7a6537a5a6af19b5bd6073ef12e82f;hp=850760254a7544003d210fa0d258d80ab063ba77;hpb=53d064c28382b2b444495a78aa34eead345fe446;p=friendica.git diff --git a/src/Worker/RemoveUnusedContacts.php b/src/Worker/RemoveUnusedContacts.php index 850760254a..038376c22c 100644 --- a/src/Worker/RemoveUnusedContacts.php +++ b/src/Worker/RemoveUnusedContacts.php @@ -40,7 +40,7 @@ class RemoveUnusedContacts $condition = ["`id` != ? AND `uid` = ? AND NOT `self` AND NOT `nurl` IN (SELECT `nurl` FROM `contact` WHERE `uid` != ?) AND (NOT `network` IN (?, ?, ?, ?, ?, ?) OR (`archive` AND `success_update` < ?)) AND NOT `id` IN (SELECT `author-id` FROM `post-user`) AND NOT `id` IN (SELECT `owner-id` FROM `post-user`) - AND NOT `id` IN (SELECT `causer-id` FROM `post-user`) AND NOT `id` IN (SELECT `cid` FROM `post-tag`) + AND NOT `id` IN (SELECT `causer-id` FROM `post-user` WHERE `causer-id` IS NOT NULL) AND NOT `id` IN (SELECT `cid` FROM `post-tag`) AND NOT `id` IN (SELECT `contact-id` FROM `post-user`) AND NOT `id` IN (SELECT `cid` FROM `user-contact`) AND NOT `id` IN (SELECT `cid` FROM `event`) AND NOT `id` IN (SELECT `contact-id` FROM `group_member`) AND `created` < ?", @@ -78,9 +78,9 @@ class RemoveUnusedContacts DBA::delete('post-thread-user', ['author-id' => $contact['id']]); DBA::delete('post-thread-user', ['causer-id' => $contact['id']]); - DBA::delete('contact', ['id' => $contact['id']]); + Contact::deleteById($contact['id']); if ((++$count % 1000) == 0) { - Logger::notice('In removal', ['count' => $count, 'total' => $total]); + Logger::info('In removal', ['count' => $count, 'total' => $total]); } } DBA::close($contacts);