MyBB Community Forums

Problem regarding undo delete plugin !!!

How to solve this error,

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 262522 bytes) in /home/starone/public_html/forum/admin/inc/class_table.php on line 240

Hi, when does this happen?

A person has deleted more than 4000 threads !!!
after is I can't restore them
plz help me...

Okay, 4000 threads is a lot.

Can you say when exactly this happen?

When you try to restore a thread or just when you want to display/show deleted threads or posts ot attachments...?

It happen does just a few hours ago
and after 30 minutes I hadle it and banned that person
and tried to restore by Undo delete plugin,
screenshot is here

Can you reproduce the error? Does it happen when you click on "Threads"?

EDIT:

Okay, the reason is Undo Delete doesn't have an pagination function and so there are thousands of db queries. Next version I will fix this.

At the moment you can do the following to restore your thread and posts.

Do a full backup of your database before you start!

Go to phpMyAdmin and export the tables mybb_backup_posts, mybb_backup_threads and mybb_backup_threadsubscriptions. Do not export the structure, just the data!

Download the file and open it.

Search for every mybb_backup_posts and replace it with mybb_posts.
Search for every mybb_backup_threads and replace it with mybb_threads.
Search for every mybb_backup_threadsubscriptions and replace it with mybb_threadsubscriptions.

Save the file and import it with phpMyAdmin.

Finally you just need to rebuild stats and forum and thread counters.

Ok I am doing it all

---

I have done it all
some of the posts & threads are back..

but the Recount & rebuild option is not working properly,
some sections are updated but many sections are not updated

If you have done all steps, all threads should be restored.

(2010-03-27, 03:33 AM)Azizone05 Wrote: [ -> ]but the Recount & rebuild option is not working properly

Hm, has nothing do to with Undo Delete. Why does it not not? Without an error message is it hard to help.

Only a few forums are needed to be updated
for Recount & Rebuild,
Can Truncate the tables in Undo Delete menu...??
I have not done it...
asking for this

(2010-03-27, 01:38 PM)Azizone05 Wrote: [ -> ]Can Truncate the tables in Undo Delete menu...??

If you have successfully done all steps from #6 and all threads and posts are completely restored, sure you can truncate the backup tables.