• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Error in upgrade to 8.4 > 8.6

Same here, after the update from 8.2 > 8.6.0 > 8.6.0.1 plesk backup fails:

Invalid column name 'capp_item_id'. Invalid column name 'license_id'. Invalid column name 'app_release'.
 
Seems still no solution
With sergiu's exe 82to86 pleks works fine except 2 parts:
1) Manual backup as described above.
2)Site report
The full error is;
<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Invalid column name 'capp_item_id'.
---------------------- Debug Info -------------------------------
0: plib\common_func.php3:236
com->execute(string 'SELECT COUNT(*) FROM SiteApps sa LEFT JOIN subdomains sd ON (sd.id=sa.dom_id AND sd.dom_id=68) WHERE ( (sa.dom_type=N'subdomain' AND NOT (sd.id IS NULL)) OR ( sa.dom_type<>N'subdomain' AND sd.id IS NULL)) AND sa.capp_item_id = 0 AND (NOT (sd.id IS NULL) OR sa.dom_id=68)', NULL null)
1: plib\common_func.php3:236
db_query(string 'SELECT COUNT(*) FROM SiteApps sa LEFT JOIN subdomains sd ON (sd.id=sa.dom_id AND sd.dom_id=68) WHERE ( (sa.dom_type="subdomain" AND NOT (sd.id IS NULL)) OR ( sa.dom_type<>"subdomain" AND sd.id IS NULL)) AND sa.capp_item_id = 0 AND (NOT (sd.id IS NULL) OR sa.dom_id=68)')
2: plib\report\class.DomainReport.php:890
DomainReport->make_report_summary_aspnetapps_()
3: plib\report\class.Report.php:280
Report->make_report(integer '68')
4: htdocs\server\report.php:37

So after ugrade from 8.2 to 8.6 'capp_item_id' column is missing at SiteApps table.

Could you provide the sql query to add the missing columns?

thanks
manos
 
is this still troublesome after upgarde?

plesk database and backups?

I have couple of plesk 8.2 and plesk 8.1 for upgardings

trying to find if we can directly upgrade to 8.6
 
Due to a known Spamassassin issue there are too many temporary files in C:\Pleskserver\admin\db\ folder. Because of that Plesk...DatabaseUpgrade.exe temp files could not be created. Try to clean up this folder with:

C:\Pleskserver\admin\db>del *.tmp /F /Q
C:\Pleskserver\admin\db>del .spamassassin* /F /Q

After that try database upgrade again.
 
Back
Top