1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Error: Unable to remove domains after upgrade to 8.6

Discussion in 'Plesk for Windows - 8.x and Older' started by colinjack, Dec 6, 2008.

  1. colinjack

    colinjack Guest

    0
     
    Having upgraded from 7.6.1 to 8.6.0.5 I found loads of missing tables, but have managed to fix most of the problems. I have now got: Error: Unable to remove domains: Problems occured while removing domains: DB query failed: Table 'psa.cf_dsn' doesn't exist ... when I try and delete domains. <groan>

    Can anybody help with creating the missing table? I think I will also need to create psa.cf_dsn_parameters?

    Thanks

    Colin
     
  2. alta

    alta Regular Pleskian

    26
     
    Joined:
    Sep 27, 2007
    Messages:
    118
    Likes Received:
    0
    From the error message I suppose that the issue in missed Plesk table 'cf_dsn'. Please check it with the following article: http://kb.odin.com/en/3472. If table is missing, please try to insert it using the followig query:

    CREATE TABLE `cf_dsn` (

    `id` int(10) unsigned NOT NULL auto_increment,

    `domain_id` int(10) unsigned NOT NULL default '0',

    `dsn_name` varchar(64) NOT NULL default '',

    `driver_name` varchar(255) NOT NULL default '',

    `description` varchar(255) default NULL,

    `is_valid` enum('false','true') NOT NULL default 'false',

    PRIMARY KEY (`id`),

    UNIQUE KEY `dsn_name` (`domain_id`,`dsn_name`),

    KEY `domain_id` (`domain_id`)

    );
     
  3. colinjack

    colinjack Guest

    0
     
    Thanks Alta. I had already realized that quite a few new tables and fields were missing after the upgrade so loaded a copy of the latest version onto a new macine and then did a table by table comparison. Where I found something missing I did a dump and import ... took ages, but still can't remove the domain because now it won't delete the database :(

    I just wish Parallels would provide some decent support with their updates. Everytime I update it breaks.

    I think the easiest is going to be to pay them to fix it (as I have had to do in the past).
     
Loading...