--- a/admin/linkAmendments.php
+++ b/admin/linkAmendments.php
@@ -1,14 +1,23 @@
 <?php
 include_once ("../lib/common.inc.php");
+if (php_sapi_name() != "cli") {
+    
+//auth();
+}
+$query = 'update contractnotice set "parentCN" = null where "parentCN" = \'0\'';
+$query = $conn->prepare($query);
+	$query->execute();
+        $query = 'update contractnotice set "supplierABN" = null where "supplierABN" = \'0\'';
+$query = $conn->prepare($query);
+	$query->execute();
 $query = 'SELECT c."CNID",c."parentCN",p."childCN" FROM contractnotice as c  LEFT OUTER JOIN contractnotice as p on c."parentCN" = p."CNID"
 WHERE
-c."parentCN" > 0 AND p."childCN" IS NULL ';
+c."parentCN" IS NOT NULL AND p."childCN" IS NULL ';
 $query = $conn->prepare($query);
 	$query->execute();
-	if (!$query) {
 		databaseError($conn->errorInfo());
-	}
 foreach ($query->fetchAll() as $row) {
+    if ($row['parentCN'] != 0) {
   $conn->exec('UPDATE contractnotice SET "childCN" = \'' .
 			 $row['CNID'] . '\' where "CNID" = \'' .
 			 $row['parentCN'] . '\';');
@@ -21,7 +30,7 @@
                   echo $row['CNID'] . " linked to parent " . $row['parentCN'] .
   "<br>\n";
   else print_r($errors);
-
+    }
 }
 // also need to eliminate CN 100528/100529 - check for double parent CNs with no childCN, latest sequent CN id keeps childCN = 0
 $query = 'SELECT "parentCN", array_agg("CNID"), count(*) from contractnotice WHERE "parentCN" IN
@@ -30,15 +39,13 @@
       FROM contractnotice
       GROUP BY "parentCN" 
       HAVING COUNT(*) > 1 
-      AND "parentCN" != 0
+      AND "parentCN" IS NOT NULL
 )
-AND "childCN" = 0
+AND "childCN" IS NULL
 GROUP BY "parentCN" having count(*) > 1';
 $query = $conn->prepare($query);
 	$query->execute();
-	if (!$query) {
 		databaseError($conn->errorInfo());
-	}
 foreach ($query->fetchAll() as $row) {
 	$cnids = explode(",",str_replace(Array("{","}"),"",$row['array_agg']));
 	$last_cnid = array_pop($cnids);
@@ -55,5 +62,6 @@
   else print_r($errors);
 }
 }
+
 ?>