7.7.8 Spots: Error in Activities MySQL

SuiteCRM Forum - English Language Developer Collaboration
1

In modules/Spots/controller.php function action_createActivitiesSpotsData uses a UNION to collect the calls, meetings and task data.
MySQL version requires UNION ALL in order to not delete duplicate rows. Otherwise all counts are 1.
I’m not set up to do a git pull request so the changes are below. I think a topic on using git with SuiteCRM would be useful.

--- a/modules/Spots/controller.php
+++ b/modules/Spots/controller.php
@@ -565,7 +565,7 @@ EOF;
 EOF;

         $mysqlQueryMeetings = <<<EOF
-        UNION
+        UNION ALL
         SELECT
             'meeting' as type
             , meetings.name
@@ -579,7 +579,7 @@ EOF;
 EOF;

         $mysqlQueryTasks = <<<EOF
-        UNION
+        UNION ALL
         SELECT
             'task' as type
             , tasks.name