Index: /branches/pap_mops/ippTools/share/pubtool_pending.sql
===================================================================
--- /branches/pap_mops/ippTools/share/pubtool_pending.sql	(revision 24437)
+++ /branches/pap_mops/ippTools/share/pubtool_pending.sql	(revision 24438)
@@ -1,5 +1,5 @@
 SELECT
     publishToDo.*
-FROM ((
+FROM (
     SELECT
         publishRun.pub_id,
@@ -16,5 +16,5 @@
         AND publishRun.state = 'new'
         AND diffRun.state = 'full'
-    ) AS publishDiffs UNION (
+    UNION
     SELECT
         publishRun.pub_id,
@@ -30,5 +30,4 @@
         AND publishRun.state ='new'
         AND camRun.state = 'full'
-    ) AS publishCams
 ) AS publishToDo
 LEFT JOIN publishDone USING(pub_id)
Index: /branches/pap_mops/ippTools/src/pubtool.c
===================================================================
--- /branches/pap_mops/ippTools/src/pubtool.c	(revision 24437)
+++ /branches/pap_mops/ippTools/src/pubtool.c	(revision 24438)
@@ -132,5 +132,5 @@
     if (psListLength(where->list)) {
         psString clause = psDBGenerateWhereConditionSQL(where, NULL);
-        psStringAppend(&whereClause, " AND %s", clause);
+        psStringAppend(&whereClause, "\n AND %s", clause);
         psFree(clause);
     }
@@ -160,7 +160,4 @@
         psTrace("pubtool", PS_LOG_INFO, "No rows found");
         psFree(output);
-        if (!psDBRollback(config->dbh)) {
-            psError(PS_ERR_UNKNOWN, false, "Database error");
-        }
         return true;
     }
Index: /branches/pap_mops/ippTools/src/pubtoolConfig.c
===================================================================
--- /branches/pap_mops/ippTools/src/pubtoolConfig.c	(revision 24437)
+++ /branches/pap_mops/ippTools/src/pubtoolConfig.c	(revision 24438)
@@ -68,4 +68,5 @@
     psMetadata *addArgs = psMetadataAlloc();
     psMetadataAddS64(addArgs, PS_LIST_TAIL, "-pub_id", 0, "define pub_id (required)", 0);
+    psMetadataAddStr(addArgs, PS_LIST_TAIL, "-path_base", 0, "define path_base (required)", NULL);
     psMetadataAddS32(addArgs, PS_LIST_TAIL, "-fault", 0, "define fault code", 0);