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


    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
    2: /usr/local/psa/admin/plib/class.cObject.php:330
    3: /usr/local/psa/admin/plib/dashboard/DashboardPreset.php:185
    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
    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


    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


    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.

  2. Inaba

    Inaba Guest

    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

  4. Blade_X

    Blade_X Guest

    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

    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.