After mySQL 8 Update: New registrations create 7 (seven) accounts

[NZyan]

After my provider updated mySQL to version Version 8.0.35-27 new registrations create seven accounts.

All with identical username and email address.

I started a test registration (which also created 7 accounts), it resulted in a error 2S129/1 („You are not permitted to register a user account with this site.“)

 

[DawPi]

Related? 🤔

 

[NZyan]

Update: The error message for the new user comes from the spam defense I think:

The first three new accounts have first Level 1 (OK), then it escalates quickly to Level 3 and 4 (most likely and known spammer)

Andreas

[NZyan]

I think I found the issue, it's related to this one:

My provider switched to mySQL strict mode during the mySQL update.

This triggered an error during the creation of a new account.

The table ipb_core_pfields_content had two fields for Stop Forum Spam (not sure if this is still installed), one of them without default value.

Looks as if the SQL statement fixes the issue:

ALTER TABLE `ipb_core_pfields_content` CHANGE `sfsNextCheck` `sfsNextCheck` INT NOT NULL DEFAULT '0';

@Marc Stridgen Does this explain the multiple accounts?

Andreas

[Daniel F]

You should probably remove the field if the app/plugin isn't installed anymore!