Sign Up error

[skb]

I have the 2.1 from the Nightly Build (last_commit_f1adaab) and am noticing the following errors on new Sign Ups. I have 2 additional Profile Fields on SignUp, though they are not compulsory.

Type of error: Database
Database Error: Field 'num_bg_values' doesn't have a default value
https://www.diabetesforum.online/index.php?action=signup2
/home/diabesv6/public_html/Sources/Subs-Members.php (Line 712)

Line 712 says "1"

Code Select Expand

// Register them into the database.
$memberID = $smcFunc['db_insert']('',
'{db_prefix}members',
$column_names,
$values,
array('id_member'),
1
);

Any help would be appreciated.

[Illori]

you would have to find that column in the database and set a default value. most likely "null" would resolve this issue.

from the query you posted it should be in the members table.

[Sir Osis of Liver]

I have an older build, but there is no 'num_bg_values' column in the db.  Either it's been added recently or it's a mod field.  You can use this query to find it -

Code Select Expand



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



[skb]

Thanks. That did it.

[skb]

I have an older build, but there is no 'num_bg_values' column in the db.  Either it's been added recently or it's a mod field.  You can use this query to find it -

It generates because of the additional Profile Fields that I added.

[Sir Osis of Liver]

This has been a frequent problem, I'm wondering why there are still empty fields in 2.1.

[Illori]

most users facing this issue are using SMF 2.0. it is very rare for a 2.1 user to report this.

[albertlast]

The problem is the smf api which defined by default mod added colum as not null.
In 2.1 the issue could be fixed by this pr. https://github.com/SimpleMachines/SMF2.1/pull/5722

It's not very rar to report this issue until this get fixed...

[live627]

most users facing this issue are using SMF 2.0. it is very rare for a 2.1 user to report this.

rare because of a tiny userbase