Urgent I deleted all leads

💬 General Discussion
1

I don’t know how it happened I deleted all my leads, is there a way via db to recover them?

thank you

2

Yes, you can probably find them in the database (if you deleted them from within SuiteCRM), in the leads table, you just need to UPDATE the field deleted from 1 to 0.

You might want to pay attention also to the date_modified field, so that you undelete only the most recently deleted Leads, otherwise you will undelete also stuff that you had previously deleted on purpose.

3

yesss thanks i fixed it
Now I have another problem
Email address, is no longer set to primary, how do I change this?

sorry for my english see screen

Immagine 2022-11-28 122601
Immagine 2022-11-28 1226011191×126 2.57 KB

4

pls help me this is a very problem

5

@prmarketing

How do you want to solve the problem?

  1. using the SuiteCRM interface,
  2. directly to the database,
  3. by writing custom code.
6

the simplest solution :slight_smile:

7

@prmarketing
Edit each record using SuiteCRM interface and button – Save and continue.

8

mmm this is very problema i have 8000 leads… edit mass solution ?

9

@prmarketing

The DB has the table ‘email_addr_bean_rel’. Select all records with “bean_id” as in the table “leads” table and set the value in the “primary_address” column to “1”.

10

I try… but I ask you, is there a query, easier?

11

@prmarketing

I think that the other variants will be more difficult.

12

i have send u private message

13

This forum is now frequented only by masked sellers

14

@prmarketing

You wrote in direct, I answered you.
In public, I wrote how you can do it yourself. This is your personal question and may not be of interest to other members of the community.

15

of course ?
you give half aid here and in public you shoot an absurd figure for a 10-second query?
Just think, at least I didn’t say the price you asked

16

@prmarketing I don’t think you’re being reasonable.

@p.konetskiy can help as much, or as little as he wants, for free. I would say he helps quite a lot, and frequently provides full code solutions.

He can also ask whatever price he wants when you contact him in private. You contacted him, not the other way around.

Sometimes I ask very high prices simply to signal they I am too busy, and not particularly interested in that kind of job.

Just accept it or refuse it, but don’t criticize.

1 Like
17

@prmarketing

5% for work and 95% for know how.
My work here is free.

1 Like
18

ok sorry , this is suitecrm… not sugarcrm

19

Just becasue SuiteCRM is Open Source doesn’t mean that all related to it is free. Just as your customers need to pay for your services when you use SuiteCRM…

Many contribute their time to this community. Let’s be thankful to them. Their time is just valuable as yours. And remember. We all need to eat!!!