CMS MADE SIMPLE FORGE

Self Registration

 
Back Back to List

[#10747] "Field 'group_id' doesn't have a default value" error with strict SQL mode

avatar
Created By: Tristan (tristan)
Date Submitted: Thu Nov 12 06:06:20 -0500 2015

Assigned To:
Version: 1.9.3
CMSMS Version: 1.12
Severity: Minor
Resolution: Fixed
State: Closed
Summary:
"Field 'group_id' doesn't have a default value" error with strict SQL mode
Detailed Description:
When trying to add a new frontend user with Self Registration I get a:

Field 'group_id' doesn't have a default value

error. This is with "Require membership in atleast one group" set to either no
or yes and a "Default Group for new users" set to an existing group.

After some digging around I noticed this error disappears when you disable
strict SQL mode. IMHO it would be better to have it work with SQL strict mode
enabled as well since this seems to be the default for new MySQL installs.


History

Comments
avatar 
Date: 2016-04-19 11:57
Posted By: TimdeBuurman (timdebuurman)

Is there some workaround for this?
grtz Tim
avatar 
Date: 2016-05-18 12:59
Posted By: TimdeBuurman (timdebuurman)

Some update.
After upgrade to SelfRegistration 1.9.6 the error message has changed to
Field 'id' doesn't have a default value
avatar 
Date: 2016-05-19 13:29
Posted By: Robert Campbell (calguy1000)

Please provide exact steps to reproduce the issue.
avatar 
Date: 2016-09-01 20:09
Posted By: peter (pukka77)

Having the same error "Field 'group_id' doesn't have a default value"

Running:  
==================
CMSMS 2.1.4
CGExtensions	1.53.10
CGSimpleSmarty	2.1.2
FEU 2.0.7 
Selfregistration 1.9.6
==================

- FEU & selfreg installed, groups have been created (with properties assigned to
the group)
- Require membership in at least one group has been selected and the group has
been selected as the default group for new users
- The group has also been included in the protected page settings in FEU
(although the error was occurring even without this)
avatar 
Date: 2016-09-01 20:11
Posted By: peter (pukka77)

Forgot to mention: 
The error occurs when i try to create a new user on the frontend of the site
(via the user registration page)
avatar 
Date: 2016-09-02 14:24
Posted By: Robert Campbell (calguy1000)

fixed in svn.
Updates

Updated: 2017-09-22 10:11
state: Open => Closed

Updated: 2016-09-02 14:24
resolution_id: 5 => 7

Updated: 2016-05-19 13:29
resolution_id: => 5