Is it possible to recover a deleted account?

[m0thr4]

Please excuse my ignorance here, I don't use Sugar at all, but I do provide support for the Unix/MySQL platform it runs on.

My boss has just informed me that he accidentally deleted an account, and if I can possibly restore it.

I saw another post saying that nothing is deleted in Sugar, it's just marked as deleted in the database. I have located this account in the database and can see that the deleted flag is set to '1'; however, I don't want to change just that if it's going to mess up the integrity of any other dependants.

Is this the right way forward, i.e. to fix it in the database, or will it end up being too complicated? Is there another, safer way to restore a deleted account and everything related to it?

[dlorenzetti]

No, you need to mark deleted as 0 and mark deleted 0 in the relationships talbes too.

[m0thr4]

No, you need to mark deleted as 0 and mark deleted 0 in the relationships talbes too.

Wow, thanks for the quick response. And that (above) should sort it all out completely?

[dlorenzetti]

Sorry I'm not sure if I did understand your question, but if I did: Yes, if you mark as 0 in database and mark in the relationship tables too, this account and the relationships going to appears again in the system.

[m0thr4]

Sorry I'm not sure if I did understand your question, but if I did: Yes, if you mark as 0 in database and mark in the relationship tables too, this account and the relationships going to appears again in the system.

When you say, 'the relationship tables', which actual tables are you referring to? There is a table called 'relationships' but that looks like one that defines relationships for the software and also it doesn't have anything in it that's marked as deleted.

If I just mark the account back to not being deleted, I can see it in SugarCRM, however, all of the leads, contacts, history etc. are empty. I guess what I need is a list of all the tables I need to look at, if that's not too much trouble.

Thanks.

[dlorenzetti]

Exactly, the leads, historys, etc are empty because you don't mark 0 in relationship tables, for each relationship there is a table, for Contacts in Accounts is accounts_contacts, there you can find the row with account_id = your account id and mark the deleted field in that row as 0, the same for, accounts_calls, accounts_meetings, etc.

[m0thr4]

Exactly, the leads, historys, etc are empty because you don't mark 0 in relationship tables, for each relationship there is a table, for Contacts in Accounts is accounts_contacts, there you can find the row with account_id = your account id and mark the deleted field in that row as 0, the same for, accounts_calls, accounts_meetings, etc.

Ok, I think I'm on the right track here. I've found that not all of the related tables are prefixed with 'accounts_' by running:

select * from relationships where lhs_table = 'accounts';

Now going through each one that is linked on account_id and repairing the damage.

Thanks for your help!

[dlorenzetti]

Nice, good idea.

Cheers