January 12 in Technical Problems
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.“)
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)
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?
You should probably remove the field if the app/plugin isn't installed anymore!
Started Thursday at 02:49 PM
Started 8 hours ago
Started Saturday at 01:22 AM