Plesk 8.1.1 Update Problem

[valor]

Hey,

I tried updating plesk this evening from 8.1 to 8.1.1 but after i received a email from the auto installer all the sites where down. So i checked if there where any auto process running which was not the case rebooted the server but no websites online.

I am getting the following error. What can i do 2 fix it. I tried running the updater again no luck :S

ERROR: PleskMainDBException  	
Up LevelUp Level
MySQL query failed: Table 'psa.ai_vendor_sources' doesn't exist

0: /usr/local/psa/admin/plib/common_func.php3:211
    db_query(string 'SELECT id, type, url, priority, enabled, auth_required, login, password FROM ai_vendor_sources')
1: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerVendorSource.php:142
    AutoInstallerVendorSource::getVendorSources()
2: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerManager.php:209
    AutoInstallerManager->install(string 'PLESK_8_1_1', array, boolean false, string 'adminstrator@*****.**', boolean true)
3: /usr/local/psa/admin/htdocs/server/autoinstaller_install.php:105

 

[valor]

Any one? SWSoft crew???

I tried running the auto installer on the console but i get failed dependencies errors

 

[dasmo]

Distribution?

 

[valor]

Fedore Core 5

 

[dasmo]

Try connecting to your mysql database (use the username admin and the plesk password)


Then type "use psa"

Then paste this:


CREATE TABLE `ai_vendor_sources` (
`id` int(10) unsigned NOT NULL auto_increment,
`type` enum('repomd','directory') NOT NULL default 'repomd',
`url` varbinary(255) NOT NULL default '',
`priority` int(10) unsigned NOT NULL default '500',
`enabled` enum('false','true') NOT NULL default 'true',
`auth_required` enum('false','true') NOT NULL default 'false',
`login` varbinary(255) default NULL,
`password` varbinary(255) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



Should fix it.

 

[valor]

Sadly it didnt fix the problem still no sites. Tried remote reinstalling plesk but i get

Start packages installation
Install package psa-api-rpc-8.1.1-fc5.build81070404.14.noarch, psa-api-8.1.1-fc5.build81070404.14.noarch
error: Failed dependencies:
        psa-api-rpc = 8.1.0-fc5.build81061226.14 is needed by (installed) psa-backup-manager-8.1.0-fc5.build81061226.14.i586
        psa-api = 8.1.0-fc5.build81061226.14 is needed by (installed) psa-migration-manager-8.1.0-fc5.build81061226.14.i586
ERROR: Error while execute command rpm -U /root/swsoft/PSA_8.1.1/dist-rpm-FedoraCore-5-i386/opt/api/psa-api-rpc-8.1.1-fc5.build81070404.14.noarch.rpm /root/swsoft/PSA_8.1.1/dist-rpm-FedoraCore-5-i386/base/psa-api-8.1.1-fc5.build81070404.14.noarch.rpm
Errors just before:
- Error while execute command rpm -U /root/swsoft/PSA_8.1.1/dist-rpm-FedoraCore-5-i386/opt/api/psa-api-rpc-8.1.1-fc5.build81070404.14.noarch.rpm /root/swsoft/PSA_8.1.1/dist-rpm-FedoraCore-5-i386/base/psa-api-8.1.1-fc5.build81070404.14.noarch.rpm

ERROR: Installation failed

Every time

 

[dasmo]

That's a different error at least. Looks like a dependency problem.

psa-api-rpc
psa-api


Try installing the Plesk API at the same time. Looks like some of the things you use need it.

 

[valor]

Yeah most likey but the Plesk Auto installer installs the 2 rpms at the same time and i still get the dependency error.

 

[SomebodySysop]

What was the resolution here?

 

[oatmeal@]

Just remove the psa-api-rpc and psa-api packages. You may have to force it.

I don't know why the updater doesn't handle these dependency errors better.

 

[valor]

no i dont know why it didnt work but i finally gave up and reinstall installed the server.