• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Domain setup error

C

cyleung

Guest
Hello,

I am trying to setup SSL on my domain and got the SSL cert. in place.
But when I tried to assign the domain to the SSL cert. by going to Domain -> Setup
I got the following error, I got the same error after I ran the plesk repair...

DB query failed: Table 'psa.protected_dirs' doesn't exist
---------------------- Debug Info -------------------------------
0: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\common_func.php3:209
db_query(string 'select id, path, realm from protected_dirs where dom_id=1 and dom_type="domain"')
1: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\class.ProtectedDirsList.php:40
ProtectedDirsList->fetchProtectedDirsList()
2: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\class.ProtDir.php:324
ProtDir->checkDuplicates()
3: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\class.PHostingManager.php:239
PHostingManager->getPleskStatPDir()
4: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\class.PHostingManager.php:213
PHostingManager->isPleskStatProtected()
5: C:\Program Files (x86)\SWsoft\Plesk\admin\plib\class.PHostingManager.php:2205
PHostingForm->assign(object of type PHostingManager, boolean true, boolean true, boolean true, boolean false)
6: C:\Program Files (x86)\SWsoft\Plesk\admin\htdocs\domains\hosting\phosting_setup.php:265


Thanks

CY

PS: Is there a KB article that talks about SSL setup with plesk and IIS 6.0?
 
Hi,

Plesk database is corrupted.

Here is an protected_dirs table structure.

CREATE TABLE `protected_dirs` (
`id` int(10) unsigned NOT NULL auto_increment,
`non_ssl` enum('false','true') NOT NULL default 'false',
`ssl` enum('false','true') NOT NULL default 'false',
`realm` varchar(255) default NULL,
`path` varchar(245) NOT NULL default '',
`dom_id` int(10) unsigned NOT NULL default '0',
`dom_type` enum('domain','subdomain') NOT NULL default 'domain',
PRIMARY KEY (`id`),
UNIQUE KEY `dom_id` (`dom_id`,`dom_type`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
Thanks for the response. So how do I recover the database? Is there any other utils to do that?

Could I just simply re-create that table? What data do I have to add to the table?

Thanks a lot
 
Back
Top