X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=src%2Fhttp%2Fpages%2Fcontrolboardpage.cpp;h=fa8369d0067c433fd6bab6d1961c2573e96c9272;hp=5677a91d137d92560da7442a2c48819e33b66379;hb=b7f3b3e6ae9dc527f02b5c06e2eeae0e9cac3ad8;hpb=f8c0410b12183ecb40aafbb44086fa146b25b528 diff --git a/src/http/pages/controlboardpage.cpp b/src/http/pages/controlboardpage.cpp index 5677a91..fa8369d 100644 --- 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); st.Step(); - st=m_db->Prepare("DELETE FROM tblMessage WHERE MessageUUID IN (SELECT MessageUUID FROM tblMessage INNER JOIN tblMessageBoard ON tblMessage.MessageID=tblMessageBoard.MessageID WHERE BoardID=?);"); + 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);"); st.Bind(0,boardid); st.Step();