• Hi guys,
    Our WordPress website got a problem recently with spam registrations. Im deleting those accounts manually at the moment but the problem is the ID number which is not reseting. No matter how much accounts I delete ID number continues from last registration. Is there some way how to reset or delete ID number to continue from last real user or not?
    Maybe if you can you can also help me with spam and fake registrations, how to get rid of them or block them?
    Thanks!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Hey!

    User Email Activation is available if you have WPForms User Registration. When you require a user to click a confirmation link in their email, spambots are less likely to get through this security step.

    Another way to stop spam user registrations is using a CAPTCHA.

    Thread Starter beat sk

    (@beatwell)

    Ah thank you, i will try it. And how can I reset the IDs of user to continue with last registered ID and not after it was deleted?

    Sorry, looks like I did not quite understand your last question

    Thread Starter beat sk

    (@beatwell)

    Every user has his own ID after registration (user ID) but because of that annoying registrations every new user has the next number after the (deleted) user accounts specific ID. I want to continue right after normal registrations. We want to have for “userregistred1” id what has “deleteduser1” after registration but that usernwas removed. Deleteduser1 has 8433 ID but last normal user has 764 ID and every after that was SPAM. I deleted that account but every new have the next one ID “8434, 8435..” etc.

    You can use the ALTER TABLE command:

    ALTER TABLE TABLE_NAME AUTO_INCREMENT = [New Number];

    Just edit the number you want the further ID’s to go from. Or set it in phpMyAdmin Operations tab.

    This would be done manually, not sure how to automate this process, sorry!

    Thread Starter beat sk

    (@beatwell)

    Hello,

    I do not understend? Where it i find? How to change it? I am sure with one option, we need it, but dont know how to do it. Where is Alter table? What is it?

    Thank you.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘SPAM registrations’ is closed to new replies.