From raeburn at source.lon-capa.org  Thu Sep 16 12:02:41 2021
From: raeburn at source.lon-capa.org (raeburn)
Date: Thu, 16 Sep 2021 16:02:41 -0000
Subject: [LON-CAPA-cvs] cvs: loncom /interface loncoursedata.pm
Message-ID: <cvsraeburn1631808161@cvsserver>

raeburn		Thu Sep 16 16:02:41 2021 EDT

  Modified files:              
    /loncom/interface	loncoursedata.pm 
  Log:
  - Support for Ubuntu 20 LTS.
    Explicitly include ORDER BY, as an implicit sort based on GROUP BY was
    eliminated in MySQL 8.  
  
  
Index: loncom/interface/loncoursedata.pm
diff -u loncom/interface/loncoursedata.pm:1.207 loncom/interface/loncoursedata.pm:1.208
--- loncom/interface/loncoursedata.pm:1.207	Fri Mar  5 17:17:57 2021
+++ loncom/interface/loncoursedata.pm	Thu Sep 16 16:02:41 2021
@@ -1,6 +1,6 @@
 # The LearningOnline Network with CAPA
 #
-# $Id: loncoursedata.pm,v 1.207 2021/03/05 17:17:57 raeburn Exp $
+# $Id: loncoursedata.pm,v 1.208 2021/09/16 16:02:41 raeburn Exp $
 #
 # Copyright Michigan State University Board of Trustees
 #
@@ -2520,7 +2520,7 @@
         &Apache::lonnet::logthis('prepared then executed '.$/.$request);
         return undef;
     }
-    $request = 'SELECT score,COUNT(*) FROM '.$tmptable.' GROUP BY score';
+    $request = 'SELECT score,COUNT(*) FROM '.$tmptable.' GROUP BY score ORDER BY score';
 #    &Apache::lonnet::logthis("request = \n".$request);
     $sth = $dbh->prepare($request);
     $sth->execute();



From raeburn at source.lon-capa.org  Thu Sep 16 12:20:36 2021
From: raeburn at source.lon-capa.org (raeburn)
Date: Thu, 16 Sep 2021 16:20:36 -0000
Subject: [LON-CAPA-cvs] cvs: loncom(version_2_11_X) /interface
	loncoursedata.pm
Message-ID: <cvsraeburn1631809236@cvsserver>

raeburn		Thu Sep 16 16:20:36 2021 EDT

  Modified files:              (Branch: version_2_11_X)
    /loncom/interface	loncoursedata.pm 
  Log:
  - For 2.11
    Backport 1.208
  
  
Index: loncom/interface/loncoursedata.pm
diff -u loncom/interface/loncoursedata.pm:1.201.2.5 loncom/interface/loncoursedata.pm:1.201.2.6
--- loncom/interface/loncoursedata.pm:1.201.2.5	Fri Mar  5 17:18:40 2021
+++ loncom/interface/loncoursedata.pm	Thu Sep 16 16:20:36 2021
@@ -1,6 +1,6 @@
 # The LearningOnline Network with CAPA
 #
-# $Id: loncoursedata.pm,v 1.201.2.5 2021/03/05 17:18:40 raeburn Exp $
+# $Id: loncoursedata.pm,v 1.201.2.6 2021/09/16 16:20:36 raeburn Exp $
 #
 # Copyright Michigan State University Board of Trustees
 #
@@ -2520,7 +2520,7 @@
         &Apache::lonnet::logthis('prepared then executed '.$/.$request);
         return undef;
     }
-    $request = 'SELECT score,COUNT(*) FROM '.$tmptable.' GROUP BY score';
+    $request = 'SELECT score,COUNT(*) FROM '.$tmptable.' GROUP BY score ORDER BY score';
 #    &Apache::lonnet::logthis("request = \n".$request);
     $sth = $dbh->prepare($request);
     $sth->execute();