Powerdns module and postgres backend

[Vasia911]

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 ?

[d4f]

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.

[Vasia911]

Hi!
Bug is fixed by support team.
Now everything works