lib/mysql-functions: mysql_load_min_and_max_versions() should ignore versions with `order`=NULL

1 files changed, 4 insertions, 0 deletions

diff --git a/lib/mysql-functions b/lib/mysql-functions
index bf66a73..548ee00 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -1526,6 +1526,7 @@ mysql_load_min_and_max_versions() {
       {
         printf 'SELECT CONCAT(`versions`.`epoch`,":",`versions`.`version`)'
         printf ' FROM `versions`'
+        printf ' WHERE `versions`.`order` IS NOT NULL'
         printf ' ORDER BY `versions`.`order`'
         printf ' LIMIT 1'
       } | \
@@ -1538,6 +1539,7 @@ mysql_load_min_and_max_versions() {
       {
         printf 'SELECT CONCAT(`versions`.`epoch`,":",`versions`.`version`)'
         printf ' FROM `versions`'
+        printf ' WHERE `versions`.`order` IS NOT NULL'
         printf ' ORDER BY `versions`.`order` DESC'
         printf ' LIMIT 1'
       } | \
@@ -1550,6 +1552,7 @@ mysql_load_min_and_max_versions() {
       {
         printf 'SELECT `versions`.`id`'
         printf ' FROM `versions`'
+        printf ' WHERE `versions`.`order` IS NOT NULL'
         printf ' ORDER BY `versions`.`order`'
         printf ' LIMIT 1'
       } | \
@@ -1562,6 +1565,7 @@ mysql_load_min_and_max_versions() {
       {
         printf 'SELECT `versions`.`id`'
         printf ' FROM `versions`'
+        printf ' WHERE `versions`.`order` IS NOT NULL'
         printf ' ORDER BY `versions`.`order` DESC'
         printf ' LIMIT 1'
       } | \