Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 13th November 2009, 13:28
SupuS SupuS is offline
HowtoForge Supporter
 
Join Date: May 2006
Posts: 202
Thanks: 68
Thanked 14 Times in 12 Posts
Default 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 by SupuS; 13th November 2009 at 16:22.
Reply With Quote
Sponsored Links
  #2  
Old 13th November 2009, 15:16
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,490
Thanks: 835
Thanked 5,526 Times in 4,346 Posts
Default

Try to set the default values with phpmyadmin for the database columns.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 13th November 2009, 15:49
SupuS SupuS is offline
HowtoForge Supporter
 
Join Date: May 2006
Posts: 202
Thanks: 68
Thanked 14 Times in 12 Posts
Default

Quote:
Originally Posted by till View Post
Try to set the default values with phpmyadmin for the database columns.
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.
Reply With Quote
  #4  
Old 13th November 2009, 15:52
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,490
Thanks: 835
Thanked 5,526 Times in 4,346 Posts
Default

I'am talking about setting the column defaults in phpmyadmin and not the actual values.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
SupuS (13th November 2009)
  #5  
Old 13th November 2009, 16:21
SupuS SupuS is offline
HowtoForge Supporter
 
Join Date: May 2006
Posts: 202
Thanks: 68
Thanked 14 Times in 12 Posts
Default

Quote:
Originally Posted by till View Post
I'am talking about setting the column defaults in phpmyadmin and not the actual values.
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
Reply With Quote
  #6  
Old 13th November 2009, 16:29
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,490
Thanks: 835
Thanked 5,526 Times in 4,346 Posts
 
Default

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

Yes
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot delete domain, Recycle Bin Won't Empty crypted Installation/Configuration 3 30th December 2010 19:26
Admin Program for Virtual Users and Domains Postfix courier etc...(Ubuntu 8.04)? the1rob HOWTO-Related Questions 11 4th August 2009 05:54
Loads of mysql connections to dbispconfig StrikerNL General 2 5th March 2009 15:31
Can't do it. Mono-Project BullyWug Installation/Configuration 6 15th April 2007 12:27
Problem with the apache (I can't start ist) M.Behrens Installation/Configuration 11 31st March 2006 11:48


All times are GMT +2. The time now is 21:25.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.