• 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

database differences between versions 8.x

M

manos2000

Guest
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
 
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
 
Back
Top