How to undelete opportunity?

[kilian7]

Hi,

One of my users, Max, has detected that one of his opportunities disappiered.
With phpmyadmin I could find the opportunity marked with "deleted=1". Looking at "date_modified" and "modified_user_id" I could find that the opportunity has been deleted by Max, so I asked Max if he deleted the opportunity by error. But he say that at the time the opportunity was deleted he only did a dashboard refresh.

Could be a SugarCRM bug? I'm using Debian 2.4.27, Sugar 4.0.1e, php 4.3.10-2, MySQL 4.0.23, Apache 1.3.33
Or, as Dr House says, my user is lying? (House M.D. TV serie)

Well, the most important for me is to recover the opportunity. Is as easy as changing the "deleted=1" to "deleted=0" in the DB opportunitie record?

Thanks in advance,

Kilian

[sacramentojoe]

Hi,

One of my users, Max, has detected that one of his opportunities disappiered.
With phpmyadmin I could find the opportunity marked with "deleted=1". Looking at "date_modified" and "modified_user_id" I could find that the opportunity has been deleted by Max, so I asked Max if he deleted the opportunity by error. But he say that at the time the opportunity was deleted he only did a dashboard refresh.

Could be a SugarCRM bug? I'm using Debian 2.4.27, Sugar 4.0.1e, php 4.3.10-2, MySQL 4.0.23, Apache 1.3.33
Or, as Dr House says, my user is lying? (House M.D. TV serie)

Well, the most important for me is to recover the opportunity. Is as easy as changing the "deleted=1" to "deleted=0" in the DB opportunitie record?

Thanks in advance,

Kilian

Yes, set it back to 0.

[kilian7]

Thanks sacramentojoe,

I changed "deleted" to 0 and the opportunity appeared. Then, I searched for the opportunity_id in all the DataBase so I could find all related items (accounts_opportunities, calls, notes, etc) and changed "deleted" to 0 when suitable.


Kilian

[gdoss]

I had one of my users delete an Opportunity by accident, too. Now, I assumed that changing it from 1 to 0 in the database would restore the Opportunity, however it has not. Came to the forums and found that apparently it should Anything else that must be done or any other ideas?

Sugar 4.0.0
Apache 2.0.53
Fedora Core 3
PHP 4.3.11
MySQL 4.1.16

[mpoer@profilingsolutions.com]

I had one of my users delete an Opportunity by accident, too. Now, I assumed that changing it from 1 to 0 in the database would restore the Opportunity, however it has not. Came to the forums and found that apparently it should Anything else that must be done or any other ideas?

Marking deleted=0 should take care of it. Might want to make sure you're logged in as an appropriate user with access to the record and also clear your cache for good measure.

[rafael.q.g@hotmail.com]

Maybe more than set the opportunity deleted flag as 0, is also important check the tables which has relationships with opportunities to set its flags also to 0, because sometimes the opportunities returns, but its relationship with accounts could be deleted, them it could not be found by some users under the suposed related account for exemple.

[kuske]

Yes Rafael is right.
Whe you delete an opportunity, even all it's relations to other objects are deleted too. So you should search in the database for alle relations set to 0 at the same datetime than the opportunity had been deleted.

[zedsteiner]

Yes Rafael is right.
Whe you delete an opportunity, even all it's relations to other objects are deleted too. So you should search in the database for alle relations set to 0 at the same datetime than the opportunity had been deleted.

How interesting, I am very keen to learn, but thank you for the information!!