NZyan Posted January 12 Posted January 12 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.“)
NZyan Posted January 12 Author Posted January 12 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
Solution NZyan Posted January 12 Author Solution Posted January 12 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 Posted January 12 Posted January 12 You should probably remove the field if the app/plugin isn't installed anymore! NZyan 1
Recommended Posts