How to query an email list of users that are not actived


I would like to have an email list of users who are not actived.
So I can send them a reminder.

I also suggest that Discourse have this feature:
Auto resend an activation email after x day, or have a bulk-resend in admin tools.

If you have the Data Explorer plugin installed on your site, you can get a list of users who have not responded to the activation email with the following query:

SELECT AS user_id,
FROM users u
JOIN user_emails ue
ON ue.user_id =
WHERE = false

I seem to remember this being implemented, with x = 1 day.

Since Discourse 2.3 a reminder (one reminder) will be sent to users who sign up but do not activate. This is completely automatic.


This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.