After creating a new subscription in Plesk DNS records are not visible. Restore data from DNS records template not helped.
mysql> select id from psa.dns_recs where id=0;
| id |
| 0 |
1 row in set (0.01 sec)
The problem caused by corrupted record in the '
' table, by unknown reason the table has record with
. Plesk is using
statemenet to insert data into autoincrement field, usually the table do not have an autoincrement field with
. As a result, all data written by MySQL into this record.
Delete invalid record from the table:
mysql> delete from psa.dns_recs where id=0;