Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 61 guests, and 388 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Ruben
Ruben
Lutz,FL
Posts: 5,825
Joined: December 2003
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 16
M4TT 11
FREAK 11
Ruben 6
mmkk 5
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
How to find a deleted post? #256168
12/03/14 04:39 PM
12/03/14 04:39 PM
Joined: Oct 2006
Posts: 370
Issaquah, WA
Bill B Offline OP

enthusiast
Bill B  Offline OP

enthusiast
Joined: Oct 2006
Posts: 370
Issaquah, WA
I thought that this would be easy.

I have a "word" or two of what was in a deleted post. But I can't find the post.
I also think I know which Moderator did it (1234)

Suggestions?

Using MySQL Query Browser:

SELECT * FROM ubbt_ADMIN_LOG where LOG_ACTION = 'DELETE_POST'
and
SELECT * FROM ubbt_POSTS where USER_ID = 1234 and POST_BODY like "%word%"
and
SELECT * FROM ubbt_ADMIN_LOG where LOG_ACTION = 'DELETE_POST'and USER_ID = 1234

Using the last SELECT statement above, I can find the TITLE of the POST -- How do I find the actual Post?


--BIll B
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: How to find a deleted post? [Re: Bill B] #256169
12/03/14 04:44 PM
12/03/14 04:44 PM
Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
Mark S Offline
Mark S  Offline

Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
I thought when they were gone they were gone ? O the logs. . . . . .

If its not a recent post and you want to see its content, dive into a back up you may have ?
Then you can see a time and date as reference to search your live logs.

I back up every night, so it covers me as long as its out side 24hrs so to speak.

Last edited by Mark S; 12/03/14 04:46 PM.

Version v7.5.8
People who inspire me Gizmo ID242 SD
Its been a long road. . . .to be waiting
Re: How to find a deleted post? [Re: Bill B] #256170
12/03/14 04:48 PM
12/03/14 04:48 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
When a POST is deleted, it is gone forever.

When a PRIVATE TOPIC is deleted it remains until all users delete it.

There is no recovery of a deleted post as the data is pruned from the database once the delete command is initiated.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: How to find a deleted post? [Re: Gizmo] #256171
12/03/14 05:10 PM
12/03/14 05:10 PM
Joined: Oct 2006
Posts: 370
Issaquah, WA
Bill B Offline OP

enthusiast
Bill B  Offline OP

enthusiast
Joined: Oct 2006
Posts: 370
Issaquah, WA
Shucks.. Yes, it was deleted about 2 days ago.

I need to figure out how to do incremental backups... or else just bite the bullet and backup the whole thing every night. But I hate to take that performance hit, since I have always have folks online during the 24 hours.

Thanks for the bad news. :-(


--BIll B
Re: How to find a deleted post? [Re: Bill B] #256172
12/03/14 06:57 PM
12/03/14 06:57 PM
Joined: Oct 2006
Posts: 370
Issaquah, WA
Bill B Offline OP

enthusiast
Bill B  Offline OP

enthusiast
Joined: Oct 2006
Posts: 370
Issaquah, WA
We need something like a "dead-letter-box" to retain deleted postings for 30 days.

Maybe if I submit this as a future upgrade to UBB.... ha ha.. What the heck was I thinking??!!!


--BIll B
Re: How to find a deleted post? [Re: Bill B] #256173
12/03/14 07:08 PM
12/03/14 07:08 PM
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,786
Portland, OR; USA
I generally tell my staff to move threads/posts to a hidden staff only forum called "Trash Bin" then admin's are responsible for the final deletion (unless the post was made as obvious spam).

In UBB.Classic we had a mod for "Trash Bin Forums" whereby the delete would simply move the thread to that forum by itself. In Threads I'd say, if it ever made it as a feature, that posts/threads have a new cell in the database table for "deleted" and then mods can mark things for deletion and it'd simply put a 1 in that cell and then a CP entry (like post moderation) would be triggered for an admin to make the final call; but that's a pipe dream at this point of that ever being an official feature.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: How to find a deleted post? [Re: Gizmo] #256174
12/03/14 10:31 PM
12/03/14 10:31 PM
Joined: Oct 2006
Posts: 370
Issaquah, WA
Bill B Offline OP

enthusiast
Bill B  Offline OP

enthusiast
Joined: Oct 2006
Posts: 370
Issaquah, WA
Thanks... Yes, I have the hidden thread where I MOVE discussions instead of deleting them. Have had that for years - probably because of a suggestion from you during the way-back years!
crazy

Unfortunately an over-zealous Moderator deleted three postings from an 80-year old man who made some over-the-line comments. Now everyone is playing the pity card -- and the missing posts would have done a lot to simmer them down.

A similar situation to "other places" where people make up their minds withOUT reviewing the facts.

Re: How to find a deleted post? [Re: Bill B] #256177
12/05/14 07:30 PM
12/05/14 07:30 PM
Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
Mark S Offline
Mark S  Offline

Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
Or
Create a New user (its your fake account).
Use a gmail account or outlook.com a free one that you can fill with e-mails.

Register with your free e-mail account.
Then watch All your forums and request an e-mail any time a new post / reply is made.

There you have a archive for just in case.

Well first draft anyway.


Version v7.5.8
People who inspire me Gizmo ID242 SD
Its been a long road. . . .to be waiting
Re: How to find a deleted post? [Re: Bill B] #256178
12/09/14 02:14 PM
12/09/14 02:14 PM
Joined: Oct 2006
Posts: 370
Issaquah, WA
Bill B Offline OP

enthusiast
Bill B  Offline OP

enthusiast
Joined: Oct 2006
Posts: 370
Issaquah, WA
That would work... but.....

I already use a "spare" GMail account to receive snapshots of the security camera that I have at my house. It gets 1 a minute sent to it, unless there is movement, the it gets an email with photo attached -- every 5 seconds!!!! Gotta love Gmail!!!!!

(Once a month I go in and delete all of them.)


--BIll B

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,536
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)