user registration problem

[ejoy]

hi there, 

my board is not allowing user registration, 

plz solve this out. 

[Jim M]

The user there is being denied by our Spam Defense system. If this is yourself testing registration or you trust the individual registering, you will want to add the details in the Spam Defense Whitelist in ACP -> Members -> Spam Prevention.

[ejoy]

I disabled spam prevention but still not signing up user. and also from my ACP if I want to create a member also not allowed. 

Edited September 17, 2023 by ejoy

[ejoy]

from my ACP creating new user a error is showing....

[Nathan Explosion]

Option 1: contact your host and ask them for assistance with disabling strict mode in MySQL/MariaDB

Option 2: disable or uninstall the resource that has added twoStep_activation to the core_members table (it's not a default column, it's from a resource you may have installed in the past)

Option 3: go into your database, and set a default value on the twoStep_activation field in the core_members table

 

[ejoy]

On 9/18/2023 at 12:10 AM, Nathan Explosion said:

Option 3: go into your database, and set a default value on the twoStep_activation field in the core_members table

what is the default value for twoStep_activation field and how to set it.

[teraßyte]

That column is not a default one, so it depends on the type of column it is. Maybe you can just make it use NULL as the default value (as long as it can be NULL). If you don't have the modification for it installed anymore, it's also possible to drop the column rather than adjust its default value.

 

Be sure to take a backup before making any changes, though.