Page History

Please note that the following mysql commands modify your database! Please take a backup copy of your database before performance any database modifications.

SELECT count(*) FROM `zone_server_linkage` as t1
INNER JOIN `records` as t2 ON t1.`zoneid` = t2.`zone_id`
INNER JOIN `dns_views` as t3 ON t1.`serverid` = t3.`server_id` AND 
`name` = '_6connectDefault'
LEFT JOIN `dns_view_record_linkage` as t4 ON t2.`id` = t4.`record_id` 
AND t3.`id` = t4.`view_id`
WHERE t4.`id` IS NULL;

INSERT INTO `dns_view_record_linkage` SELECT '', t2.`id` as `record_id`, 
t3.`id` as `view_id` FROM `zone_server_linkage` as t1
INNER JOIN `records` as t2 ON t1.`zoneid` = t2.`zone_id`
INNER JOIN `dns_views` as t3 ON t1.`serverid` = t3.`server_id` AND 
`name` = '_6connectDefault'
LEFT JOIN `dns_view_record_linkage` as t4 ON t2.`id` = t4.`record_id` 
AND t3.`id` = t4.`view_id`
WHERE t4.`id` IS NULL;