Luca Barzelogna Posted December 13, 2016 Share Posted December 13, 2016 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 Link to comment Share on other sites More sharing options...
DesignzShop Posted December 13, 2016 Share Posted December 13, 2016 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 Link to comment Share on other sites More sharing options...
Luca Barzelogna Posted December 13, 2016 Author Share Posted December 13, 2016 HI, I don't have any backup... the website is www.et3.it Link to comment Share on other sites More sharing options...
Luca Barzelogna Posted December 13, 2016 Author Share Posted December 13, 2016 The posts will be deleted from the trash bin soon, how to stop this process? Link to comment Share on other sites More sharing options...
DesignzShop Posted December 13, 2016 Share Posted December 13, 2016 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 Link to comment Share on other sites More sharing options...
Nathan Explosion Posted December 13, 2016 Share Posted December 13, 2016 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. Link to comment Share on other sites More sharing options...
Nathan Explosion Posted December 13, 2016 Share Posted December 13, 2016 "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. Link to comment Share on other sites More sharing options...
Joy Rex Posted December 13, 2016 Share Posted December 13, 2016 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. Link to comment Share on other sites More sharing options...
Luca Barzelogna Posted December 14, 2016 Author Share Posted December 14, 2016 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 Link to comment Share on other sites More sharing options...
Joy Rex Posted December 14, 2016 Share Posted December 14, 2016 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. Link to comment Share on other sites More sharing options...
Luca Barzelogna Posted December 15, 2016 Author Share Posted December 15, 2016 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 Link to comment Share on other sites More sharing options...
Luca Barzelogna Posted December 16, 2016 Author Share Posted December 16, 2016 solved:UPDATE table_name SET name_field = "value" Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.