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

Plesk installation problems

Discussion in 'Plesk for Linux - 8.x and Older' started by kevlers, Apr 3, 2006.

  1. kevlers

    kevlers Guest

    0
     
    Hello,

    I attempted to upgrade my Plesk control panel to version 8.0. I tried using the control panel auto-update feature, which failed. When I log in to the control panel, the following error message appears:

    ERROR: PleskMainDBException
    MySQL query failed: Table 'psa.DashboardPreset' doesn't exist

    Additionally, an exception has occurred while trying to report this error: PleskMainDBException
    MySQL query failed: Table 'psa.DashboardPreset' doesn't exist
    0: /usr/local/psa/admin/plib/common_func.php3:229
    db_query(string 'replace DashboardPreset set `id`='0', `name`='1', `type`='custom', `uri`='/plesk/dashboard/')
    1: /usr/local/psa/admin/plib/class.Table.php:324
    Table->update(array)
    2: /usr/local/psa/admin/plib/class.cObject.php:330
    cObject->update()
    3: /usr/local/psa/admin/plib/dashboard/DashboardPreset.php:185
    DashboardPreset->update()
    4: /usr/local/psa/admin/plib/user/User.php:335
    User->addDashboardRecent(object of type UIPointer)
    5: /usr/local/psa/admin/plib/class.Form.php:477
    Form->FastPrint()
    6: /usr/local/psa/admin/htdocs/domains/domains.php3:289

    ---

    Trying to apply 8.0.0 changes to database...
    ERROR while trying to upgrade SQL database from 750
    Check the error reason(see log file: /tmp/psa_8.0.0_RedHat_el3_build80060331.13_upgrade.log), fix and try again

    Aborting...

    error: %post(psa-8.0.0-rhel3.build80060331.13) scriptlet failed, exit status 1

    ---
    upgrade.log output:
    ---


    Trying to apply 8.0.0 changes to database... ERROR 1062 at line 179: Duplicate entry 'Data-mysql' for key 2
    /var/tmp/rpm-tmp.84918: line 14189: 11462 Broken pipe perl -e '$has_command = 0;
    $program = $ARGV[0];
    splice (@ARGV, 0, 1);
    sub remove_chasets($)
    {
    $refStr = shift;
    $$refStr =~ s/(\b(character\s+set|collate)\s+[\w]+\b)//ig;
    }
    foreach $n (0 .. $#ARGV) {
    if ($ARGV[$n] eq "-e") {
    $has_command = 1;
    remove_chasets \($ARGV[$n + 1]);
    }
    }
    if ($has_command) {
    exec $program, @ARGV or die "Cannot exeecute mysql";
    } else {
    open out_command, "|-", $program, @ARGV or die "Cannot start mysql";
    while (<STDIN>) {
    remove_chasets \($_);
    print out_command $_;
    }
    close out_command or die($! ? "Mysql returned an error: $!" : "Mysq exited with non-zero status $?");
    }' -- "$@"
    ERROR 1105 at line 1: Unknown error

    ERROR while trying to upgrade SQL database from 750

    Aborting...



    Does anyone have any suggestions? Would it be possible to delete all the RPMs related to Plesk 8.0, reinstall 7.5, and then restore the psa database? Let me know if this would work.

    Thanks,
    Kevin
     
  2. Inaba

    Inaba Guest

    0
     
    Yes, delete all the Plesk 8 RPMs, reinstall the 7.5.4 ones, and then restore your PSA database and you'll be back to 7.5.4
     
  3. CiViX

    CiViX Guest

    0
     
  4. Blade_X

    Blade_X Guest

    0
     
    I want to remove all the 8 RPM's but with all the dependencies..

    I'm quite new to this, but how do I easlily remove them?

    thx in advance
     
  5. arazas

    arazas Guest

    0
     
    I also need guidelines to remove PLESK 8 rpm safely. Please advice needfull.

    How to safely recover towards Plesk 7.5.4. Please help us senior guys.
     
Loading...