Question Error when posting in Kunena Forum @ my site.

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

The table name is wrong.
change it to: 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.

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 ::

I appriciate all the help I can get

Cheers
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

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

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

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

Keriko wrote: 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')

Hello,

I don't know if you are using dedicated server or shared hosting but do-you have checked if you have still enough disk space ?

7540 / 15360 MB
It's hosted via one.com

Why is this important right now? Curious

Cheers
Keriko

I got enough space as far I am aware of

I added an attachment, image of the ID section in the database about Topics. Since I have removed the topics that spam bots left behind, it generated high ID number, so as you can see there, I did a test post after the tips I got here about how to fix the SQL error. So it all works fine, but how can I "reset" the ID number to start from 5 instead of 393446 as you can see on the image?

And again, the second question was how can I get better security to stop the swarm of bots crawling at my site everyday. 200-500+ as guests, and thats only bots. I have the "I am not a robot" check box on registration, but still they bypass it

Cheers
Keriko