Mercurial > bms / file diff

--- a/bmsd/mysql.c	Tue May 19 22:48:59 2020 +0200
+++ b/bmsd/mysql.c	Wed May 20 21:49:09 2020 +0200
@@ -85,7 +85,7 @@
     /*
      * Restore nodes from the database
      */
-    if (mysql_query(con, "SELECT * FROM mon_nodes")) {
+    if (mysql_query(con, "SELECT * FROM mon_nodes ORDER BY node")) {
 	syslog(LOG_NOTICE, "MySQL: SELECT * FROM mon_nodes error %u (%s))", mysql_errno(con), mysql_error(con));
     } else {
 	res_set = mysql_store_result(con);
@@ -135,7 +135,7 @@
 	}
     }
 
-    if (mysql_query(con, "SELECT * FROM mon_fermenters")) {
+    if (mysql_query(con, "SELECT * FROM mon_fermenters ORDER BY node,alias")) {
 	syslog(LOG_NOTICE, "MySQL: SELECT * FROM mon_fermenters error %u (%s))", mysql_errno(con), mysql_error(con));
     } else {
 	res_set = mysql_store_result(con);
@@ -231,7 +231,7 @@
 	}
     }
 
-    if (mysql_query(con, "SELECT * FROM mon_co2meters")) {
+    if (mysql_query(con, "SELECT * FROM mon_co2meters ORDER BY node,alias")) {
         syslog(LOG_NOTICE, "MySQL: SELECT * FROM mon_co2meters error %u (%s))", mysql_errno(con), mysql_error(con));
     } else {
         res_set = mysql_store_result(con);
@@ -275,7 +275,7 @@
 	}
     }
 
-    if (mysql_query(con, "SELECT * FROM mon_ispindels")) {
+    if (mysql_query(con, "SELECT * FROM mon_ispindels ORDER BY node,alias")) {
         syslog(LOG_NOTICE, "MySQL: SELECT * FROM mon_ispindels error %u (%s))", mysql_errno(con), mysql_error(con));
     } else {
         res_set = mysql_store_result(con);