Cannot Access Application Vault after upgrade 8.3->8.6

[wized37]

Upgraded Plesk 8.3 -> 8.6. Installed fine however found the same problem when trying to access DNS as in this thread http://forum.swsoft.com/showthread.php?t=54227

Downloaded and ran Plesk86DatabaseUpgrade.exe as described and that issue was fixed.

Tried to access Application Vault and get the error detailed below. Noticed there was a later PleskApps package 1.2, so downloaded and installed but still get this error:


<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Invalid object name 'siteapppackages_apscategories'.
---------------------- Debug Info -------------------------------
0: plib\common_func.php3:236
com->execute(string 'DELETE FROM siteapppackages_apscategories WHERE siteapppackage_id = 25', NULL null)
1: plib\common_func.php3:236
db_query(string 'DELETE FROM siteapppackages_apscategories WHERE siteapppackage_id = 25')
2: plib\SiteApps\APSCategory.php:147
APSCategory::removeSiteAppPackageCategories(integer '25')
3: plib\SiteApps\class.SiteAppPackageManager.php:605
SiteAppPackageManager->updatePackageCategories(object of type SiteAppPackage)
4: plib\SiteApps\class.SiteAppPackageManager.php:320
SiteAppPackageManager->syncWithDatabase()
5: htdocs\server\site_app_pkgs.php:39

Server config is:
Server 2003 with SP2
Plesk 8.6.0
Using MSSQL 2000 with SP4
APS Application Pack 1.2

 

[sergius]

Upgraded Plesk 8.3 -> 8.6. Installed fine however found the same problem when trying to access DNS as in this thread http://forum.swsoft.com/showthread.php?t=54227

Downloaded and ran Plesk86DatabaseUpgrade.exe as described and that issue was fixed.

Tried to access Application Vault and get the error detailed below. Noticed there was a later PleskApps package 1.2, so downloaded and installed but still get this error:


<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Invalid object name 'siteapppackages_apscategories'.

Hello wized,

Please download and run the tool Plesk8.4DatabaseUpgrade.exe or Plesk_8.2_to_8.6_DatabaseUpgrade.exe.
Please backup Plesk database before tool running.

Any feedback is appreciated.

 

[wized37]

Thankyou Sergius,

I paid for support but they only part fixed the problem - earlier today they added missing database tables which allowed the app vault to be opened without the error but there were no applications available in the application vault to add to a site.

I ran Plesk_8.2_to_8.6_DatabaseUpgrade.exe and it has fixed the problem. Thankyou again.