Solved Column 'xs_moods_id' cannot be null

SyTry

Administrator
Staff member
Administrator
Moderator
Licensed
Joined
Jul 8, 2019
Messages
585
Reaction score
360
Hello,

Here is a bug when you try to create a new user (version 2.0.0) :
  • XF\Db\DuplicateKeyException: MySQL query error [1048]: Column 'xs_moods_id' cannot be null
  • src/XF/Db/AbstractStatement.php:217
Stack trace :
Code:
INSERT  INTO `xf_user` (`visible`, `activity_visible`, `user_group_id`, `timezone`, `language_id`, `username`, `email`, `secondary_group_ids`, `user_state`, `is_staff`, `custom_title`, `message_count`, `reaction_score`, `trophy_points`, `style_id`, `display_style_group_id`, `secret_key`, `user_id`, `permission_combination_id`, `alerts_unread`, `conversations_unread`, `register_date`, `last_activity`, `avatar_date`, `avatar_width`, `avatar_height`, `avatar_highdpi`, `gravatar`, `is_moderator`, `is_admin`, `is_banned`, `warning_points`, `privacy_policy_accepted`, `terms_accepted`, `xs_moods_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1048, '23000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1048, '23000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(221): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_user', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Mvc/FormAction.php(69): XF\Mvc\Entity\Entity->save(true, false)
#7 src/XF/Mvc/FormAction.php(187): XF\Mvc\FormAction->XF\Mvc\{closure}(Object(XF\Mvc\FormAction))
#8 src/XF/Admin/Controller/User.php(504): XF\Mvc\FormAction->run()
#9 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\User->actionSave(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:User', 'Save', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\User), NULL)
#11 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\User), NULL)
#12 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#14 src/XF.php(390): XF\App->run()
#15 admin.php(13): XF::runApp('XF\\Admin\\App')
#16 {main}

Request state :
Code:
array(4) {
  ["url"] => string(23) "/admin.php?users/0/save"
  ["referrer"] => string(47) "https://demo.xen-soluce.com/admin.php?users/add"
  ["_GET"] => array(1) {
    ["users/0/save"] => string(0) ""
  }
  ["_POST"] => array(13) {
    ["user"] => array(13) {
      ["username"] => string(4) "Demo"
      ["email"] => string(0) ""
      ["user_group_id"] => string(1) "2"
      ["user_state"] => string(5) "valid"
      ["custom_title"] => string(0) ""
      ["message_count"] => string(1) "0"
      ["reaction_score"] => string(1) "0"
      ["trophy_points"] => string(1) "0"
      ["style_id"] => string(1) "0"
      ["language_id"] => string(1) "1"
      ["timezone"] => string(13) "Europe/London"
      ["visible"] => string(1) "1"
      ["activity_visible"] => string(1) "1"
    }
    ["password"] => string(8) "********"
    ["dob_month"] => string(1) "0"
    ["dob_day"] => string(0) ""
    ["dob_year"] => string(0) ""
    ["profile"] => array(4) {
      ["location"] => string(0) ""
      ["website"] => string(0) ""
      ["about"] => string(0) ""
      ["signature"] => string(0) ""
    }
    ["custom_fields"] => array(3) {
      ["skype"] => string(0) ""
      ["facebook"] => string(0) ""
      ["twitter"] => string(0) ""
    }
    ["option"] => array(5) {
      ["content_show_signature"] => string(1) "1"
      ["email_on_conversation"] => string(1) "1"
      ["creation_watch_state"] => string(11) "watch_email"
      ["interaction_watch_state"] => string(11) "watch_email"
      ["show_dob_date"] => string(1) "1"
    }
    ["privacy"] => array(5) {
      ["allow_view_profile"] => string(8) "everyone"
      ["allow_post_profile"] => string(7) "members"
      ["allow_receive_news_feed"] => string(8) "everyone"
      ["allow_send_personal_conversation"] => string(7) "members"
      ["allow_view_identities"] => string(8) "everyone"
    }
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(20) "/admin.php?users/add"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

Regards, SyTry
 
Hello,

Fixed in the next update, 2.0.0 Fix 1 version. (y)

Regards, SyTry
 
Top Bottom