Database backup problem

[colinjack]

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:SAMySQLDatabase::query line 236)


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

Thanks

Colin

 

[steve009]

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.

 

[colinjack]

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

 

[jbolter]

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!