Author Topic: Powerdns module and postgres backend  (Read 88 times)

0 Members and 1 Guest are viewing this topic.

Offline Vasia911

  • 3
  • 0
  • New Member
  • *
Powerdns module and postgres backend
« on: May 14, 2019, 09:23:04 AM »
Hi!

I have a problem after update powerdns module.

PowerDNS (class.powerdns.php) - local version: 2.20181119 - Work fine

Аn error occurs in other new versions:

   Module (DNS_Zone_editor): The zone <xx> was not found.
   The zone does not exist

After debugging postgres queryes i find a problem

     > ОШИБКА:  ошибка синтаксиса (примерное положение: "`") (символ 60)
     > ОПЕРАТОР:  SELECT id, domain_id, name, type, content, ttl, prio, 0 as `change_date` FROM records WHERE domain_id = $1 ORDER BY domain_id, id ASC

wrong quotes in sql query!

Please help! How can i fix it ?





Offline d4f

  • 130
  • 6
  • Community Managers
  • Active Participant
  • ****
Re: Powerdns module and postgres backend
« Reply #1 on: May 15, 2019, 04:40:58 AM »
Contact Hostbill support to fix the issue. You cannot edit their code as it is encrypted. Backtick is a valid SQL quote, I'm less sure about the "0" it shows directly before.

Offline Vasia911

  • 3
  • 0
  • New Member
  • *
Re: Powerdns module and postgres backend
« Reply #2 on: May 21, 2019, 10:18:41 AM »
Hi!
Bug is fixed by support team.
Now everything works :)