DNS Auto Creation File - Vanity domain version Select * from tblDNSSettings

ERROR: DNS information read failed

 SELECT * FROM qryDomainandVanity WHERE (Flag_OurDNS = true) AND (Flag_OurDNSCreated =false)

Nothing to do - no records marked our DNS and DNS not created

If this is a surprise it's probably because you forgot to change the 'Our DNS Created' flag to false for the domain you were trying to modify

UPDATE tblDNSSettings SET SerialNumber='#SerialNumber##Counter#'

SerialNumber updated to #SerialNumber# UPDATE tblDNSSettings SET SerialNumber='#SerialNumber#01'

SerialNumber set to #SerialNumber# Select * from tblDNSSettings

ERROR: Serial number missing from string
#FileOutputString#
Creating domain information for : #DomainName#
Web Server DNS Prefix: #WebServerDNSPrefix# WWWIPAddress: #WWWIPAddress#
MailserverAddress: #MSAddressValue# MailserverAddress1: #MSAddressValue1#
MailserverAddress2: #MSAddressValue2# FTPIPAddress: a#FTPIPAddress#a
Vanity Names
  Name Address
Vanity 1 #Vanity1#  #VanityIP1# 
Vanity 2 #Vanity2#  #VanityIP2# 
Vanity 3 #Vanity3#  #VanityIP3# 
Vanity 4 #Vanity4#  #VanityIP4# 
Vanity 5 #Vanity5#  #VanityIP5# 
Added Vanity #CurrentRow# #VanityName# #IPAddress#

D:\NUdomain\#DomainName#.new


#FileOutputString#
Done at #Dateformat(now(), "dd-mmm-yyyy")# #timeformat(now(), "HH:mm")#

Listing of files in directory waiting to be picked up at #TimeFormat(CurrentTime,'HH:mm')# #DateFormat(CurrentTime,'dddd dd mmm yy')#:

SELECT DomainStatus FROM tblDomainDetails WHERE (DomainName = '#DomainRoot#') UPDATE tblDomainDetails SET Flag_OurDNSCreated=True, DomainStatus=#DomainUpdateValue#,MailServerAddress='#MSAddressValue#', MailServerAddress1='#MSAddressValue1#', MailServerAddress2='#MSAddressValue2#', DateUpdated=#CreateODBCDateTime(Now())#, DateDNSCreated=#CreateODBCDateTime(Now())# WHERE (DomainName = '#DomainRoot#')
DomainRoot Name Date Last Modified
#DomainRoot# #Name# #DateLastModified#
NS0 last looked here #DateLastModified# #TimeFormat(Evaluate(CurrentTime-DateLastModified), "m")# minutes #TimeFormat(Evaluate(CurrentTime-DateLastModified), "s")# seconds ago
NS0 visits here every 45 minutes to see if there is something to do. NS0s own internal update job runs every 30 minutes so worst case in 1 hr 15 minutes the update should be live

If NS0 was last here more than 45 minutes ago then this means the job has failed on NS0 - easiest solution is to reboot NS0 (be sure to let Russell know by email) if that doesn't fix it SMS us.