Jump to content

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


Go to solution Solved by NZyan,

Recommended Posts

Posted

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.“)

 

Could contain: Page, Text, Chart, Plot

Posted

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
Posted

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

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...