New Plesk backup issue?

[Ryan11433]

When I try to backup my plesk using Plesk Backup and I get "Object reference not set to an instance of an object."

Also for just incase if you need to know I have ran "alter table DatabaseServers add column parameters_id int;" and "alter table db_users add column status int;" in the psa database to fix the SQL error in the plesk control panel.

 

[sergius]

http://forum.swsoft.com/showpost.php?p=210013&postcount=8

 

[Ryan11433]

C:\>"%plesk_bin%\dbclient" --direct-sql --sql="ALTER TABLE DatabaseServers ADD C
OLUMN parameters_id int;"
Can't execute ALTER TABLE DatabaseServers ADD COLUMN parameters_id int;: MySql e
rror 1060uplicate column name 'parameters_id'
C:\>"%plesk_bin%\dbclient" --direct-sql --sql="ALTER TABLE db_users ADD COLUMN s
tatus int;"
Can't execute ALTER TABLE db_users ADD COLUMN status int;: MySql error 1060upl
icate column name 'status'

I've already added those in Mysql Administrator. I'm talking about (When I try to backup my plesk using Plesk Backup and I get "Object reference not set to an instance of an object.")

 

[chili1001]

Solution

Hi,

Did you have any solutions about this problem? I get the same after upgrading from v. 8.3 to 8.6

Regards Matthias

 

[jgpcandrepair]

I am receiving this error as well. Unfortunately it's not a very descriptive error. Any method I use to backup (Plesk Backup, individual domain backup through the control panel) produces this error.

 

[erezy]

upgrading from v. 8.3 to 8.6

I also updated from v8.3 to 8.6 and there is obviously a bug that did not update the psa database with all the new fields needed. I don't believe we need to pay for support to fix this. Does anyone have a solution?

 

[Ryan11433]

I finally found a solution myself by going to this thread located at http://forum.swsoft.com/showthread.php?t=54227 and running all of the given files... Plesk86DatabaseUpgrade.exe, Plesk8.3DatabaseUpgrade.exe and Plesk_8.2_to_8.6_DatabaseUpgrade.exe.