Re: help how to toggle FRED "serverInzoneManual - The domain is administratively kept in zone"

Hi Paulos, this se only temporal situation. This button ("Set InZone status") keeps domain in the zone file for 7 days to give owner time to pay to registrar. It will revert to normal state after 7 days. We have never seen a need to revert it back earlier. If you really need it here is the SQL. Even though I did some tests you should first run it with ROLLBACK to see if it really do just one update of state table and than change ROLLBACK to COMMIT. Don't forget to change FQDN for real domain name: begin; update object_state_request set canceled=now() where id=( select osr.id from object_state_request osr join enum_object_states eos on ( eos.id=osr.state_id and eos.name='serverInzoneManual' and osr.valid_to > current_date and osr.canceled is null ) join object_registry obr on ( obr.id=osr.object_id and obr.name='FQDN' and obr.type=3 and obr.erdate is null ) ); select update_object_states( (select id from object_registry where name='FQDN' and type=3 and erdate is null) ); rollback; Jaromir On Thu, 2018-04-26 at 17:38 +0200, Dr P Nyirenda wrote: