Kunena 7.0.6 & Kunena 6.4.12 – Security Updates Released

The Kunena team has announce the arrival of Kunena 7.0.6 [K 7.0.6] 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 twelfth version of Kunena 6.4, a native Joomla extension for Joomla! 5.0, 5.1, 5.2, 5.3, 5.4 and 6.0.

Question Huge database - Spam staying after deleted?

More
15 years 10 months ago - 15 years 10 months ago #55719 by sozzled
Replied by sozzled on topic Re: Huge database - Spam staying after deleted?
For comparison purposes, I've included a screenshot of a K 1.5 installation that you might be interested in seeing:


You might find this article helpful: dev.mysql.com/doc/refman/5.1/en/optimize-table.html

I looked at your site. The pertinent statistic is circled below:


I don't know why three-and-a-half thousand messages translates into 60,000 records. It might be useful for you to look into the database to see how those records relate to your forum.

Maybe someone else has some ideas?
Blue Eagle vs. Crypsis reference guide
Read my blog and
[img
Last edit: 15 years 10 months ago by sozzled.

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

More
15 years 10 months ago #55933 by Matias
Replied by Matias on topic Re: Huge database - Spam staying after deleted?
I have an idea.. Or two:

First you need to check that jos_messages and jos_messages_text have primary keys. If not, it may be the cause of this issue.

There may also be issue with table integrity: mesages outside categories or thread, missing data etc..

I have a few queries I want you to run. Please check your private messages, but answer into here.

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

More
15 years 10 months ago #56010 by rocketman007
Replied by rocketman007 on topic Re: Huge database - Spam staying after deleted?
After some further research, it appears there was a hidden category that contained almost 55k spam topics. This is not my site, so I was unaware of this at first. When trying to remove the category, a php out of memory error triggered; however the subforum was still removed. The posts however are still in the DB. When deleting a subforum, do the posts normally stay in the DB? Is there a way to manually remove them later?

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

More
15 years 10 months ago #56198 by Matias
Replied by Matias on topic Re: Huge database - Spam staying after deleted?
You can delete the messages by hand, yes. But that's very dangerous action if you don't know what you're doing (potentially deleting all the messages by accident).

Idea is to check what was the catid of those messages and then delete WHERE catid=X for both jos_fb_messages and jos_fb_messages_text. I will not provide actual SQL in the public and you should REALLY take backup from the tables before doing this.

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

Time to create page: 0.277 seconds