add in NVLs for afil and ufil mountpoint, since nothing guarantees

they'll be non-empty

diff --git a/server/queries2.c b/server/queries2.c
index fb7d7b30c51f40b7fe41021e0ba7a4000e7994ba..306124ad750d38c6e1cc9cd9c8c82c7d182dcdf3 100644 (file)
--- a/server/queries2.c
+++ b/server/queries2.c
@@ -3974,7 +3974,7 @@ struct query Queries2[] = {
     APPEND,
     "fs",
     FILESYS_TABLE,
-    "INTO filesys (label, type, mach_id, name, mount, rwaccess, comments, owner, owners, createflg, lockertype, filsys_id) VALUES ('%s', '%s', %d, NVL('%s', CHR(0)), '%s', '%s', NVL('%s', CHR(0)), %d, %d, %s, '%s', %s)",
+    "INTO filesys (label, type, mach_id, name, mount, rwaccess, comments, owner, owners, createflg, lockertype, filsys_id) VALUES ('%s', '%s', %d, NVL('%s', CHR(0)), NVL('%s', CHR(0)), '%s', NVL('%s', CHR(0)), %d, %d, %s, '%s', %s)",
     afil_fields,
     11,
     0,
@@ -3990,7 +3990,7 @@ struct query Queries2[] = {
     UPDATE,
     "fs",
     FILESYS_TABLE,
-    "filesys SET label = '%s', type = '%s', mach_id = %d, name = NVL('%s', CHR(0)), mount = '%s', rwaccess = '%s', comments = NVL('%s', CHR(0)), owner = %d, owners = %d, createflg = %s, lockertype = '%s'",
+    "filesys SET label = '%s', type = '%s', mach_id = %d, name = NVL('%s', CHR(0)), mount = NVL('%s', CHR(0)), rwaccess = '%s', comments = NVL('%s', CHR(0)), owner = %d, owners = %d, createflg = %s, lockertype = '%s'",
     ufil_fields,
     11,
     "filsys_id = %d",