Application vault: Table 'psa.APSClientApplicationItems' doesn't exist

[magasoft]

Hi

Updating Plesk from 8.2.1 to 8.3.0 seems to be done well except application vault. When clicking this vault icon under "Domains" inside the panel I get the following MySQL error:
<<
Internal Plesk error occurred: MySQL query failed: Table 'psa.APSClientApplicationItems' doesn't exist
>>

Another MySQL error appears by clicking application vault icon under "Server":
<<
Internal Plesk error occurred: MySQL query failed: Unknown column 'categories' in 'field list'
>>

I don't see any error in the log files. I tried to update within the web panel and on the console with "autoupdater". Even by forcing rpm installation, database seems not to be updated correctly.

Have anybody some hints?

System: SLES 9 based on virtuozzo 3

Thank you!

Markus

 

[magasoft]

[Solved]

I had to entries "Joomla 1.0.12" in table SiteAppPackages and therefore the ASP database updater failed. After renaming this one I had previously installed manually vault service works fine.

Markus

 

[biznesshosting]

I had to entries "Joomla 1.0.12" in table SiteAppPackages and therefore the ASP database updater failed. After renaming this one I had previously installed manually vault service works fine.

Markus

did you do anything else but just rename?

 

[magasoft]

I did rename the folder in cgitory too, so the new name corresponds to this one I put it into the database record:
Joomla-1.0.12-... into Joomladeutsch-1.0.12-... (because it's a German version).

Markus

 

[alta]

As fro table, check if APSClientApplicationItems tables persists in mysql:

[root@fedora6 ~]# mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -e "describe APSClientApplicationItems;"
+-----------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| client_id | int(10) unsigned | NO | MUL | 0 | |
| app_item_id | int(10) unsigned | NO | MUL | 0 | |
| instances_limit | int(11) | NO | | -1 | |
+-----------------+------------------+------+-----+---------+----------------+
If it does not exist please add the following table in mysql:

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;

 

[npavlidis]

I did something similar....

I only copied the directory to create a joomla installation dir...
I got the same error and I did the mysql drop add (even thought there was no table to begin with) and still nothing

the table exists as u can see:

[root@www cgitory]# mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -e "describe APSClientApplicationItems;"
+-----------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| client_id | int(10) unsigned | NO | MUL | 0 | |
| app_item_id | int(10) unsigned | NO | MUL | 0 | |
| instances_limit | int(11) | NO | | -1 | |
+-----------------+------------------+------+-----+---------+----------------+

I restarted mysql and psa but no result...

what am i doing wrong?

 

[charles bailey]

missing a colum

The APSClientAppliactionItems table in Parallels Plesk Panel 9 also has a 'broadcast' column, which was missing.


mysql> alter table APSClientApplicationItems add broadcast enum('false','true') NOT NULL default 'false';
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0

And now it looks like this:

[Expand quote]
mysql> describe APSClientApplicationItems;
+-----------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+----------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| client_id | int(10) unsigned | NO | MUL | 0 | |
| app_item_id | int(10) unsigned | NO | MUL | 0 | |
| instances_limit | int(11) | NO | | -1 | |
| broadcast | enum('false','true') | NO | | false | |
+-----------------+----------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)