--- a/admin/linkAmendments.php
+++ b/admin/linkAmendments.php
@@ -1,6 +1,13 @@
 <?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"
@@ -55,5 +62,6 @@
   else print_r($errors);
 }
 }
+
 ?>