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.
User avatar
P_I
Community Team Member
Community Team Member
Posts: 2562
Joined: Tue Mar 01, 2011 8:35 pm
Location: Western Canada 🇨🇦

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

Post by P_I »

D. K wrote: Fri Jan 17, 2025 4:07 pm None of us knows SQL but can follow a step by step example and do a query via phpMyAdmin
Does this work for your needs? Executing SQL Queries in phpMyAdmin

I have taken the liberty to make the column headings a bit more 'friendly'.

Code: Select all

SELECT phpbb_users.username as "User", FROM_UNIXTIME(save_time) as "Draft was saved", draft_subject as "Draft Subject" 
FROM `phpbb_drafts` 
INNER JOIN phpbb_users 
ON phpbb_drafts.user_id=phpbb_users.user_id
ORDER by phpbb_drafts.user_id;
Normal people… believe that if it ain’t broke, don’t fix it. Engineers believe that if it ain’t broke, it doesn’t have enough features yet. – Scott Adams
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 »

Just for your info, this is a screenshot of the drafts table in the database with a draft in it.
Screenshot 2025-01-17 at 16-55-41 localhost 8888 _ localhost _ phpbb3314 _ phpbb_drafts phpMyAdmin 5.2.1.png
It shows the user ID of the person who made the post, the topic ID it's in, the forum ID it's in, the time it was written (in unix time stamp), the title of the topic and the text that was written.

If that table is empty, there are no drafts to see. It'll be interesting to know how many entries are in that table. The query P_I posted will allow you to see that.

In the forum, you actually have to go through two confirmation screens telling you it's only a draft and you're not actually posting, in order to get that far.
You do not have the required permissions to view the files attached to this post.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 6593
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.

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

Post by thecoalman »

You ca also just make a post and point them to the Manage drafts page in the UCP. Link is universal, just go to it in your own UCP, open manage drafts and copy the URL.

ucp.php?i=ucp_main&mode=drafts

Code: Select all

https://www.phpbb.com/community/ucp.php?i=ucp_main&mode=drafts
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
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.

We will give it a try this weekend & let you know.

Thanks again. :)
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 very much. :)
Things were not as bad as we feared.
We added forum_id.
It'll be interesting to know how many entries are in that table.
There were many drafts from just a few users. Mostly variations/repeats in different forums.

This is just enough.
This will let us know who we need to reach out to.

Thank you very very much! :D
User avatar
P_I
Community Team Member
Community Team Member
Posts: 2562
Joined: Tue Mar 01, 2011 8:35 pm
Location: Western Canada 🇨🇦

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

Post by P_I »

D. K wrote: Sat Jan 18, 2025 1:25 pm We added forum_id.
Updated SQL that adds the forum name (using forum_id)

Code: Select all

SELECT phpbb_users.username as "User", FROM_UNIXTIME(save_time) as "Draft was saved", phpbb_forums.forum_name as "forum", draft_subject as "Draft Subject" 
FROM `phpbb_drafts` 
INNER JOIN phpbb_users 
ON phpbb_drafts.user_id=phpbb_users.user_id
INNER JOIN phpbb_forums
ON phpbb_drafts.forum_id=phpbb_forums.forum_id
ORDER by phpbb_drafts.user_id;
Normal people… believe that if it ain’t broke, don’t fix it. Engineers believe that if it ain’t broke, it doesn’t have enough features yet. – Scott Adams
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 »

Even better! :!: :)
Thank you. :D

Return to “[3.3.x] Support Forum”