Recover from delete

[Luca Barzelogna]

Hi All,

I have a problem with my board 3.8.4 , made a mistake and delete 100000 topics. Now when I try to read a deleted topic I see that it exist and a button ask to me if I want to  recover it .

Is possible to recover all the topics in one time?

Thanks

 

Luca

 

[DesignzShop]

4 hours ago, Luca Barzelogna said:

Hi All,

I have a problem with my board 3.8.4 , made a mistake and delete 100000 topics. Now when I try to read a deleted topic I see that it exist and a button ask to me if I want to  recover it .

Is possible to recover all the topics in one time?

Thanks

 

Luca

 

That's a lot of posts Luca,
I'd restore a current backup of your site. If you can go back to a backup right before the moment you deleted those posts that would be optimal. You may need to go back to a week instead of a day depending on when your backups are pulled, it's best to just do that even though you may lose some current posts that happened from the time you deleted those posts to now, that's better however than not having those posts at all.. Hope this helps some

Kind Rgeards

[Luca Barzelogna]

HI,

I don't have any backup... the website is www.et3.it

[Luca Barzelogna]

The posts will be deleted from the trash bin soon, how to stop this process?

 

[DesignzShop]

14 minutes ago, Luca Barzelogna said:

HI,

I don't have any backup... the website is www.et3.it

Does your host have a backup?

If not, I'm not saavy on 3.4 anymore and can't remember some things. I'd submit a ticket to IPB quick and see if they can give guidance on tasks and possibly stopping one until you can get this sorted.

Next - Enable backups immediately and never ever go without backups regularly.

Kind Regards

[Nathan Explosion]

Am away from my acp but pretty sure you can extend the time before deleted items are removed...search the app for deleted and see if a result comes up. 48 hours is the default, I think.

Will bemail home in an hour and can check then myself.

[Nathan Explosion]

"Days to retain deleted topics and posts" is the setting to search for to extend the time before the items get deleted permanently - do not set it to zero.

[Joy Rex]

Assuming you deleted these via SQL query, it may be possible to find out how the topics are flagged as deleted and run a query to set the "deleted" flag or whatever it is to 1/0 or true/false.

[Luca Barzelogna]

12 hours ago, Joy Rex said:

Assuming you deleted these via SQL query, it may be possible to find out how the topics are flagged as deleted and run a query to set the "deleted" flag or whatever it is to 1/0 or true/false.

Yes, this is what I'm searching for. But I don't find anything like "trash bin" or "delete" fields in the database.. Anyone know where is flagged the delete option?I mean the field where find the "Deleting" option

 

Thanks

[Joy Rex]

I'm still running 3.4.9 and had a look at my database... there is a table called "_core_soft_delete_log" (your table prefixes may be different than mine), and in it I see posts that have been recently deleted. This might be what you're looking for.

[Luca Barzelogna]

Hi,

I' have found the field. The solution is to change the state of the "approve" field from 2 to 1, then the topics come visible again. The only thing is the tdelete_time, I need to replace all the data inside this field with 0.

How to do this with mysql coding?

Thanks

 

Luca

[Luca Barzelogna]

solved:
UPDATE table_name SET name_field = "value"