--- chewbacca/YodaProfiler/src/PamelaDBOperations.cpp	2014/04/04 14:11:24	1.37
+++ chewbacca/YodaProfiler/src/PamelaDBOperations.cpp	2014/10/14 13:19:32	1.40
@@ -1373,6 +1373,7 @@
   oss.str("");
   oss << "SET wait_timeout=173000;";
   conn->Query(oss.str().c_str()); 
+  delete conn->Query("SET sql_mode = 'NO_UNSIGNED_SUBTRACTION';");
   //
 }
 
@@ -1658,7 +1659,8 @@
 Int_t PamelaDBOperations::insertPamelaGL_TIMESYNC(){
   //
   Int_t signal = 0;
-  UInt_t idresof = 0;
+  //  UInt_t idresof = 0;
+  idresof = 0;
   stringstream   oss;
   TSQLResult *result = 0;
   TSQLRow *row = 0;
@@ -1972,7 +1974,7 @@
     //
     if ( chewbacca ){
 	oss.str("");
-	oss << " SELECT ID FROM GL_TIMESYNC where TIMESYNC="<<chlastts<<" AND OBT0="<<chobtts*1000<<" limit 1;";
+	oss << " SELECT ID FROM GL_TIMESYNC where TIMESYNC="<<chlastts<<" AND OBT0="<<chobtts*1000<<" and ID_RESURS_OFFSET="<< idresof <<" limit 1;"; // 10RED BUG!!!! without 'and ID_RESURS_OFFSET="<< idresof ' this query is not enough to ensure finding the correct line in GL_TIMSYNC...
 	if ( debug ) printf(" %s \n",oss.str().c_str());
 	result = conn->Query(oss.str().c_str());
 	//
@@ -5745,7 +5747,7 @@
 	      // ---------------------------------------------------------------------
 	      UInt_t idtimesync = 0;
 	      oss.str("");
-	      oss << " SELECT ID FROM GL_TIMESYNC where TIMESYNC="<<chlastts<<" AND OBT0="<<chobtts*1000<<" limit 1;";
+              oss << " SELECT ID FROM GL_TIMESYNC where TIMESYNC="<<chlastts<<" AND OBT0="<<chobtts*1000<<" and ID_RESURS_OFFSET="<< idresof <<" limit 1;"; // 10RED BUG!!!! without 'and ID_RESURS_OFFSET="<< idresof ' this query is not enough to ensure finding the correct line in GL_TIMSYNC...
 	      if ( debug ) printf(" %s \n",oss.str().c_str());
 	      result = conn->Query(oss.str().c_str());
 	      if ( !result ) throw -3;