MySQL error: Field 'j4s_user' doesn't have a default value

[tron90]

Hi,

For some reason I am not being able to create new users. It used to work fine, but now I get the following:

Query Failed:INSERT into users set id='f0890cc7-7e5b-3782-747d-4c22522f1ff3', user_name='malena', sugar_login='1', first_name='Malena', last_name='Franco', reports_to_id=null, is_admin='0', external_auth_only='0', receive_notifications='1', description=null, date_entered='2010-06-23 18:27:51', date_modified='2010-06-23 18:27:51', modified_user_id='1', created_by='1', title=null, department=null, phone_home=null, phone_mobile=null, phone_work=null, phone_other=null, phone_fax=null, status='Active', address_street=null, address_city=null, address_state=null, address_country=null, address_postalcode=null, user_preferences=null, deleted='0', portal_only='0', employee_status='Active', messenger_id=null, messenger_type=null, is_group='0'::MySQL error 1364: Field 'j4s_user' doesn't have a default value

Any ideas why this is happening??

[kinshibuya]

Hi!
have u made any modifications to this table? or is it fresh install?

[tron90]

It's not a fresh install, I just found out that today they added a schedule backup to the MySQL database.

I am guessing that has something to do with the error.

[tron90]

Any ideas??

I've been stuck with this all day long...
thx