From 02faf424037e7f3569c5c0a2f8c2d8a1286c218b Mon Sep 17 00:00:00 2001
From: Alexandre Alapetite <alexandre@alapetite.fr>
Date: Sun, 7 May 2017 21:39:00 +0200
Subject: [PATCH] Fix SQL syntax bug in mod message
---
mod/message.php | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/mod/message.php b/mod/message.php
index c32d5f1dd9..76f675f19b 100644
--- a/mod/message.php
+++ b/mod/message.php
@@ -351,7 +351,7 @@ function message_content(App $a) {
$o .= $header;
- $r = q("SELECT count(*) AS `total` FROM `mail`, ANY_VALUE(`created`) AS `created`
+ $r = q("SELECT count(*) AS `total`, ANY_VALUE(`created`) AS `created` FROM `mail`
WHERE `mail`.`uid` = %d GROUP BY `parent-uri` ORDER BY `created` DESC",
intval(local_user())
);
--
2.39.5