Regain Deleted Posts or Post Counts?

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
sticktacular
Registered User
Posts: 47
Joined: Sun Feb 20, 2005 11:46 pm

Regain Deleted Posts or Post Counts?

Post by sticktacular » Sun Jan 08, 2006 9:25 pm

URL: sticktacular.com/phpBB2
Template(s) used: alexia
Any and all MODs: today and date mod (i think)
Do you use a port of phpBB: i dont know
Version of phpBB: 2.0.15
Version of PHP: 4
Which database server and version: MySQL 4
Host: godaddy.com
Did someone install this for you/who:Me
Is this an upgrade/from what to what:no
Is this a conversion/from what to what: no
Have you searched for your problem: yes
If so, what terms did you try: regain deleted posts
State the nature of your problem:

One of my moderators accidently deleted 8000 posts in one of the forums trying to clean up it a little.... Little did he know, that we wanted all of those posts. It also made the post count at the bottom of the index page of the forum go down from 17,000 to 9000 and weve been working our way up ever since.

IS THERE ANY WAY TO GET THEM BACK OR INCREASE THAT POST COUNT AT THE BOTTOM?

SmartSquid399
Registered User
Posts: 98
Joined: Fri Jul 08, 2005 6:13 pm
Contact:

Post by SmartSquid399 » Sun Jan 08, 2006 9:55 pm

After you delete a post, it's gone. There's nothing you can do about it. Sorry. However, there might be a MOD that changes the number at the bottom of the page, but I doubt it.
Notepad2 || FireFox

I'm here to help with: PHP, phpBB (obviously), Server Set-up, HTML, CSS, and JavaScript.

starfoxtj
Registered User
Posts: 3714
Joined: Tue Jul 29, 2003 2:01 am
Contact:

Post by starfoxtj » Sun Jan 08, 2006 10:06 pm

Isnt that count stored in the database?
Ill double check.

You CAN however restore the posts from a backup.
I would recommend doing a full forum restore, otherwise extracting the posts by hand will be a pain in the butt.
Admin ToolKit v2.1a - An Admins most helpful tool for user management. Now Supports Mass User Deletion!
Change User's: names, passwords, emails, active status and avatar/pm permissions.
Ban/Unban Users, change Post and Resync Counts, and promote/demote users to admin.
Completely independent from your phpbb user account settings. No installation required, just upload one file.
User Upload ToolKit Beta - A quick and easy, 30 second-install, attachment mod. Now Supports Dynamic Thumbnails!

Bullmax
Registered User
Posts: 2016
Joined: Fri Jan 30, 2004 3:36 pm

Post by Bullmax » Mon Jan 09, 2006 2:02 am

Yes they are stored in the database. Hopefully you have made a backup before your moderator did this.

sticktacular
Registered User
Posts: 47
Joined: Sun Feb 20, 2005 11:46 pm

Post by sticktacular » Mon Jan 09, 2006 2:27 am

nope.... i already knew it was in the database, but theres no ONE FIELD where you can just change it....

Bullmax
Registered User
Posts: 2016
Joined: Fri Jan 30, 2004 3:36 pm

Post by Bullmax » Mon Jan 09, 2006 2:34 am

Not sure, but could you not extract that part of you backup and have it Drop table user_posts or whatever its supposta be and then Create the new one and run the sql query?

Of course this would be huge to run in phpmyadmin.

Locked

Return to “2.0.x Support Forum”