version 0.3.16

[fms.git] / src / http / pages / controlboardpage.cpp

diff --git a/src/http/pages/controlboardpage.cpp b/src/http/pages/controlboardpage.cpp
index 5677a91..fa8369d 100644 (file)
--- a/src/http/pages/controlboardpage.cpp
+++ b/src/http/pages/controlboardpage.cpp
@@ -36,7 +36,7 @@ const std::string ControlBoardPage::GeneratePage(const std::string &method, cons
                        st.Bind(0,boardid);\r
                        st.Step();\r
 \r
-                       st=m_db->Prepare("DELETE FROM tblMessage WHERE MessageUUID IN (SELECT MessageUUID FROM tblMessage INNER JOIN tblMessageBoard ON tblMessage.MessageID=tblMessageBoard.MessageID WHERE BoardID=?);");\r
+                       st=m_db->Prepare("DELETE FROM tblMessage WHERE MessageUUID IN (SELECT MessageUUID FROM tblMessage INNER JOIN tblMessageBoard ON tblMessage.MessageID=tblMessageBoard.MessageID WHERE BoardID=? AND MessageUUID IS NOT NULL);");\r
                        st.Bind(0,boardid);\r
                        st.Step();\r
 \r