• 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.

Database backup problem

C

colinjack

Guest
My backup is failing with:

Backup error.
Can't query SELECT `id`,`dom_id`,`subdom_id`,`friend_dom` FROM `hotlink_friends`: MySQLDatabaseProvider error 1054:Unknown column 'subdom_id' in 'field list'
at (MySQLDatabaseProvider::query line 282)
at (psaobsolete::pSAMySQLDatabase::query line 236)


Can anybody suggest the quickest/easiest way to fix this?

Thanks

Colin
 
Hi,

I think your backup is failing due to database issue. First to take complete backup uncheck the database exist domain for backup and run the backup, at least backup will be finished for all other existing domain. Unless until your client database is not be good you will not be able to take backup.
 
Eventually found that the upgrade from 7.5 to 7.6 had left a sub_domain field missing in the database. Created that manually and looks okay.

Thanks
 
how did you add this field? i can't seem to find the database to fix. i am missing a field in mine after upgrade also. Thanks!
 
Back
Top