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

Plesk 8.3 Applicationpack

Discussion in 'Plesk for Linux - 8.x and Older' started by tomcom, Dec 20, 2007.

  1. tomcom

    tomcom Guest

    because SWSoft (or anyone else) is unable to open a forum-part for Plesk8.3 I must write here...

    The Update works, but one problem remains:
    the application-pack does not work. I see the following:

    MySQL query failed: Unknown column 'categories' in 'field list'

    0: /usr/local/psa/admin/plib/common_func.php3:218
    db_query(string 'select `id`,`name`,`version`,`release`,`description`,`categories`,`integrated`,`access_level`,`package_type`,`params_id` from SiteAppPackages where `id`=79')
    1: /usr/local/psa/admin/plib/class.Table.php:180
    2: /usr/local/psa/admin/plib/SiteApps/class.cSiteApp.php:48
    cSiteApp->cSiteApp(integer '79')
    3: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackage.php:92
    SiteAppPackage->__construct(string '79')
    4: /usr/local/psa/admin/plib/common_func.php3:2875
    objectMaker(string 'SiteAppPackage', string '79')
    5: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:381
    SiteAppPackageManager->registerSiteAppPackage(string 'CSLH-2.12.2-24')
    6: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:274
    7: /usr/local/psa/admin/htdocs/server/site_app_pkgs.php:42

    This looks like an DB-Error. But why, what does it mean and how can I solve this????

  2. Cancel

    Cancel Guest

    What version of Plesk you've upgraded?
  3. tomcom

    tomcom Guest

    I´m always up to date.
    Thats why I think, the last one before was something about 8.2.
  4. dirty@

    dirty@ Guest

    it's definitely incomete update, simple grep for 'categories' in my /usr/local/etc/psa/db/ folder (plesk for freebsd) shows that it should be in table 'SiteAppPackages' and this table is created by 'aps-psa830-db-upgrade' script in the same folder..

    i am not sure if this scipt may be simply re-run to finish app vault update, first try to check /tmp/autoinstaller3.log for errors during update and if some package(s) were not updated to 8.3..
  5. tomcom

    tomcom Guest

    yes, aps-psa830-db-upgrade is there.
    But I can´t find autoinstaller3.log, where is this ? It´s a Suse-Linux.
    And how can I manually re-run this?????