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

upgrade breaks plesk SiteAppPackages table does not exist

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

  1. adamjimenez

    adamjimenez Basic Pleskian

    23
    57%
    Joined:
    Jul 19, 2006
    Messages:
    43
    Likes Received:
    0
    Running FC6 (86)

    When I upgrade from 8.2.1 to 8.3 I get an error about table SiteAppPackages does not exist.

    I tried creating the table manually - but I get a mysql errno 121.

    I had this problem from a clean install - and I reimaged the server and had the same problem.
     
  2. Jon Williams

    Jon Williams Guest

    0
     
    FC6 8.3.0 App Vault tables missing

    Fresh Re-Image of FC6 (x86)
    Upgrade through Plesk web UI from 8.2.1 to Plesk 8.3.0, and my app vault has deathed :-0

    Server | Services | Application Vault click---->

    Server >
    ERROR: PleskMainDBException Create ShortcutCreate ShortcutUp LevelUp Level


    MySQL query failed: Table 'psa.SiteAppPackages' doesn't exist

    --------------------------------------------------------------------------------

    0: /usr/local/psa/admin/plib/common_func.php3:218
    db_query(string 'SELECT id FROM SiteAppPackages WHERE CONCAT(name, "-", version, "-", `release`) = "smf-1.1.2-28" AND package_type != "2"')
    1: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:309
    SiteAppPackageManager::getSiteAppPackageId(string 'smf-1.1.2-28')
    2: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:273
    SiteAppPackageManager->syncWithDatabase()
    3: /usr/local/psa/admin/htdocs/server/site_app_pkgs.php:42
     
  3. dsojo

    dsojo Guest

    0
     
    same problem here...any idea how to fix it ?
     
  4. Swamper

    Swamper Guest

    0
     
    I also have this problem
     
  5. dirty@

    dirty@ Guest

    0
     
    find the file 'aps-psa830-db-upgrade' (on my freebsd it is /usr/local/etc/psa/db/aps-psa830-db-upgrade, on linux systems it should be /usr/local/psa/etc/db/aps-psa830-db-upgrade) and run it as

    # /usr/local/psa/admin/bin/php /path/to/aps-psa830-db-upgrade
     
  6. adamjimenez

    adamjimenez Basic Pleskian

    23
    57%
    Joined:
    Jul 19, 2006
    Messages:
    43
    Likes Received:
    0
    Can confirm on FC6 the file is here:
    /usr/local/psa/etc/db/aps-psa830-db-upgrade

    Someone please try it and confirm it works before I hose my system..
     
  7. tomcom

    tomcom Guest

    0
     
    I have the same problem. I tried /usr/local/psa/admin/bin/php /path/to/aps-psa830-db-upgrade , doesn`t work: "column app_item_id cannot be null".
    Via phpmyadmin i also cannot find this column...
    HEEEEEELP
     
  8. adamjimenez

    adamjimenez Basic Pleskian

    23
    57%
    Joined:
    Jul 19, 2006
    Messages:
    43
    Likes Received:
    0
    when i run it i get:

    Database error: Table 'psa.SiteAppPackages' doesn't exist
     
  9. x102020

    x102020 Guest

    0
     
    ive also got the same error. running the command says table doesnt exist...
     
  10. x102020

    x102020 Guest

    0
     
    whats xoops-2.2-44?

    its in the php part of the error...
     
  11. eugenevdm

    eugenevdm Silver Pleskian

    30
    68%
    Joined:
    Nov 11, 2003
    Messages:
    611
    Likes Received:
    0
    Has anyone considered logging a support call with SWSoft? I'm sure these database-type errors should be a breeze for them to isolate and fix.
     
  12. adamjimenez

    adamjimenez Basic Pleskian

    23
    57%
    Joined:
    Jul 19, 2006
    Messages:
    43
    Likes Received:
    0
    i'm having this problem with a 1and1 server and think it might be a problem with their server image. i'm trying to get a response out of them.
     
  13. x102020

    x102020 Guest

    0
     
    I am also with 1and1, but i dont think its the server image. 8.2 worked with the apps, just the upgrade from 8.2 > 8.3 is what did it. it may just be specific to the fc6 build?
     
  14. adamjimenez

    adamjimenez Basic Pleskian

    23
    57%
    Joined:
    Jul 19, 2006
    Messages:
    43
    Likes Received:
    0
    it seems to be specific to fc6 (86). I also have a fc6 (64) server with 1and1 and that has upgraded ok.
     
  15. adamjimenez

    adamjimenez Basic Pleskian

    23
    57%
    Joined:
    Jul 19, 2006
    Messages:
    43
    Likes Received:
    0
  16. talcon

    talcon Guest

    0
     
    me too

    I'm also having this problem and have tried various fixes, including updating the autoinstaller (which fixed plesk telling me I had updates available, but then not showing any) and also the suggestions on the 1and1 forum linked to above.

    Has anybody else gotten these resolved or do you think it will require a call to 1and1 support?

    Thanks for any help.
     
  17. tomcom

    tomcom Guest

    0
     
    This is not a special problem for 1und1.
    I wrote swsoft for bug and the answer:

    Hello Thomas,

    The error means that new Application Vault tables were not created or were not updates to new 8.3.0 format during update. First of all it is needed to check that update was not interrupted in the middle but really finished. If it is OK but affects AppVault tables only, you can create/convert them with command:

    #/usr/local/psa/admin/bin/php /usr/local/psa/etc/db/aps-psa830-db-upgrade

    And nothing more......
    I tried the command, does not work
     
  18. talcon

    talcon Guest

    0
     
    same here... I get:

    Database error: Table 'psa.SiteAppPackages' doesn't exist
     
  19. talcon

    talcon Guest

    0
     
    I should also add that this breaks removing domains as well:

     
  20. talcon

    talcon Guest

    0
     
    I fixed mine mostly... but it's a lengthy fix: (USE AT YOUR OWN RISK!) You might have the same problem as me, might not.

    I logged into mysql and checked tables:
    mysql -u admin -p psa

    show tables;

    in another window I then copied /usr/local/psa/etc/db/psa_db.sql to /usr/local/psa/etc/db/fixpsa1.sql

    I edited the file fixpsa1.sql and removed the drop database, create database lines at eh beginning and all the table creations and alter table lines for the tables that already exist in the "show tables;" above.

    check it and compare carefully!

    then ran mysql -u admin -p < fixpsa1.sql

    this recreated the missing tables except for two of the innodb tables - SiteApps and SiteAppPackages. I got an error on these two tables that was cryptic to say the least. I got a clue from /var/log/mysqld.log about what was going on. These two tables apparently existed in the innodb structure, but did not have corresponding .frm files in /var/lib/mysql/psa.

    I copied fixpsa1.sql to fixpsa2.sql and then edited out all entries except for those two table creates and corresponding alter table entries. I removed the beginning "USE psa;" line, and put a "CREATE DATABASE fixpsa;" and then a "USE fixpsa;" line there.

    ran mysql -u admin -p < fixpsa2.sql

    This created the two tables in a new database called "fixpsa".

    I copied the SiteApps.frm and SiteAppPackages.frm files from /var/lib/mysql/fixpsa to /var/lib/mysql/psa

    then did a /etc/init.d/mysqld restart

    re-edited fixpsa2.sql and removed the create/use lines at the beginning and put the "USE psa;" back there. Then added "DROP TABLE SiteApps;" and "DROP TABLE SiteAppPackages;" before the table create lines.

    ran mysql -u admin -p < fixpsa2.sql

    no errors... ran "php /usr/local/psa/etc/db/aps-psa830-db-upgrade" and it said updates were already applied and gave no errors.

    I logged back in to Plesk and everything is working properly now. I'm still going to keep an eye on my /var/log/mysqld.log

    Good luck all... REMEMBER - USE AT YOUR OWN RISK AND MAKE SURE YOU'RE HAVING THE EXACT SAME PROBLEM.
     
Loading...