K
kevlers
Guest
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
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