Changed DataObjects/Core_person.php
authorAlan Knowles <alan@roojs.com>
Wed, 4 Sep 2019 02:34:38 +0000 (10:34 +0800)
committerAlan Knowles <alan@roojs.com>
Wed, 4 Sep 2019 02:34:38 +0000 (10:34 +0800)
DataObjects/Core_person.php

index 1e30d4a..f180f7d 100644 (file)
@@ -1143,12 +1143,12 @@ class Pman_Core_DataObjects_Core_person extends DB_DataObject
     function selectAddGroupMemberships()
     {
         $this->selectAdd("
-            CONCAT ('[',
+            CONCAT (,
                 COALESCE((
                     SELECT
                         GROUP_CONCAT( 
-                            JSON_QUOTE(core_group.name)
-                        )
+                            core_group.name
+                        , '\n')
                     FROM
                         core_group_member
                     LEFT JOIN
@@ -1158,7 +1158,7 @@ class Pman_Core_DataObjects_Core_person extends DB_DataObject
                     WHERE
                         core_group_member.user_id = core_person.id
                 ), ''),
-            ']') as member_of_json");
+            ) as member_of");
     }
     
     function setFromRoo($ar, $roo)