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.

Question Error when posting in Kunena Forum @ my site.

More
9 years 10 months ago #178001 by Keriko
Hello

I got a question related to Kunena forum at my site. When posting new topics, I get these errors like:

Incorrect key file for table './novanagaming_co/#__kunena_topics.MYI'; try to repair it SQL=INSERT INTO `#__kunena_topics` (`category_id`,`subject`,`icon_id`,`hold`) VALUES ('12','Best healing classes in Legion (Method)','2','4')

or

Duplicate entry '393446' for key 'PRIMARY' SQL=INSERT INTO `#__kunena_topics` (`category_id`,`subject`,`icon_id`,`hold`) VALUES ('18','test','0','4')

I would love to understand what is wrong and be able to fix it, anyone that could lend me a hand :)?

Cheers

Site: www.novanagaming.com

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

More
9 years 10 months ago #178006 by 810
The table name is wrong.
change it to:
Code:
./novanagaming_co/#__kunena_topics'
then it should work.

For the second question:
There is already the id 393446. Best is to remove that one, and try again. But first make backups.

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

More
9 years 9 months ago #178080 by Keriko
Hi

Could you explain the first part abit more easy friendly for me please, I am still learning :)

As for the second part, for a while ago I had way to many guests, 500-1000+ at the forums. There still are 200-400+ everyday to this day, which I am guessing is bots. Before I installed the "I am not a robot" thingy at the forum to register, those bots were spamming accounts and the forum with a millions posts, I just made sure to delete all those bot accounts manually and deleted all their posts in the forum after I got the "I am not a robot" thingy. Might this be the problem why there is a duplicate of an ID? If so how to fix this :)?

How can I also stop bots camping in my forum, they are terrifying ::P:

I appriciate all the help I can get :)

Cheers
Keriko

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

More
9 years 9 months ago #178215 by Keriko
I can understand if nobody wants to use their energy in helping me in this matter. If there is any posts out there that covers this kinda situations, a link would be appriciated :)

Cheers
Keriko

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

More
9 years 9 months ago #178218 by 810
you have a database issue, you need to remove the item on the _kunena_topics table. it should be the last id. Then do a recount, on the backend - kunena - tools

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

More
9 years 9 months ago #179085 by Keriko
Done :)! It worked, many thanks! Any tips by the way on the ID situation, I posted a test on the forum and it got the ID "393446" at the Database. I am guessing since a while ago the site was getting bot spams and those were posting aaaaaa lot on the forum, which generated a lot of ID's. It's more of an OCD problem of mine rather than a real problem I guess :P

Aswell, they are still swarming at my site, 200-500+ guests online, thats just bots. Some are still being able to register a user at the site it seems, even with the googles "I am not a robot" check at the registration. Any tips how I can improve this and remove those bots from swarming my site everyday and risking getting more registered user by bots?

Cheers
Keriko

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

Time to create page: 0.198 seconds