How to auto delete the non-activated users.

[Outbreaker]

Hi,
Is there a way to delete the non-activated users from Joomla after X days.

[toivo]

The simplest way is to use SQL queries, like the attached examples, assuming that you know your way around phpMyAdmin, MySQL Workbench or a similar MySQL client.

The first example lists the users who have not been activated within the set number of days. The second script creates first a temporary table of the users to be deleted, then removes the entries of those users from the table _user_usergroup_map and deletes them from the _users table.

This example could run without the temporary table, but it simplifies the queries when associated tables created by third party components during the registration need to be cleaned up, too.

Remember to back up the database first, just in case! Replace 'puhj1' with your own table prefix and set the variable @days to the number of days required.

List the candidates, showing the activation hash as verification:

Code: Select all

SET @days = 10;
SELECT id, username, DATE_FORMAT(registerDate, '%Y-%m-%d') AS registered, activation FROM puhj1_users
WHERE ((registerDate < DATE_SUB(CURRENT_DATE, INTERVAL @days DAY)) AND (activation NOT IN (' ', '0')));

Delete the users who have not been activated within the specified number of days:

Code: Select all

SET @days = 10;
DROP TEMPORARY TABLE IF EXISTS delete_users;
CREATE TEMPORARY TABLE delete_users
SELECT id FROM puhj1_users
WHERE ((registerDate < DATE_SUB(CURRENT_DATE, INTERVAL @days DAY)) AND (activation NOT IN (' ', '0')));
DELETE m FROM puhj1_user_usergroup_map m INNER JOIN delete_users ON id = user_id;
DELETE u FROM puhj1_users u INNER JOIN delete_users d ON d.id = u.id;

[Outbreaker]

Is there a way to run this automatically even Hour or every Day?
I'm just done updating to Joomla 4, would be the new "Scheduled Tasks" a solution for doing this?

[toivo]

It would be possible with cron or Scheduled Tasks but a PHP CLI script is needed.

Alternatively, the sequence of SQL commands could be fired from a task plugin, described in this article in the Joomla! Community Magazine: Get to know the new Joomla! Task Scheduler.

[Webdongle]

https://extensions.joomla.org/extension ... estbefore/
https://extensions.joomla.org/extension ... r-cleaner/
may be of interest

[Outbreaker]

I also stubble across those paying plugins. But no one works with the Joomla 4 "Scheduled Tasks" and i would be really nice to have an open-source plugin for this, it should even be included by default in Joomla to remove the spam accounts or user typo errors in emails.

I put a $20 bounty on such a open-source "Scheduled Tasks" plugin, because my coding sucks and want to make Joomla better.

[AMurray]

The second one listed above I assume it has an internal mechanism that checks for users not logged in (since registration) for X days.

The first one is for J3 only and not updated in the last 14 months.

[Webdongle]

...
The first one is for J3 only and not updated in the last 14 months.

Oh yes. my bad I copy/pasted the wrong url

[mandville]

The simplest way is to use SQL queries, like the attached examples, assuming that you know your way around phpMyAdmin, MySQL Workbench or a similar MySQL client.

could someone be so bold as do a free plugin for this?

[toivo]

I'll give it a go

[toivo]

One has to learn to walk before running... Instead of a task plugin, here is a Joomla 4 back end module called NonActivated for starters. The module lists and deletes user accounts that remain nonactivated after a set number of days. It is a rough product but at least it gives me inspiration to tackle the task plugin.

The module is safe to use because it relies on the User::delete() function to delete users and clean the #_user_usergroup_map. The User::delete() function triggers also the onUserBeforeDelete and onUserAfterDelete plugin events.

Feedback and suggestions are welcome! If this module is found useful, it will be submitted to JED.

NonActivated-Module-Parameters.png

NonActivated-Module-Example.png

[Outbreaker]

Nice, After a quick test run i couldn't find any errors.
It's astonishing how many user type their emails wrong. I surprised that some big Joomla sites have still user ID's left.

[Outbreaker]

A scheduled task would be excellent to fully atomize it. Because the back-end module is only triggered when someone logs into the back-end.
I'm also don't get it way Joomla has after so long not added something like this by default, including a Clear Caches Scheduled Task.