Fix profile wrong DISTINCT + ORDER BY

[friendica.git] / mod / ping.php

diff --git a/mod/ping.php b/mod/ping.php
index b5330c7b330bcfebdf64c51446432ebfb1baf8b5..0b82e71d392e3eb083cd3bdfb2af9578118954e0 100644 (file)
--- a/mod/ping.php
+++ b/mod/ping.php
@@ -201,6 +201,7 @@ function ping_init(App $a)
                if (is_null($ev)) {
                        $ev = qu("SELECT count(`event`.`id`) AS total, type, start, adjust FROM `event`
                                WHERE `event`.`uid` = %d AND `start` < '%s' AND `finish` > '%s' and `ignore` = 0
+                               GROUP BY type, start, adjust
                                ORDER BY `start` ASC ",
                                intval(local_user()),
                                dbesc(datetime_convert('UTC', 'UTC', 'now + 7 days')),