Saturday, 24 May 2008

Application Vault Issues

Ok here is how the story goes...

Issue: Application Repo is not working + backup script not working + domains cannot be removed/deleted

After updating Plesk from 8.2.1 to 8.3.0 everything seemed to be working except the application repo..

I was experiensing exact error "Table 'psa.APSClientApplicationItems' doesn't exist" with that guy here http://forum.swsoft.com/showthread.php?t=50070

mostly because I did the same lame thing... copied the directory .. changed the files and woohoo created my own application on repo .. so my clients can use an up to date Greek version of joomla...

I followed the procedure the guy suggested on the forum:
mysql -u admin -p`cat /etc/psa/.psa.shadow ` psa -e "describe APSClientApplicationItems;"

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

DROP TABLE IF EXISTS `APSClientApplicationItems`;
CREATE TABLE `APSClientApplicationItems` (
`id` int(10) unsigned NOT NULL auto_increment,
`client_id` int(10) unsigned NOT NULL default '0',
`app_item_id` int(10) unsigned NOT NULL default '0',
`instances_limit` int(11) NOT NULL default '-1',
PRIMARY KEY (`id`),
UNIQUE KEY `client_id_2` (`client_id`,`app_item_id`),
KEY `client_id` (`client_id`),
KEY `app_item_id` (`app_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

but it didn't fix it... it was asking for APSApplicationItems table as well...

so i did the same procedure with that... and now it asks for more.... (on the Application Vault...)
MySQL query failed: Unknown column 'categories' in 'field list'

on the backup procedure we have:
DBD::mysql::st execute failed: Table 'psa.APSLicenseTypes' doesn't exist

Plesk support this to check the situation:
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'"

After enabling mysql's debug the technical support engineer did a series of database edits that added some missing tables and removed previous entries of installed non-existing applications. Since I don't actually know what was missing, why and any possible questions even though the guys actually said "ok we added that table and removed that one and now it works" I don't know if the information is useful to be put here so... i must going to call it magic and let us move on with our lives....

No comments:

Post a Comment