• 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

SiteApps Tables Missing - No Backup possible

S

sts85

Guest
Hi,

in my psa Database are some tables Missing.

I'm running Plesk 8.3.0 on FedoraCore 6.

When I try to maqke an Backup or some other operations, I get mysql errors, because some a table is missing. After Creating the 5th table by hand, I still became errors. It doesn't seem to end... ;) I gave up.

Can Anybody post me an mysql dump for plesk 8.3.0 to create all neccessary tables?

The Tables, that where/are missing:
SiteApps
SiteAppPackages
APSLicenseTypes
APSApplicationItems
APSLicenseTypes
APSClientApplicationItems


thanks
stephan
 
stephan,

this scripts are stored in /usr/local/psa/etc/db/psa_db.sql. For example, SiteApps table can be created:

# less /usr/local/psa/etc/db/psa_db.sql | grep -i SiteApps

CREATE TABLE SiteApps (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY
-- installed application id
, `app_release` VARCHAR(30) CHARACTER SET ascii COLLATE ascii_bin NOT NULL
-- installed application release
, dom_id INT UNSIGNED NOT NULL
-- reference to domain, where application is installed
, dom_type ENUM('domain', 'subdomain') NOT NULL DEFAULT 'domain'
-- where application is installed
, install_prefix VARCHAR(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL
-- directory of application inside vhost
, htdocs_directory ENUM('httpdocs', 'httpsdocs') NOT NULL DEFAULT 'httpdocs'
-- which documents tree is used for application
, capp_item_id INT UNSIGNED NOT NULL
-- reference to application in client application pool
, params_id INT UNSIGNED
-- object id with values of parameters
-- that are used for installed application
, `license_id` INT UNSIGNED
-- reference to APS License from pool
, INDEX (capp_item_id)
-- REFERENCES APSClientApplicationItems (id)
, INDEX (params_id)
-- REFERENCES Parameters (id)
, INDEX (`license_id`)
-- REFERENCES APSLicenses(id)
) TYPE=InnoDB;

hope this will help.
 
Back
Top