value NULL in dns_ttl after edit in form designer

Discussion in 'General' started by SupuS, Nov 13, 2009.

  1. SupuS

    SupuS Member HowtoForge Supporter

    value NULL in dns_ttl after edit in form designer [solved]

    Hi all

    I edited DNS ttl end DNS expire value in form designer folowed this thread:

    http://www.howtoforge.com/forums/showthread.php?t=12086

    Now when I create new web with DNS records than in DNS expire and DNS ttl has NULL value in database. Zone files has empty value on ttl and expire lines too and bind report error:

    Code:
    zone domain.com/IN: loading from master file pri.domain.com failed: unexpected end of input
    I revert changes to defalt values but in database is still NULL value after create new web/dns record.

    Unfortunatelly I have corrupted backup of ispconfig database so I cannot revert changes but I compared affected values in doctype table on different ispconfig server and it is the same.

    Thanks for any idea
    SupuS
     
    Last edited: Nov 13, 2009
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Try to set the default values with phpmyadmin for the database columns.
     
  3. SupuS

    SupuS Member HowtoForge Supporter

    Hi till

    Do you mean in dns_isp_dns table? I set values dns_expire and dns_ttl manually with phpmyadmin and used writeconf.php for update zone files and everything is ok.

    But when I create new web/domain/dns record than in database is NULL expire and ttl value for this new domain again.

    When I go to dns manager => new domain => options and click to save than value in database is correct.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    I'am talking about setting the column defaults in phpmyadmin and not the actual values.
     
  5. SupuS

    SupuS Member HowtoForge Supporter

    Ah I see :) I set default values for columns and its working again.

    Is it safe to change this default values instead of using form designer?

    Thanks a lot
    SupuS
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    > Is it safe to change this default values instead of using form designer?

    Yes
     

Share This Page