Kunena 7.0.5 & Kunena 6.4.11 – Security Updates Released

The Kunena team has announce the arrival of Kunena 7.0.5 [K 7.0.5] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0.

The Kunena team is also pleased to announce the eleventh version of Kunena 6.4, a native Joomla extension for Joomla! 5.0, 5.1, 5.2, 5.3, 5.4 and 6.0.

Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.

Idea Deleting messages of deleted user

More
15 years 5 months ago #79471 by kayaking
Shot in the dark here:

I deleted a spammer from the users using Kunena's delete user function.

I failed to click "Delete user's messages" first.

Is there any way to delete the User's messages (besides clicking delete on all 160 of them)?

Or a way to restore the user so I can delete their messages and then delete them?

Or a way to safely delete all their messages via the database, using their ID (But how to find the ID if they're deleted?).

Thank you in advance.
Galen

Please Log in or Create an account to join the conversation.

More
15 years 5 months ago - 15 years 5 months ago #79483 by kayaking
Here's what I ended up doing:
Create a new user on Joomla! using the deleted user's username.
Login to the database via SSH or PHPMyAdmin
Search for a spam message in jos_kunena_messages.
Get the user_id.
Change the newly created user's id to match the message's user_id in jos_users.
Sync Kunena users – be sure to check create profiles (you may be able to merely browse to the forum with the new user).
Delete the row containing the banned user's id that matches the message's user_id in jos_kunena_users_banned.
Find the user via Kunena (their username should appear).
Delete their messages.
Delete them.

In the case the messages don't disappear, you can always use PHPMyAdmin to find all messages with the user_id from a spam message and delete them all. It's ugly, but it works.

Kunena experts, feel free to tell me all I had to do was click x. :D
Last edit: 15 years 5 months ago by kayaking. Reason: added table names

Please Log in or Create an account to join the conversation.

Time to create page: 0.209 seconds