From 078a4ec7b8dfcb8a4c0d630a58459000889576d3 Mon Sep 17 00:00:00 2001
From: "Jean-Marc Pigeon (Delson)" <jmp@safe.ca>
Date: Sun, 13 Jul 2025 10:32:08 -0400
Subject: [PATCH] updating database tables 'remotes' seems to be working

---
 lib/devsql.c     | 4 ----
 lib/gessql.c     | 2 +-
 sql/mailleur.sql | 2 +-
 3 files changed, 2 insertions(+), 6 deletions(-)

diff --git a/lib/devsql.c b/lib/devsql.c
index 003f04c..61d1f48 100644
--- a/lib/devsql.c
+++ b/lib/devsql.c
@@ -530,10 +530,6 @@ switch(sql->sqldb) {
                         OPEP,(int)sql->sqldb);
     break;
   }
-if (value==(char *)0) {
-  (void) rou_alert(0,"%s value is NULL for field=<%s> (BUG!?)",OPEP,name);
-  value="00000";        //force value!
-  }
 return value;
 #undef  OPEP
 }
diff --git a/lib/gessql.c b/lib/gessql.c
index f73fd54..b0a495d 100644
--- a/lib/gessql.c
+++ b/lib/gessql.c
@@ -377,7 +377,7 @@ return isok;
 static _Bool update_remote(SQLPTR *sqlptr,char *rmtip,SRVTYP *srv)
 
 {
-#define OPEP    "fgessql.c:update_remote,"
+#define OPEP    "gessql.c:update_remote,"
 
 static const char *upd="UPDATE "RMTTBL" SET lastscan='%s',credit=%d,listing=%s WHERE remoteip='%s'";
 
diff --git a/sql/mailleur.sql b/sql/mailleur.sql
index 50d1303..594af64 100644
--- a/sql/mailleur.sql
+++ b/sql/mailleur.sql
@@ -82,7 +82,7 @@ CREATE TABLE sessions	(
 	taille		INTEGER		//The email size
 			DFLT 0,
 	duration	TEXT		//email transfer duration
-			DFLT 'NULL'
+			DFLT NULL
 	);
 GRANT SELECT			 	ON sessions TO mailapache;
 
-- 
2.47.3