[Mapbender-commits] r10290 - trunk/mapbender/http/classes

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2019-10-18 05:23:11 -0700 (Fri, 18 Oct 2019)
New Revision: 10290

Modified:
   trunk/mapbender/http/classes/class_user.php
Log:
Fix for group_by clause

Modified: trunk/mapbender/http/classes/class_user.php
===================================================================
--- trunk/mapbender/http/classes/class_user.php	2019-10-18 11:57:22 UTC (rev 10289)
+++ trunk/mapbender/http/classes/class_user.php	2019-10-18 12:23:11 UTC (rev 10290)
@@ -1147,7 +1147,7 @@
 	 */
 	public function getWmcInfoByOwner ($ignorePublic = false) {
 		$sql = "SELECT wmc_serial_id, wmc_title, abstract FROM mb_user_wmc ";
-		$sql .= "WHERE fkey_user_id = $1 GROUP BY wmc_serial_id";
+		$sql .= "WHERE fkey_user_id = $1 GROUP BY wmc_serial_id, wmc_title, abstract";
 		if ($ignorePublic == true) {
 			$sql .= " AND wmc_public = 1";
 		}