summaryrefslogtreecommitdiff
path: root/lib/mysql-functions
diff options
context:
space:
mode:
Diffstat (limited to 'lib/mysql-functions')
-rwxr-xr-xlib/mysql-functions4
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'
} | \