NZyan Posted January 12 Share 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.“) Link to comment Share on other sites More sharing options...
DawPi Posted January 12 Share Posted January 12 Related? 🤔 Link to comment Share on other sites More sharing options...
NZyan Posted January 12 Author Share 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 Link to comment Share on other sites More sharing options...
Solution NZyan Posted January 12 Author Solution Share 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 Link to comment Share on other sites More sharing options...
Daniel F Posted January 12 Share Posted January 12 You should probably remove the field if the app/plugin isn't installed anymore! NZyan 1 Link to comment Share on other sites More sharing options...
.thumb.png.72c24494603afd7a572d55d4a71e4af2.png)
Recommended Posts