records not entering

Post Reply
Posts: 1
Joined: 13 Apr 2021, 14:35

hi hoping you can help.

trying to add a new record to a zone but it doesnt seem to be updating the php logs are showing

[Tue Apr 13 20:04:00.210758 2021] [php7:error] [pid 1274] [client XXX.XXX.XXX.XXX:65374] PHP Fatal error: Uncaught Exception: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'change_date' in 'field list' in /var/www/\nStack trace:\n#0 /var/www/ PDO->query()\n#1 /var/www/ solutedns\\Dns\\Records->add()\n#2 /var/www/ WHMCS\\Module\\Addon\\SoluteDNS\\Admin\\Controller->post()\n#3 /var/www/ WHMCS\\Module\\Addon\\SoluteDNS\\Admin\\AdminDispatcher->dispatch()\n#4 /var/www/ solutedns_output()\n#5 {main} in /var/www/\nStack trace:\n#0 [internal function]: solutedns\\System\\Core->solutedns\\System\\{closure}()\n#1 {main}\n thrown in /var/www/ on line 89, referer: ... anage&id=8

the database and ssh connection tests both complete OK.
User avatar
Posts: 207
Joined: 02 Aug 2013, 17:50

Thank you for your post. The change_date column was removed after PowerDNS v4.2. If you use a Core version prior to v1.20.001 together with a PowerDNS v4.2 or later this error might occur. I would recommend to update the SoluteDNS Core to a more recent version.
Post Reply