• Halloween is coming! To celebrate the occasion, we dusted off a couple of old skins, and even created a brand new one (Pixel).
    To get into the festive spirit, install the Skins extension.
  • The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

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!
 
You must log in or register to reply here.

Similar threads

J
Question Server needs recovery - how to do? what has happened?
Replies
2
Views
6K
Jan
J
Bitpalast
Restore of customers/subscriptions/domains/databases fails if the customer or the subscription was disabled during backup
Replies
5
Views
6K
Sebahat.hadzhi
Sebahat.hadzhi
M
Issue Plesk Update 18.0.34 to 18.0.57 Database 'psa' not found
Replies
10
Views
7K
musa.sc
M
carlsson
Resolved Panic! Site crashed and restoring backup fails
Replies
18
Views
13K
carlsson
carlsson
S
Resolved ERR_CONNECTION_REFUSED after update
Replies
5
Views
5K
sistemsb
S
Back
Top