2.1 RC1 New User Registration - Database Error!

[arslun]

Unable to register a new user. Tried multiple times, keep getting the following error:

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

[Illori]

anything in the error log?

[arslun]

Here is the log:
******
Type of error: Database
Database Error: Field 'adk_pages_notifications' doesn't have a default value
/index.php?action=signup2

/Sources/Subs-Members.php (Line 709)

[vbgamer45]

That's from an old mod you can either drop that column frrom the members table or make sure that it allows null.

I think it mostly is caused by this line which forces proper SQL in mysql

Code Select Expand


mysqli_query($connection, 'SET SESSION sql_mode = \'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\'');


[arslun]

Thanks for the quick response.
I will take a look at that table and try to fix.
Welcome to provide any solutions/comments.
Thank you

[vbgamer45]

Try that first if not remove that line in Subs-Db-mysql.php (102)

[arslun]

Hi vbgamer45,
Removed that line but still got the same error message.
I even didn't find such a field in the database. I searched from the logs and found that that field seems from a mod called adkportal which made the whole forum not-accessible by returning http 500 error. So I reinstalled the forum and pointed the newly installed forum to the old db.

How do we clean the old tables?

Thanks

[albertlast]

a pr from my side exists which could possible fix the issue: https://github.com/SimpleMachines/SMF2.1/pull/5401
but i don't know if it works and if this get merge.

When you got the chance you could test this.

[shawnb61]

First theory is that you somehow still have the hooks installed.   

If you installed the 2.1 code on top of your 2.0 code, and the hooks are still there, it may be trying to execute. 

To confirm, 2 questions:

1) Do you have a bunch of settings in your smf_settings table that start with "integrate_", e.g.:
   integrate_actions   Adk_portal_add_index_actions
   integrate_admin_areas   Adk_portal_add_admin_areas
   integrate_buffer   Adk_portal_change_buffer
   integrate_display_buttons   Adk_portal_display_buttons
   integrate_load_permissions   Adk_portal_Permissions
   integrate_load_theme   Adk_portal_load_from_theme
   integrate_menu_buttons   Adk_portal_add_menu_buttons
   integrate_pre_include   $sourcedir/AdkPortal/Subs-adkfunction.php
   integrate_pre_load   Adk_portal_pre_load
   integrate_redirect   Adk_portal_redirect
   integrate_whos_online   Adk_portal_who

2)  Do you still have an /adkportal folder on your forum?

[shawnb61]

I even didn't find such a field in the database. I searched from the logs and found that that field seems from a mod called adkportal which made the whole forum not-accessible by returning http 500 error. So I reinstalled the forum and pointed the newly installed forum to the old db.

arslun -

We're pretty sure that column exists in your database, or you wouldn't be getting this error.  It would be in your members table, & would look something like the attached (which is from phpmyadmin, for the members table, under "Structure" tab).   If you are not using adkportal, you should delete the column.  If you *are* still using adkportal, then you need to provide a default value for that column (null works). 

Attached is what this will look like in phpmyadmin. 

Take another peek!

[arslun]

It issue has be resoled after removing those 2 adk_* fields from the table.

Thanks for our help.