1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

database differences between versions 8.x

Discussion in 'Plesk for Windows - 8.x and Older' started by manos2000, Nov 30, 2008.

  1. manos2000

    manos2000 Guest

    0
     
    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
     
  2. manos2000

    manos2000 Guest

    0
     
    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
     
Loading...