Index: trunk/MagicSoft/Mars/Changelog
===================================================================
--- trunk/MagicSoft/Mars/Changelog	(revision 7394)
+++ trunk/MagicSoft/Mars/Changelog	(revision 7395)
@@ -24,4 +24,5 @@
      - fixed typo (be careful: due to this typo the values for 
        L2TriggerTable in the DB and in the sequence files may be wrong)
+     - fixed bug introduced on 29th sept
 
    * datacenter/scripts/rmlocks:
Index: trunk/MagicSoft/Mars/datacenter/macros/buildsequenceentries.C
===================================================================
--- trunk/MagicSoft/Mars/datacenter/macros/buildsequenceentries.C	(revision 7394)
+++ trunk/MagicSoft/Mars/datacenter/macros/buildsequenceentries.C	(revision 7395)
@@ -220,7 +220,7 @@
 
         //calibration table
-        query=Form("SELECT fSequenceFirst FROM Calibration "
+        query=Form("SELECT Calibration.fSequenceFirst FROM Calibration "
                    " LEFT JOIN Sequences ON Calibration.fSequenceFirst=Sequences.fSequenceFirst "
-                   " WHERE fManuallyChangedKEY=1 AND fSequenceFirst BETWEEN %d and %d",
+                   " WHERE fManuallyChangedKEY=1 AND Calibration.fSequenceFirst BETWEEN %d and %d",
                    from, to);
         res = serv.Query(query);
@@ -237,7 +237,7 @@
 
         //Star table
-        query=Form("SELECT fSequenceFirst FROM Star "
+        query=Form("SELECT Star.fSequenceFirst FROM Star "
                    " LEFT JOIN Sequences ON Star.fSequenceFirst=Sequences.fSequenceFirst "
-                   " WHERE fManuallyChangedKEY=1 AND  fSequenceFirst BETWEEN %d and %d",
+                   " WHERE fManuallyChangedKEY=1 AND  Star.fSequenceFirst BETWEEN %d and %d",
                    from, to);
         res = serv.Query(query);
@@ -254,7 +254,7 @@
 
         //SequenceProcessStatus table
-        query=Form("SELECT fSequenceFirst FROM SequenceProcessStatus "
+        query=Form("SELECT SequenceProcessStatus.fSequenceFirst FROM SequenceProcessStatus "
                    " LEFT JOIN Sequences ON SequenceProcessStatus.fSequenceFirst=Sequences.fSequenceFirst "
-                   " WHERE fManuallyChangedKEY=1 AND  fSequenceFirst BETWEEN %d and %d",
+                   " WHERE fManuallyChangedKEY=1 AND  SequenceProcessStatus.fSequenceFirst BETWEEN %d and %d",
                    from, to);
         res = serv.Query(query);
Index: trunk/MagicSoft/Mars/datacenter/scripts/rmlocks
===================================================================
--- trunk/MagicSoft/Mars/datacenter/scripts/rmlocks	(revision 7394)
+++ trunk/MagicSoft/Mars/datacenter/scripts/rmlocks	(revision 7395)
@@ -40,12 +40,7 @@
 #   echo "now: " $now
 #   echo "comp: " $compdate
-   twelf=12
-   if [ $compdate -gt $twelf ]
-   then
-      filedate2=`expr $filedate + 24`
-   else 
-      filedate2=$filedate
-   fi
-   if [ $compdate -gt $filedate2 ] || [ $filedate2 -gt $now -a $now -gt $twelf ]
+   filedate2=`expr $filedate + 24`
+   
+   if [ $compdate -gt $filedate2 ] || [ $filedate -gt $now ]
    then 
       rm -v $file