X-Git-Url: https://git.pterodactylus.net/?a=blobdiff_plain;f=src%2Fdbmaintenancethread.cpp;h=ae4dc88357955f545fdae5cceafa063587788241;hb=e662ea47fba8715474851ceebacba400984ee433;hp=0ecfeda26dc994d85bf753968c8b5155dc9c9fe3;hpb=30c26abc85a6331fecdcb6b03813710bfbc63d3f;p=fms.git

diff --git a/src/dbmaintenancethread.cpp b/src/dbmaintenancethread.cpp
index 0ecfeda..ae4dc88 100644
--- a/src/dbmaintenancethread.cpp
+++ b/src/dbmaintenancethread.cpp
@@ -104,6 +104,9 @@ void DBMaintenanceThread::Do10MinuteMaintenance()
 		st.Step();
 	}
 
+	// delete threads that have no messages
+	m_db->Execute("DELETE FROM tblThread WHERE ThreadID IN (SELECT tblThread.ThreadID FROM tblThread LEFT JOIN tblThreadPost ON tblThread.ThreadID=tblThreadPost.ThreadID WHERE tblThreadPost.ThreadID IS NULL);");
+
 	// TODO - remove after corruption issue fixed
 	if(ll=="8")
 	{