Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Koper on December 05, 2020, 02:36:40 PM

Title: Registration 2.0.17
Post by: Koper on December 05, 2020, 02:36:40 PM
Why does the "Database error" error pop up during registration, if the error persists, please contact the administrator.
Where to find an error in the database
Title: Re: Registration 2.0.17
Post by: vbgamer45 on December 05, 2020, 03:59:09 PM
Check in your forums error log for clues Probably related to a mod.
Title: Re: Registration 2.0.17
Post by: Kindred on December 05, 2020, 08:21:53 PM
Url?
Smf version?
Mods Installed?
Title: Re: Registration 2.0.17
Post by: Koper on December 06, 2020, 08:07:03 AM
I found a hint that some formspring has no default value but I can't find this column in the database.
Title: Re: Registration 2.0.17
Post by: Sir Osis of Liver on December 06, 2020, 03:56:27 PM
That looks like a mod error.  You can use this query to find column name, then set it to 'null' -



SELECT table_name,table_schema
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name='formspring'


Title: Re: Registration 2.0.17
Post by: GL700Wing on December 07, 2020, 12:14:26 AM
Quote from: Koper on December 06, 2020, 08:07:03 AM
I found a hint that some formspring has no default value but I can't find this column in the database.
The 'formspring' column in the smf_members table is created by the Formspring Profile Field (https://custom.simplemachines.org/mods/index.php?mod=2677) mod.