database differences between versions 8.x

[manos2000]

As i wrote in previous threads there are differences at plesk databases in 8.x versions

In 8.6.05 at site report , application vaults etc i receive:

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 ai.id, max(ai.pkg_id), COUNT(sa.id)
FROM (APSApplicationItems AS ai
LEFT JOIN APSClientApplicationItems AS cai ON (cai.app_item_id=ai.id))
LEFT JOIN SiteApps AS sa ON (sa.capp_item_id=cai.id)
GROUP BY ai.id;', NULL null)
1: plib\common_func.php3:236
db_query(string 'SELECT ai.id, max(ai.pkg_id), COUNT(sa.id)
FROM (APSApplicationItems AS ai
LEFT JOIN APSClientApplicationItems AS cai ON (cai.app_item_id=ai.id))
LEFT JOIN SiteApps AS sa ON (sa.capp_item_id=cai.id)
GROUP BY ai.id;')
2: plib\SiteApps\APSApplicationsList.php:149
APSApplicationsList->fetchAPSApplicationsList()



It seems 'capp_item_id' doe snot exist in older versions and is not created.
Could you added it to your patch?

thanks
manos

 

[manos2000]

Sergious could you provide the sql statement to add the missing column 'capp_item_id'. ?

Is it "%plesk_bin%\dbclient" --direct-sql --sql="ALTER TABLE DatabaseServers ADD COLUMN capp_item_id;"

?

thanks
manos