• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Resolved Error in backup

LunDys

New Pleskian
Hi,

I'm getting this error on the Plesk Obsidian 18.0.32 in the backup:

DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.dns_recs' doesn't exist, query was: DESCRIBE `dns_recs`

Server never handled dns records for the domains and no domains are back upped due to this error.

How to solve this error?
 
Have you tried

# plesk repair db

Also you can create lost table manually with help of:

Code:
MariaDB [psa]> show create table dns_recs\G
*************************** 1. row ***************************
       Table: dns_recs
Create Table: CREATE TABLE `dns_recs` (
  `time_stamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dns_zone_id` int(10) unsigned DEFAULT NULL,
  `type` enum('NS','A','AAAA','CNAME','MX','PTR','TXT','AXFR','SRV','DS','CAA','master','none') NOT NULL DEFAULT 'A',
  `host` varchar(255) NOT NULL,
  `displayHost` varchar(255) NOT NULL,
  `val` text NOT NULL,
  `displayVal` text NOT NULL,
  `opt` varchar(255) NOT NULL DEFAULT '',
  `external_id` varchar(255) DEFAULT NULL,
  `ttl` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dns_zone_id` (`dns_zone_id`),
  KEY `host` (`host`),
  KEY `type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=1094 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
 
Back
Top