@@ -30,7 +30,7 @@
 #
 try {
 	# remove
-	$certificates = $Database->runQuery("delete FROM certificates WHERE `t_id` = ? and is_manual = 0 and id NOT IN (SELECT c_id from hosts where c_id is not NULL)", [$tenant_id]);
+	$certificates = $Database->runQuery("delete FROM certificates WHERE `t_id` = ? and is_manual = 0 and id NOT IN (SELECT c_id from hosts where c_id is not NULL) and id NOT IN (SELECT c_id_old from hosts where c_id_old is not NULL)", [$tenant_id]);
 } catch (Exception $e) {
     // print error
 	$Common->errors[] = $e->getMessage();
Original file line number	Diff line number	Diff line change
`@@ -30,7 +30,7 @@`
`30`	`30`	`#`
`31`	`31`	`try {`
`32`	`32`	`# remove`
`33`		- $certificates = $Database->runQuery("delete FROM certificates WHERE `t_id` = ? and is_manual = 0 and id NOT IN (SELECT c_id from hosts where c_id is not NULL)", [$tenant_id]);
	`33`	+ $certificates = $Database->runQuery("delete FROM certificates WHERE `t_id` = ? and is_manual = 0 and id NOT IN (SELECT c_id from hosts where c_id is not NULL) and id NOT IN (SELECT c_id_old from hosts where c_id_old is not NULL)", [$tenant_id]);
`34`	`34`	`} catch (Exception $e) {`
`35`	`35`	`// print error`
`36`	`36`	`$Common->errors[] = $e->getMessage();`