Error in upgrade to 8.4 > 8.6

[mike2mike]

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'.

 

[JTRipper]

Thanks

Hello Walter,

Thank you for the report.

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

Any feedback is appreciated.

This fixed my issues on all of my 8.6 upgrade installations.
Thanks again Sergius.

 

[manos2000]

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

 

[funky123]

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

 

[IgorG]

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.