SiteApps Tables Missing - No Backup possible

[sts85]

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

 

[DmitryT]

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.