search

loewexy / pdnsmanager

A simple administration interface for PowerDNS nameserver.
Apache License 2.0
175 stars 48 forks source link

change_date column is dropped since powerdns 4.2.0 #134

Open maeh86 opened 3 years ago

maeh86 commented 3 years ago

Hello together,

with the upgrade from powerdns 4.1 to 4.2, there are two schema-updates for the mysql-database (https://github.com/PowerDNS/pdns/blob/master/modules/gmysqlbackend/4.1.0_to_4.2.0_schema.mysql.sql).

The drop of the column "change_date" leads to several PHP-Errors in the records.php-File:

AH01071: Got error 'PHP message: Slim Application Error:\nType: PDOException\nCode: 42S22\nMessage: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'change_date' in 'field list'\nFile: /var/www/pdnsmanager2/backend/operations/Records.php\nLine: 180\nTrace: #0 /var/www/pdnsmanager2/backend/operations/Records.php(180): [...]

I bypassed this errors by manually inserting this column again, but I think, pdnsmanager should be edited to get along with the acutal schema of powerdns 👍

thanks and best regards, Markus

bertvandepoel commented 1 year ago

I had the same issue. Ended up adding change_data column back just like you did, but I agree that this should be updated in pdnsmanager.