Manual lines in DNS zone file

[quash]

(03-24-2009 05:40 PM)Blondak Wrote:  

(03-24-2009 12:22 AM)quash Wrote:  Hello,

I installed this patch (1.0.0.) no errors (on install)
When i want add new domain, a next error comes forward:
Link: http://admin.deszka.quash.hu/reseller/user_add3.php
error: Unknown column 'domain_dns' in 'field list'

and Domain not added, if i want readd this domain:
error: Duplicate entry 'test.hu' for key 2

if i see ispcp.domain SQL table, no domain_dns row, i add domain_dns (varchar(200) ), i have same new errors.

mysql> describe domain;
+----------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+---------------------+------+-----+---------+----------------+
| domain_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| domain_name | varchar(200) | YES | UNI | NULL | |
| domain_gid | int(10) unsigned | NO | | 0 | |
| domain_uid | int(10) unsigned | NO | | 0 | |
| domain_admin_id | int(10) unsigned | NO | MUL | 0 | |
| domain_created_id | int(10) unsigned | NO | | 0 | |
| domain_created | int(10) unsigned | NO | | 0 | |
| domain_last_modified | int(10) unsigned | NO | | 0 | |
| domain_mailacc_limit | int(11) | YES | | NULL | |
| domain_ftpacc_limit | int(11) | YES | | NULL | |
| domain_traffic_limit | bigint(20) | YES | | NULL | |
| domain_sqld_limit | int(11) | YES | | NULL | |
| domain_sqlu_limit | int(11) | YES | | NULL | |
| domain_status | varchar(255) | YES | | NULL | |
| domain_alias_limit | int(11) | YES | | NULL | |
| domain_subd_limit | int(11) | YES | | NULL | |
| domain_ip_id | int(10) unsigned | YES | | NULL | |
| domain_disk_limit | bigint(20) unsigned | YES | | NULL | |
| domain_disk_usage | bigint(20) unsigned | YES | | NULL | |
| domain_php | varchar(15) | YES | | NULL | |
| domain_cgi | varchar(15) | YES | | NULL | |
| domain_dns | varchar(200) | YES | | NULL | |
+----------------------+---------------------+------+-----+---------+----------------+

(03-17-2009 12:44 AM)Blondak Wrote:  

(03-12-2009 01:16 AM)quash Wrote:  There is somebody at who the module works ?
An above test does not work on a system, though it RC7.
To a stable version when expected patch ?

Hi,
i hope that i will update a check this patch as soon as possible, but i expect hard week for me :-/ so i hope patch will be ready next week. I also update your settings and allow Manual DNS support ( as reseller http://admin.deszka.quash.hu/reseller/do...?edit_id=1 ) than you can add manual lines, overthise page will be redirect to domains_manage.php instead of continue to add_dns.php.
As i wrote i will prepare patch for 1.0 ASAP, because i need it too ( i must upgrade my server) so please be patient.

With regards Blondak

Edit:
I quick check problems found when appling last update and update patch, but i have no time to test it, so feel free to test it, and please let us know.

Blondak

Did you do SQL updates as described in post #1?

Sorry, i dont make new sql table, and alter

Now works without a mistake now, but i can't to add new DNS zone record.

You wrote a link (/reseller/domain_edit.php?edit_id=1) recently, but I was not worth his function entirely.
What I have to add to it how let me be able to record a new entry ?