Plesk installation problems

[kevlers]

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

 

[Inaba]

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

 

[CiViX]

Take a look at my fix here (only replace "teste" and "Teste" for your values "data" and "Data"):

http://forum.swsoft.com/showthread.php?s=&postid=144668#post144668

 

[Blade_X]

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

 

[arazas]

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.