From: Alan Knowles <alan@roojs.com>
Date: Wed, 4 Sep 2019 02:55:30 +0000 (+0800)
Subject: fix group concat on members list
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=27a1a32abdd80b79b936003238709950f0e3ba29

fix group concat on members list
---

diff --git a/DataObjects/Core_person.php b/DataObjects/Core_person.php
index 740fb549..30b72af7 100644
--- a/DataObjects/Core_person.php
+++ b/DataObjects/Core_person.php
@@ -1146,9 +1146,7 @@ class Pman_Core_DataObjects_Core_person extends DB_DataObject
             
             COALESCE((
                 SELECT
-                    GROUP_CONCAT( 
-                        core_group.name
-                    , '\n')
+                    GROUP_CONCAT(  core_group.name separator  '\n')
                 FROM
                     core_group_member
                 LEFT JOIN