Error: Unknown column 'active' in 'field list'

[TWC]

I get a Unknown column 'active' in 'field list' error when creating a dns record.

I have rechecked all setting and I am stumped.

Any help will be appreciated.

Tc

[falko]

You must add the column "active" to your soa table, as outlined here: http://www.howtoforge.com/mydns_name_server

mysql -u root -p
Enter password:
ALTER TABLE mydns.soa ADD COLUMN active ENUM('Y','N') NOT NULL;
ALTER TABLE mydns.soa ADD INDEX (active);
ALTER TABLE mydns.soa ADD COLUMN xfer CHAR(255) NOT NULL;
quit;

[TWC]

That fixed the active error. But now I get

Error:
You don't have the permission to view this record or this record does not exist!

I have setup several records, started testing and now I can't modify any record or user.

Any HELP will be appreciated.

TWC

[falko]

Please check the settings for the admin user under "System", especially if the module "dns" is enabled for admin.

[TWC]

System? Can you guide me a little more? DB, table, column, entry, etc or are you referring to a different conf?

Im running
FreeBSD 6
MySQL 5

Also this seems to occur after adding another user. The first time I deleted all DBs and reinstalled. I don't want to do that again?

Great work!!!

THANX

[falko]

Originally Posted by TWC

System? Can you guide me a little more? DB, table, column, entry, etc or are you referring to a different conf?

I'm referring to the MyDNSConfig web interface. There's a tab "System" where you can manage users.

[TWC]

In system I select admin and get error:

Error:
You don't have the permission to view this record or this record does not exist!

[falko]

Please check what's in your sys_user table:

mysql -u root -p
USE mydns;
SELECT * FROM sys_user;
quit;

What's the output of the SELECT statement?

[TWC]

mysql> SELECT * FROM sys_user;
+--------+------------+-------------+---------------+----------------+----------------+----------+----------------------------------+-----------+-------------+-----------+-------+--------+------+---------+-------------+---------+-----+-----+------+-------+-----+---------+-----+----------+--------+---------------+
| userid | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | username | passwort                         | modules   | startmodule | app_theme | typ   | active | name | vorname | unternehmen | strasse | ort | plz | land | email | url | telefon | fax | language | groups | default_group |
+--------+------------+-------------+---------------+----------------+----------------+----------+----------------------------------+-----------+-------------+-----------+-------+--------+------+---------+-------------+---------+-----+-----+------+-------+-----+---------+-----+----------+--------+---------------+
|      4 |          3 |           0 | riud          | riud           |                | test     | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | admin,dns | admin       | default   | admin |      1 |      |         |             |         |     |     |      |       |     |         |     | en       |        |             0 |
|      3 |          1 |           0 | riud          | riud           |                | admin    | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | admin,dns | dns         | default   | admin |      1 |      |         |             |         |     |     |      |       |     |         |     | en       |        |             0 |
+--------+------------+-------------+---------------+----------------+----------------+----------+----------------------------------+-----------+-------------+-----------+-------+--------+------+---------+-------------+---------+-----+-----+------+-------+-----+---------+-----+----------+--------+---------------+
2 rows in set (0.01 sec)

[falko]

How did you manage to have 3 as userid for admin? Should be 1.
For me it looks like this:

+--------+------------+-------------+---------------+----------------+----------------+----------+----------------------------------+-----------+-------------+-----------+-------+--------+------+---------------+-------------+---------+-----+-----+------+-------+-----+---------+-----+----------+--------+---------------+
| userid | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | username | passwort                         | modules   | startmodule | app_theme | typ   | active | name | vorname       | unternehmen | strasse | ort | plz | land | email | url | telefon | fax | language | groups | default_group |
+--------+------------+-------------+---------------+----------------+----------------+----------+----------------------------------+-----------+-------------+-----------+-------+--------+------+---------------+-------------+---------+-----+-----+------+-------+-----+---------+-----+----------+--------+---------------+
|      1 |          1 |           0 | riud          | riud           |                | admin    | 098f6bcd4621d373cade4e832627b4f6 | dns,admin | dns         | default   | admin |      1 |      | Administrator |             |         |     |     |      |       |     |         |     | en       |        |             0 |
+--------+------------+-------------+---------------+----------------+----------------+----------+----------------------------------+-----------+-------------+-----------+-------+--------+------+---------------+-------------+---------+-----+-----+------+-------+-----+---------+-----+----------+--------+---------------+
1 row in set (0.00 sec)

You can correct this by running

UPDATE sys_user SET userid = '1' WHERE username = 'admin';