correct errors in database SQL

[owTools.git] / src / mySensorDB.cpp

diff --git a/src/mySensorDB.cpp b/src/mySensorDB.cpp
index 76631e3..891282e 100755 (executable)
--- a/src/mySensorDB.cpp
+++ b/src/mySensorDB.cpp
@@ -193,7 +193,7 @@ int mySensorDB::insertValues(owDevice *dev) {
                sprintf(hs,"%016llX",(unsigned long long)dev->getNum().num);
                std::string query;
                query="INSERT INTO `"+mypre+"OW"+std::string(hs)+"` (";
-               for (size_t i=0;i<4;i++) if (dev->config->getPropertyID(i)!=0) query+=std::string(hs)+"_"+std::to_string(i+1)+", ";
+               for (size_t i=0;i<4;i++) if (dev->config->getPropertyID(i)!=0) query+="`"+std::string(hs)+"_"+std::to_string(i+1)+"`, ";
                query.pop_back();query.pop_back();
                query+=") VALUES (";
                for (size_t i=0;i<4;i++) if (dev->config->getPropertyID(i)!=0) query+=std::to_string(dev->values[i])+", ";