Can not create new domain

[trinv]

Mar 22 08:44:33 ns01 pdns_server[145457]: [webserver] 2caac540-46fd-4ce9-a2f6-03a337c083de HTTP ISE for "/api/v1/servers/localhost/zones": Exception: GSQLBackend unable to list keys: Could not prepare statement: select cryptokeys.id, flags, active, published, content from domains, cryptokeys where cryptokeys.domain_id=domains.id and name=?: Unknown column 'published' in 'field list'
Mar 22 08:44:33 ns01 gunicorn[142533]: [2022-03-22 08:44:33,528] [domain.py:252] ERROR - Cannot add domain test.com. Error while fetching http://10.0.1.9:8081/api/v1/servers/localhost/zones. Returned status 500 and content Internal Server Error

Mar 22 08:46:42 ns01 pdns_server[145457]: [webserver] d4416c68-8e6c-41f7-bc06-fa0580d66abb HTTP ISE for "/api/v1/servers/localhost/zones": Exception: GSQLBackend unable to list keys: Could not prepare statement: select cryptokeys.id, flags, active, published, content from domains, cryptokeys where cryptokeys.domain_id=domains.id and name=?: Unknown column 'published' in 'field list'
Mar 22 08:46:42 ns01 gunicorn[142533]: [2022-03-22 08:46:42,568] [domain.py:168] ERROR - Cannot update domain table. Error: Error while fetching http://10.0.1.9:8081/api/v1/servers/localhost/zones. Returned status 500 and content Internal Server Error

[trinv]

Hi, i found how to fix it:
exec this command in mysql:

https://github.com/PowerDNS/pdns/blob/master/modules/gmysqlbackend/4.2.0_to_4.3.0_schema.mysql.sql

mysql -u root -p

use powerdns;
ALTER TABLE cryptokeys ADD published BOOL NULL DEFAULT 1 AFTER active;
quit;

systemctl restart mariadb
systemctl restart pdns
systemctl restart powerdns-admin