--- lbbs/src/article_view_log.c	2025/06/07 10:00:10	1.3
+++ lbbs/src/article_view_log.c	2025/06/16 14:30:44	1.5
@@ -14,14 +14,14 @@
  *                                                                         *
  ***************************************************************************/
 
+#define _XOPEN_SOURCE 500
+#define _POSIX_C_SOURCE 200809L
+
 #include "article_view_log.h"
 #include "log.h"
 #include "common.h"
 #include "database.h"
 #include <stdlib.h>
-
-#define _XOPEN_SOURCE 500
-#define _POSIX_C_SOURCE 200809L
 #include <string.h>
 
 ARTICLE_VIEW_LOG BBS_article_view_log;
@@ -123,7 +123,7 @@ int article_view_log_unload(ARTICLE_VIEW
 
 int article_view_log_save_inc(const ARTICLE_VIEW_LOG *p_view_log)
 {
-	MYSQL *db;
+	MYSQL *db = NULL;
 	char sql[SQL_BUFFER_LEN];
 	char tuple_tmp[LINE_BUFFER_LEN];
 	int i;
@@ -161,6 +161,7 @@ int article_view_log_save_inc(const ARTI
 			if (mysql_query(db, sql) != 0)
 			{
 				log_error("Add view_article_log error: %s\n", mysql_error(db));
+				mysql_close(db);
 				return -3;
 			}