×
Kunena 5.2 Beta 1 Released (24 Sep 2020)

The Kunena team is thrilled to announce the first public beta release of Kunena 5.2, a native Joomla extension for Joomla 3.9. This is a development release and should be only be used for testing; this version is not recommended for live websites at this stage.

The purpose of this release is to encourage testing by downloading, installing and identifying any problems or shortcomings that people may discover. K 5.2.0 B1 is stable and we are aware that people will discover defects. We encourage you to use the forum to report defects, as soon as they are discovered, so that the development team can work through the problems before the release of K 5.1 as a stable product. Reporting defects does not mean that the problems can or will be fixed. The Kunena team is looking forward to hearing your feedback on how well we have achieved our design goals.

× This is for users to help other users, to discuss topics that are related to forum administration in general or problems in running Joomla. This is not the place to ask for Joomla support. If you want assistance with Joomla please ask at forum.joomla.org

Important Reset all tables

More
5 years 8 months ago #1 by aalhait
Reset all tables was created by aalhait
I've had the forum up for almost a year and I just found out that it has been used for Spam. I need to reset ALL User and ALL posts. Since I really never configured it.

How do I do it fast via mySQL admin? SQL calls?

I do not want to reset all of Joomla, but I can also use a SQL call to delete all users there (except the admin of course) Does anyone have insight on that?

Thanks much!

Also how do you add the Captcha? Is there a plugin I can add to that to avoid spammers?

Thanks again!

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

More
5 years 8 months ago #2 by aalhait
Replied by aalhait on topic Reset all tables
It seems the amount of data is in the Gigs! I think it's almost 10GBs! that's why the web console is not working and timing out. Almost 1M posts and 20K users!

This is what happens when you have no clue the developer who installed your website did not know what he was doing! Even though the registration form was never there! But how would spammers find out the site is a Joomla site and where to look! it was not even published! and was hidden in a development directory!

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

More
5 years 8 months ago #3 by aalhait
Replied by aalhait on topic Reset all tables
OK here's what I've done to save a total of 28 GBs!

In mySQL admin

I ran the following commands:

TRUNCATE yourdbname.ic7dh_kunena_user_topics
TRUNCATE yourdbname.ic7dh_kunena_messages_text
TRUNCATE yourdbname.ic7dh_kunena_messages
TRUNCATE yourdbname.ic7dh_kunena_topics

I don't know what else to run I have an issue with the users also but I will dig a little more

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

More
5 years 8 months ago - 5 years 8 months ago #4 by 810
Replied by 810 on topic Reset all tables
Hi, i think your website is on a list, for spammers, once they notice its easy to post, they create scripts to do that.

What i use for spam is: github.com/joomlaworks/Akismet-For-Kunena
download link is on the bottom, you need a key from akismet.com (free)

If you not use kunena anymore, you have the default captcha plugin. you need to enable that. and check the user settings.
Last edit: 5 years 8 months ago by 810.

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.091 seconds