MySQL query failed: Unknown column 'server_version' in 'field list'

[ziggie216]

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

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




what should I do about this error message? I had it upgraded to 8.2 awhile ago.

 

[dirty@]

you say you upgraded to 8.2, but plesk base version is still 8.1.0 as you see, i.e. the upgrade was interrupted in the middle..

closely examine /tmp/autoinstaller3.log file to see at what step upgrade failed and try to remove failure reason if it is possible.. then you will need to finish the upgrade..

 

[ziggie216]

Could I force install 8.2.0? in the updater, it shows 8.2.0 as green check mark

# more autoinstaller3.log


Autoinstaller 3.2.0 (build at 2007-07-05 20:43 svn rev. 86947) started at (timezone PST) Tue Oct 30 19:46:28 2007
Command line args: /usr/local/psa/admin/bin/autoinstaller --enable-xml-output --source-type=plesk --show-releases --target=/root/psa

Try to find rcfile...
Autoinstaller rcfile not found.
Check hostname is sucessfull.
Virtuozzo envID: 510
Opsys detected as: os_name=Linux os_vendor=FedoraCore version=1 arch=i686 environment=vz
Final opsys (with overriding) is: os_name=Linux os_vendor=FedoraCore version=1 arch=i686 environment=vz
FileFetcher new object: target_dir=/root/psa/, main_source_url=http://autoinstall.plesk.com/
Environment locale name is 'C'
Downloading the file products.inf3: Filefetcher: get file products.inf3
100% done.
Downloading the file plesk.inf3: Filefetcher: get file plesk.inf3
13%..53%..100% done.
Downloading the file sitebuilder.inf3: Filefetcher: get file sitebuilder.inf3
100% done.
repository: Get brief packages info for all sources
Checking for installed packages... readSystemPackagesBrief: execute rpm -qa --queryformat 'F:system_installed_brief_%{NAME}-%{VERSION}-%{RELEASE}.rpm\nN:%{NAME}\nE:%{EPOCH}\nV:%{VERSION}\nL:%{RELEASE}\nA:%{A
RCH}\nf:%{INSTALLTIME}\nB:%{BUILDTIME}\nX:\n'
done
Remove not actual releases
 (update package names cache) build for Linux FedoraCore 1 i386 (PSA_8.2.0/plesk-8.2.0-fc1-i386.inf3) is fit
release PLESK_8_2_0 is actual
build for Linux FedoraCore 1 i386 (PSA_8.2.1/plesk-8.2.1-fc1-i386.inf3) is fit
release PLESK_8_2_1 is actual
build for Linux FedoraCore 1 i386 (SiteBuilder/SiteBuilder_3.0.0/sitebuilder-3.0.0-fc1-i386.inf3) is fit
release SB_3_0_0 is actual
build for Linux FedoraCore 1 i386 (SiteBuilder/SiteBuilder_3.0.1/sitebuilder-3.0.1-fc1-i386.inf3) is fit
release SB_3_0_1 is actual
build for Linux FedoraCore 1 i386 (SiteBuilder/SiteBuilder_3.0.2/sitebuilder-3.0.2-fc1-i386.inf3) is fit
release SB_3_0_2 is actual
build for Linux FedoraCore 1 i386 (SiteBuilder/SiteBuilder_4.0.0/sitebuilder-4.0.0-fc1-i386.inf3) is fit
release SB_4_0_0 is actual
Select best build of PLESK_8_2_0 for current OS
build for Linux FedoraCore 1 i386 (PSA_8.2.0/plesk-8.2.0-fc1-i386.inf3) is fit
First fit build is current best: PSA_8.2.0/plesk-8.2.0-fc1-i386.inf3
Select best build: finally choised PSA_8.2.0/plesk-8.2.0-fc1-i386.inf3
Downloading the file PSA_8.2.0/plesk-8.2.0-fc1-i386.inf3: Filefetcher: get file PSA_8.2.0/plesk-8.2.0-fc1-i386.inf3
100% done.
build for Linux FedoraCore 1 i386 (/root/psa/PSA_8.2.0/plesk-8.2.0-fc1-i386.inf3) is fit
repository: Get brief packages info for all sources
Detecting installed product components.
Component base: mode up2date,  installed=1186489745,  available=1186489745
Component base have no older version, so keyupdate not needed
Component psa-autoinstaller: mode up2date,  installed=1183643461,  available=1183643461
Component asp: mode up2date,  installed=1183721214,  available=1183721214
Component mailman: mode up2date,  installed=1183721114,  available=1183721114
Component postgresql: mode install,  installed=0,  available=1069791522
Component java: mode install,  installed=0,  available=1183720368
Component spamassassin: mode up2date,  installed=1183721217,  available=1183721217
Component rblsmtpd: mode up2date,  installed=1183720380,  available=1183720380
Component mod_python: mode up2date,  installed=1075819847,  available=1075819847
Component ruby: mode install,  installed=0,  available=1183721130
Component fcgi: mode up2date,  installed=1160388703,  available=1160388703
Component vault: mode up2date,  installed=1186465980,  available=1186465980
Component horde-comps: mode up2date,  installed=1183721053,  available=1183721053
Component docs: mode up2date,  installed=1183721038,  available=1183721038
Component backup-vz: mode up2date,  installed=1183721126,  available=1183721126
Component drweb: mode install,  installed=0,  available=1183720224
Component kav: mode install,  installed=0,  available=1186552613
Component ppwse: mode install,  installed=0,  available=1186489757
Component api: mode up2date,  installed=1183720325,  available=1183720325
Component sshterm: mode up2date,  installed=1183720088,  available=1183720088
Component pmm: mode up2date,  installed=1183721094,  available=1183721094
Component psa-firewall: mode up2date,  installed=1183720355,  available=1183720355
Component cs-gs: mode install,  installed=0,  available=1183720341
Component psa-vpn: mode install,  installed=0,  available=1183721029
Component battlefield: mode install,  installed=0,  available=1183721062
Component bf2: mode install,  installed=0,  available=1183721122
Component psa-fileserver: mode install,  installed=0,  available=1183720312
Component watchdog: mode up2date,  installed=1183721089,  available=1183721089
Component sitebuilder: mode install,  installed=0,  available=1182877783
Component sb-publish: mode install,  installed=0,  available=1160552709
Component cf-support: mode install,  installed=0,  available=1183721124
Component miva: mode install,  installed=0,  available=1183721135
Component sso: mode install,  installed=0,  available=1183721153
Component de-DE-locale: mode install,  installed=0,  available=1186044524
Component ja-JP-locale: mode install,  installed=0,  available=1186044540
Component es-ES-locale: mode install,  installed=0,  available=1186044531
Component ru-RU-locale: mode install,  installed=0,  available=1186044554
Component fr-FR-locale: mode install,  installed=0,  available=1186044534
Component it-IT-locale: mode install,  installed=0,  available=1186044538
Component zh-CN-locale: mode install,  installed=0,  available=1186044560
Component zh-TW-locale: mode install,  installed=0,  available=1186044562
Check for components requires keyupdate
Exchanging information with licensing server.
KeyUpdateChecker::doCheck: no components for check key update

 

[Ladmin]

Hi,

plesk upgrade failed. In the excerpt of the log file there is nothing clear to find out plesk upgrade failure. Now I suggest checking psa main package version, and psa version:

# rpm -q psa
# cat /usr/local/psa/version

and it will be great if you find more details in autoinstaller3.log. before go further you need to figure out why pleks upgrade failed, fix these errors and do upgrade with force options:

# rpm -Uhv --force ...