records not entering

Post Reply
hb_jsy
Registered
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/domain.com/modules/addons/solutedns/lib/Core/Dns/Records.php:305\nStack trace:\n#0 /var/www/domain.com/modules/addons/solutedns/lib/Core/Dns/Records.php(305): PDO->query()\n#1 /var/www/domain.com/modules/addons/solutedns/lib/Admin/Controller.php(1056): solutedns\\Dns\\Records->add()\n#2 /var/www/domain.com/modules/addons/solutedns/lib/Admin/AdminDispatcher.php(58): WHMCS\\Module\\Addon\\SoluteDNS\\Admin\\Controller->post()\n#3 /var/www/domain.com/modules/addons/solutedns/solutedns.php(406): WHMCS\\Module\\Addon\\SoluteDNS\\Admin\\AdminDispatcher->dispatch()\n#4 /var/www/domain.com/admin/addonmodules.php(0): solutedns_output()\n#5 {main} in /var/www/domain.com/modules/addons/solutedns/lib/Core/System/Core.php:89\nStack trace:\n#0 [internal function]: solutedns\\System\\Core->solutedns\\System\\{closure}()\n#1 {main}\n thrown in /var/www/domain.com/modules/addons/solutedns/lib/Core/System/Core.php on line 89, referer: https://domain.com/admin/addonmodules.p ... anage&id=8

the database and ssh connection tests both complete OK.
User avatar
Daniel
Support
Posts: 204
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