Index: /branches/czw_branch/20110406/ippTools/share/laptool_exposures.sql
===================================================================
--- /branches/czw_branch/20110406/ippTools/share/laptool_exposures.sql	(revision 31408)
+++ /branches/czw_branch/20110406/ippTools/share/laptool_exposures.sql	(revision 31409)
@@ -1,13 +1,23 @@
 SELECT DISTINCT 
-    D.*,diffRun.state,sum(others.private) AS needs_remade FROM (
+    D.*,diffRun.state,
+    CONVERT(sum(others.private),SIGNED) AS needs_remade 
+--      0 AS needs_remade
+    FROM (
   SELECT DISTINCT 
-      W.*,IFNULL(diff1.diff_id,diff2.diff_id) AS diff_id FROM (
+      W.*,CONVERT(IFNULL(diff1.diff_id,diff2.diff_id),SIGNED) AS diff_id FROM (
     SELECT DISTINCT
         lap_id,lapRun.tess_id,projection_cell,filter,lapRun.state as lapRun_state, lapRun.registered, lapRun.fault, lapRun.label,
         lapExp.exp_id,lapExp.chip_id,lapExp.pair_id,private,pairwise,active,lapExp.data_state,
-        chipRun.state as chipRun_state, sum(chipProcessedImfile.fault) as chip_faults, sum(chipProcessedImfile.quality) as chip_quality,
-        camRun.cam_id, camRun.state as camRun_state,   sum(camProcessedExp.fault) AS cam_faults, sum(camProcessedExp.quality) AS cam_quality,
-	fakeRun.fake_id, fakeRun.state as fakeRun_state, sum(fakeProcessedImfile.fault) as fake_faults,
-  	warpRun.warp_id, warpRun.state as warpRun_state, sum(warpSkyfile.fault) as warp_faults, sum(warpSkyfile.quality) as warp_quality,
+        chipRun.state as chipRun_state, 
+	CONVERT(sum(chipProcessedImfile.fault),SIGNED) as chip_faults, 
+	CONVERT(sum(chipProcessedImfile.quality),SIGNED) as chip_quality,
+        camRun.cam_id, camRun.state as camRun_state,   
+	CONVERT(sum(camProcessedExp.fault),SIGNED) AS cam_faults, 
+	CONVERT(sum(camProcessedExp.quality),SIGNED) AS cam_quality,
+	fakeRun.fake_id, fakeRun.state as fakeRun_state, 
+	CONVERT(sum(fakeProcessedImfile.fault),SIGNED) as fake_faults,
+  	warpRun.warp_id, warpRun.state as warpRun_state, 
+	CONVERT(sum(warpSkyfile.fault),SIGNED) as warp_faults, 
+	CONVERT(sum(warpSkyfile.quality),SIGNED) as warp_quality,
         warpRun.magicked
     FROM lapRun JOIN lapExp USING(lap_id)
@@ -28,3 +38,3 @@
 LEFT JOIN diffRun USING(diff_id)
 JOIN lapExp AS others ON (D.chip_id = others.chip_id AND D.lap_id != others.lap_id)
-GROUP BY lap_id,exp_id
+
Index: /branches/czw_branch/20110406/ippTools/share/laptool_inactiveexp.sql
===================================================================
--- /branches/czw_branch/20110406/ippTools/share/laptool_inactiveexp.sql	(revision 31408)
+++ /branches/czw_branch/20110406/ippTools/share/laptool_inactiveexp.sql	(revision 31409)
@@ -1,4 +1,4 @@
 SELECT DISTINCT 
-    D.*,diffRun.state,sum(others.active) AS is_in_use FROM (
+    D.*,diffRun.state AS diff_state,CONVERT(sum(others.active),SIGNED) AS is_in_use FROM (
   SELECT DISTINCT 
       W.*,IFNULL(diff1.diff_id,diff2.diff_id) AS diff_id FROM (
@@ -7,8 +7,15 @@
         lapRun.dist_group, lapRun.registered, lapRun.fault, lapRun.quick_sass_id, lapRun.final_sass_id,
         lapExp.exp_id,lapExp.chip_id,lapExp.pair_id,private,pairwise,active,lapExp.data_state,
-        chipRun.state as chipRun_state, sum(chipProcessedImfile.fault) as chip_faults, sum(chipProcessedImfile.quality) as chip_quality,
-        cam_id, camRun.state as camRun_state,   sum(camProcessedExp.fault) AS cam_faults, sum(camProcessedExp.quality) AS cam_quality,
-        fake_id, fakeRun.state as fakeRun_state, sum(fakeProcessedImfile.fault) as fake_faults,
-        warp_id, warpRun.state as warpRun_state, sum(warpSkyfile.fault) as warp_faults, sum(warpSkyfile.quality) as warp_quality,
+        chipRun.state as chipRun_state, 
+	CONVERT(sum(chipProcessedImfile.fault),SIGNED) as chip_faults, 
+	CONVERT(sum(chipProcessedImfile.quality),SIGNED) as chip_quality,
+        camRun.cam_id, camRun.state as camRun_state,   
+	CONVERT(sum(camProcessedExp.fault),SIGNED) AS cam_faults, 
+	CONVERT(sum(camProcessedExp.quality),SIGNED) AS cam_quality,
+	fakeRun.fake_id, fakeRun.state as fakeRun_state, 
+	CONVERT(sum(fakeProcessedImfile.fault),SIGNED) as fake_faults,
+  	warpRun.warp_id, warpRun.state as warpRun_state, 
+	CONVERT(sum(warpSkyfile.fault),SIGNED) as warp_faults, 
+	CONVERT(sum(warpSkyfile.quality),SIGNED) as warp_quality,
         warpRun.magicked
     FROM lapRun JOIN lapExp USING(lap_id)
Index: /branches/czw_branch/20110406/ippTools/src/laptool.c
===================================================================
--- /branches/czw_branch/20110406/ippTools/src/laptool.c	(revision 31408)
+++ /branches/czw_branch/20110406/ippTools/src/laptool.c	(revision 31409)
@@ -708,4 +708,5 @@
   PXOPT_COPY_S64(config->args, where, "-exp_id", "exp_id", "==");
   PXOPT_COPY_S64(config->args, where, "-chip_id", "chip_id", "==");
+  PXOPT_COPY_STR(config->args, where, "-set_data_state", "data_state", "==");
 
   psMetadata *values = psMetadataAlloc();
@@ -717,20 +718,20 @@
   }
   if (private) {
-    psMetadataAddBool(values, PS_LIST_TAIL, "private", 1, "", false);
+    psMetadataAddBool(values, PS_LIST_TAIL, "private", 0, "==", true);
   }
   else if (public) {
-    psMetadataAddBool(values, PS_LIST_TAIL, "private", 0, "", false);
+    psMetadataAddBool(values, PS_LIST_TAIL, "private", 0, "==", false);
   }
   if (active) {
-    psMetadataAddBool(values, PS_LIST_TAIL, "active", 1, "", false);
+    psMetadataAddBool(values, PS_LIST_TAIL, "active", 0, "==", true);
   }
   else if (inactive) {
-    psMetadataAddBool(values, PS_LIST_TAIL, "active", 0, "", false);
+    psMetadataAddBool(values, PS_LIST_TAIL, "active", 0, "==", false);
   }
   if (pairwise) {
-    psMetadataAddBool(values, PS_LIST_TAIL, "pairwise", 1, "", false);
+    psMetadataAddBool(values, PS_LIST_TAIL, "pairwise", 0, "==", true);
   }
   else if (nopairwise) {
-    psMetadataAddBool(values, PS_LIST_TAIL, "pairwise", 0, "", false);
+    psMetadataAddBool(values, PS_LIST_TAIL, "pairwise", 0, "==", false);
   }
   
Index: /branches/czw_branch/20110406/ippTools/src/laptoolConfig.c
===================================================================
--- /branches/czw_branch/20110406/ippTools/src/laptoolConfig.c	(revision 31408)
+++ /branches/czw_branch/20110406/ippTools/src/laptoolConfig.c	(revision 31409)
@@ -73,4 +73,5 @@
   ADD_OPT(Str, pendingrunArgs, "-fault",                      "search by LAP run fault", NULL);
   ADD_OPT(Bool,pendingrunArgs, "-simple",                     "use the simple output format", false);
+
   // -updaterun
   psMetadata *updaterunArgs = psMetadataAlloc();
@@ -110,4 +111,5 @@
   ADD_OPT(S64, updateexpArgs, "-set_chip_id",                 "set the chip ID", 0);
   ADD_OPT(S64, updateexpArgs, "-set_pair_id",                 "set the pair ID", 0);
+  ADD_OPT(Str, updateexpArgs, "-set_data_state",              "set the lapExp data_state", NULL);
   ADD_OPT(Bool,updateexpArgs, "-private",                     "set this exposure as private", 0);
   ADD_OPT(Bool,updateexpArgs, "-public",                      "set this exposure as public", 0);
Index: /branches/czw_branch/20110406/psLib/src/db/psDB.c
===================================================================
--- /branches/czw_branch/20110406/psLib/src/db/psDB.c	(revision 31408)
+++ /branches/czw_branch/20110406/psLib/src/db/psDB.c	(revision 31409)
@@ -1043,5 +1043,5 @@
         pType = psDBMySQLToPType(field[i].type, field[i].flags);
         if (!pType) {
-          psError(PS_ERR_UNKNOWN, false, "Failed to lookup type.");
+          psError(PS_ERR_UNKNOWN, false, "Failed to lookup type. %d %d %d",i,field[i].type, field[i].flags);
           psFree(md);
           mysql_free_result(result);