From deedac6ae542a1ff8d599076b7e0ef344d30e1a8 Mon Sep 17 00:00:00 2001 From: friendica Date: Thu, 16 May 2013 20:21:12 -0700 Subject: workarounds for people that re-install and end up polluting everybody's databases with stale entries --- include/notifier.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'include/notifier.php') diff --git a/include/notifier.php b/include/notifier.php index 60cae2dc0..c805ef4cd 100644 --- a/include/notifier.php +++ b/include/notifier.php @@ -321,8 +321,8 @@ function notifier_run($argv, $argc){ $sql_extra = (($private) ? "" : " or hubloc_url = '" . z_root() . "' "); - $r = q("select distinct(hubloc_callback),hubloc_host,hubloc_sitekey from hubloc - where hubloc_hash in (" . implode(',',$recipients) . ") $sql_extra group by hubloc_callback"); + $r = q("select distinct hubloc_sitekey, hubloc_callback, hubloc_host from hubloc + where hubloc_hash in (" . implode(',',$recipients) . ") $sql_extra group by hubloc_sitekey"); if(! $r) { logger('notifier: no hubs'); return; -- cgit v1.2.3