Registration Failed..!

[danster]

Hello..!

I'm using smf ver 2.0.15 and I have a problem with the registration for members.. new members complaining cos they cannot register on my forum because of the error

This is the error message

Database Error
Please try again. If you come back to this error screen, report the error to an administrator.

Please can you help me to correct that issue.. please tell me hot to correct it..

Thank you

I attache a screen shot

[danster]

when I try to manual register the member this error message will popup


Database Error
Field 'inactive_mail' doesn't have a default value
File: /home/slwalzon/public_html/Sources/Subs-Members.php
Line: 777

[Kindred]

that would be from a mod...

either remove the mod that is causing the issue or give the column a default value in the database (usually default NULL works)

[danster]

that would be from a mod...

either remove the mod that is causing the issue or give the column a default value in the database (usually default NULL works)

This issue is happen suddenly I didit install or unstall any mods in last few weeks so i cannot be  from a mod I think anyway please tell me how to reset it default value in  data base

[Kindred]

it *IS* from a mod since "inactive_mail" is not a standard SMF field.

it probably happened because your HOST changed something

Go to your database using phpmyadmin
select the table
select the column
choose edit
set a default of NULL for the column
Save

[danster]

it *IS* from a mod since "inactive_mail" is not a standard SMF field.

it probably happened because your HOST changed something

Go to your database using phpmyadmin
select the table
select the column
choose edit
set a default of NULL for the column
Save

I try to do that and go to phpmyadmin and select the table and select the column

and I see like this pls check this and tell me what I have to do

I attached a screen shot

[Kindred]

that is the table ezp_columns....   that's not the correct table.

sicne it's from a mod, it could be anywhere... but also, since the failure is in Subs-Members.php, I'd suggest looking in the smf_members table (or maybe ezp_members in your case)

[danster]

that is the table ezp_columns....   that's not the correct table.

sicne it's from a mod, it could be anywhere... but also, since the failure is in Subs-Members.php, I'd suggest looking in the smf_members table (or maybe ezp_members in your case)

I found this in phpmyadmin are see attached

[SpacePhoenix]

Could the OP's host have upgraded the MySQL version and turned on MySQL's "strict mode"?

[Arantor]

Could the OP's host have upgraded the MySQL version and turned on MySQL's "strict mode"?

Yes.

I found this in phpmyadmin are see attached

This is the right table. Hit 'Structure' at the top to see the list of columns, then you can edit the specific column that's giving you trouble.

[danster]

Could the OP's host have upgraded the MySQL version and turned on MySQL's "strict mode"?

Yes.

I found this in phpmyadmin are see attached

This is the right table. Hit 'Structure' at the top to see the list of columns, then you can edit the specific column that's giving you trouble.

Thank you very much for assisting to resolve my issue.. I found it and it working fine now