Can the Admin find un-posted user drafts?

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
D. K
Registered User
Posts: 34
Joined: Wed Jul 17, 2024 7:15 pm

Can the Admin find un-posted user drafts?

Post by D. K »

Hello All.
Thanks in advance.

Can the Admin find/see un-posted user drafts? :?:
Last edited by P_I on Fri Sep 13, 2024 10:53 pm, edited 1 time in total.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26887
Joined: Fri Aug 29, 2008 9:49 am

Re: Can the Admin find un-posted user drafts?

Post by Mick »

Moderators and admin can’t see other people’s drafts in vanilla phpBB you would need an extension.
  • "The more connected we get the more alone we become” - Kyle Broflovski© 🇬🇧
User avatar
Crizzo
Translations & International Support Teams Manager
Translations & International Support Teams Manager
Posts: 1757
Joined: Thu Apr 23, 2009 1:20 pm
Location: Stuttgart, Germany
Name: Christian

Re: Can the Admin find un-posted user drafts?

Post by Crizzo »

But anybody with database access could look those drafts up.
My extensions for phpBB: CDB
German phpBB Support at www.phpbb.de
D. K
Registered User
Posts: 34
Joined: Wed Jul 17, 2024 7:15 pm

Re: Can the Admin find un-posted user drafts?

Post by D. K »

Thank you for replying.

Unfortunately, none of us are ready to learn SQL.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72663
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK

Re: Can the Admin find un-posted user drafts?

Post by KevC »

You don't need to.

There's a database table called drafts. You can just look at it.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
User avatar
Gumboots
Registered User
Posts: 821
Joined: Fri Oct 11, 2019 1:59 am

Re: Can the Admin find un-posted user drafts?

Post by Gumboots »

Question: why would you have a need to view anything that the person has not chosen to make public? It's a bit like trawling through someone's emails without their permission.
🇺🇦 Слава Україні! 🇺🇦 Героям слава! 🇺🇦
D. K
Registered User
Posts: 34
Joined: Wed Jul 17, 2024 7:15 pm

Re: Can the Admin find un-posted user drafts?

Post by D. K »

We would like to see drafts that are long forgotten by a user. And then to determine whether they should kept or deleted.
User avatar
AmigoJack
Registered User
Posts: 6128
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン

Re: Can the Admin find un-posted user drafts?

Post by AmigoJack »

I used drafts for temporary notes a while back and cannot imagine drafts eat any real amount of space at all - if that's your concern you could also tell people to not use BBCodes anymore - that would also save space.
  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
User avatar
[Dimetrodon]
Registered User
Posts: 494
Joined: Tue Aug 30, 2022 3:29 am
Location: Paleozoic Era

Re: Can the Admin find un-posted user drafts?

Post by [Dimetrodon] »

They don’t.

It is like worrying there are too many posts on your board and wanting to delete perfectly fine posts as a result.
Avatar by Phoenix-of-Starlight.
D. K
Registered User
Posts: 34
Joined: Wed Jul 17, 2024 7:15 pm

Re: Can the Admin find un-posted user drafts?

Post by D. K »

We would still like to see what user drafts are stored and the date they were last stored. Our users are not true computer users and we suspect they have saved posts instead of posting. Or they have forgotten to return and finish the post. Or they just don't know how to reload the draft (we know its easy but you don't know our users).
User avatar
warmweer
Jr. Extension Validator
Posts: 12072
Joined: Fri Jul 04, 2003 6:34 am
Location: somewhere in the space-time continuum

Re: Can the Admin find un-posted user drafts?

Post by warmweer »

D. K wrote: Thu Jan 16, 2025 4:22 pm We would still like to see what user drafts are stored and the date they were last stored. Our users are not true computer users and we suspect they have saved posts instead of posting. Or they have forgotten to return and finish the post. Or they just don't know how to reload the draft (we know its easy but you don't know our users).
If it's limited to seeing that certain users have drafts (without being able to read the drafts) then I think it's fine. But reading drafts is a step too far (personal opinion).

I'ld prefer seeing something like

Code: Select all

user_x has 3 drafts saved: date1, date 2 date 3
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
D. K
Registered User
Posts: 34
Joined: Wed Jul 17, 2024 7:15 pm

Re: Can the Admin find un-posted user drafts?

Post by D. K »

But reading drafts is a step too far (personal opinion).
Our users are really not the computer savy. (our estimate is the average age is 60-70 or more)

Knowing all the users with saved posts helps us help them. Especially when the saved post has been forgotten or has already been posted by them but has been saved different & forgotten.

In the least, being able to send them notice (& a link) that they have languishing/forgotten saved post(s) since xx/xx/xx.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72663
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK

Re: Can the Admin find un-posted user drafts?

Post by KevC »

They might be more savvy than you think.

Did you look at the database to see if indeed there are any drafts at all?
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
D. K
Registered User
Posts: 34
Joined: Wed Jul 17, 2024 7:15 pm

Re: Can the Admin find un-posted user drafts?

Post by D. K »

One more bit of info

Our Forum is NOT public facing. To register a user's identity has to be verified.

Our membership will never exceed 650-700 verified users.
D. K
Registered User
Posts: 34
Joined: Wed Jul 17, 2024 7:15 pm

Re: Can the Admin find un-posted user drafts?

Post by D. K »

KevC wrote: Fri Jan 17, 2025 3:52 pm They might be more savvy than you think.

Did you look at the database to see if indeed there are any drafts at all?
As Admins (65-75 years old) also we are only slightly more computer savvy. For us (Admin ) to get things accomplished it often takes lots of time, trial & error and checking to see what we have broken.

None of us knows SQL but can follow a step by step example and do a query via phpMyAdmin

Return to “[3.3.x] Support Forum”