• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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

V

vfmz

Guest
My System Suse 9.3, Plesk 8.01 with all patches (via online updater)!!!
Everything was fine until i configured the backup with plesk-frontend, a day later i want to watch if the backup is fine... this error returns:

ERROR: PleskMainDBException
MySQL query failed: Table 'psa.BackupsSettings' doesn't exist
0: /usr/local/psa/admin/plib/common_func.php3:229
db_query(string 'select * from BackupsSettings where type="domain" and id ="1"')
1: /usr/local/psa/admin/plib/backup/BackupFtpSettingStorage.php:58
BackupFtpSettingStorage->load()
2: /usr/local/psa/admin/plib/backup/BackupFtpSettingStorage.php:41
BackupFtpSettingStorage->getParam(string 'tab')
3: /usr/local/psa/admin/plib/backup/BackupCManager.php:110
BackupCManager->applyFTPSetting(object of type BackupDomain)
4: /usr/local/psa/admin/plib/backup/BackupManager.php:124
BackupManager->demonFactory()
5: /usr/local/psa/admin/plib/PMM/MigrationCObject.php:56
MigrationCObject->demonFactory()
6: /usr/local/psa/admin/plib/backup/BackupFront.php:30
BackupFront->stepBegin()
7: /usr/local/psa/admin/plib/PMM/MigrationCObject.php:100
MigrationCObject->make()
8: /usr/local/psa/admin/htdocs/backup/main_domain.php:24


How to setup this missing table "BackupsSettings" now? is it possible to download the empty table-structure anywhere? Please help!:confused:
 
# ls psa/etc/pbm

there are SQL scripts for database table creation...
 
thanx!!!!!

thanx, i found them and i was able to fix the problem !!!!
 
Back
Top