PowerDNS Error

[galluccib]

I'm trying to add a record and getting the following error. Not sure if I missed the setup instructions somewhere that outlined setting up phpipam with powerdns.

The error is....

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'disabled' in 'field list'

[perkooo]

Hi,

I had the same problem. You probably added in MySQL (or MariaDB) an older version of PowerDNS so there are some columns that you don't have.
Use the officiel documentation here : to create database.
The column that you don't have : "disabled TINYINT(1) DEFAULT 0," and some others.

[galluccib]

Worked great.... Thanks!

[playnet]

Hi,

I had the same problem. You probably added in MySQL (or MariaDB) an older version of PowerDNS so there are some columns that you don't have.
Use the officiel documentation here : to create database.
The column that you don't have : "disabled TINYINT(1) DEFAULT 0," and some others.

no field in https://doc.powerdns.com/authoritative/backends/generic-mysql.html#default-schema

[playnet]

maybe add correct .sql to repo. to /var/www/html/db?