8.2 Upgrade Fails

[phoenixisp]

Dave, you need SSH access to do this. If you do, here's how to get into mysql:

#mysql -u -p`cat /etc/psa/.psa.shadow`

 

[Group One Sales]

I got in and did that and now get a new error message.

Service is not available now, probably your Plesk is misconfigured.
Contact Your provider for details.

Internal Plesk error occurred: MySQL query failed: Unknown column 'server_version' in 'field list'

Thanks for any helpm here.
Dave

 

[tiramisu]

it looks like plesk db was not upgraded properly.
what is the output of:

# rpm -q psa; rpm -qa | grep psa-hotfix; cat /usr/local/psa/version

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"select * from misc where param='version'"

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"select * from upgrade_history"

 

[Group One Sales]

Plesk Failed

After several tries I finally got a response from SSH

It is as follows:

compress FALSE
database (No default value)
delimiter ;
vertical FALSE
force FALSE
named-commands FALSE
local-infile FALSE
no-beep FALSE
host (no default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 3306
prompt mysql>
quick FALSE
raw FALSE
reconnect FALSE
socket (No default value)
ssl FALSE
ssl-key (No default value)
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cipher (No default value)
table FALSE
debug-info FALSE
user admin
safe-updates FALSE
connect_timeout 0
max)allowed_packet 16777216
net_buffer-length 16384
select_limit 1000
max_join_size 1000000
secure-auth FALSE