--- a/admin/linkAmendments.php
+++ b/admin/linkAmendments.php
@@ -1,6 +1,9 @@
 <?php
 include_once ("../lib/common.inc.php");
 $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"