This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 236059

Summary: Cannot register a new user on http://forums.netbeans.org/
Product: www Reporter: machinegodzilla
Component: AdminAssignee: Jan Pirek <jpirek>
Status: RESOLVED FIXED    
Severity: normal CC: machinegodzilla
Priority: P1    
Version: 8.0   
Hardware: PC   
OS: Linux   
Issue Type: DEFECT Exception Reporter:
Attachments: broken new user registration

Description machinegodzilla 2013-09-17 08:40:57 UTC
Created attachment 140162 [details]
broken new user registration

Steps to reproduce:

1. Go to http://forums.netbeans.org/profile.php?mode=register
2. Enter all the necessary details.
3. Hit submit.


Expected results:

A confirmation page.


Actual results:


Could not insert data into users table

DEBUG MODE

SQL Error : 1364 Field 'user_spam_warnings' doesn't have a default value

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (35558, 'xxx', 1379260926, 'xxx', 'xxx', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 0, 1, 0, 1, 1, 0, 1, 1, 0, 'D M d, Y g:i a', 'english', 1, 0, 1, 0, '3dae8eeea5468649')

Line : 650
File : usercp_register.php
Comment 1 Jan Pirek 2013-09-18 08:12:54 UTC
fixed