XF 2.2 Server error registering

Brad P

Well-known member
Can someone help me, members trying to register are getting errors and can't sign up.

7 src/XF/Service/ValidateAndSavableTrait.php(40): XF\Service\User\Registration->_save()
#8 src/XF/Pub/Controller/Register.php(422): XF\Service\User\Registration->save()
#9 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#11 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#12 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#14 src/XF.php(465): XF\App->run()
#15 index.php(20): XF::runApp('XF\\Pub\\App')
#16 {main}

Request state​

array(4) {
["url"] => string(18) "/register/register"
["referrer"] => string(32) "https://chatbanter.com/register/"
["_GET"] => array(0) {
}
["_POST"] => array(14) {
["username"] => string(0) ""
["8c26977cc501c4b3417f8ca5de98a6616e922975"] => string(10) "user"
["6d7bdcc623fe1e212a8e0212d6a5e3e820579747"] => string(33) "user@use.marksypark.com"
["password"] => string(8) "********"
["7b9065bf399fff795821401e97a2d144e82f2f2d"] => string(8) "********"
["dob_month"] => string(1) "5"
["dob_day"] => string(1) "4"
["dob_year"] => string(4) "1973"
["custom_fields"] => array(1) {
["siropu_referrer"] => string(0) ""
}
["g-recaptcha-response"] => string(548) "03AGdBq24wsaWLTX6lHOQOhv47YZpIACCfMN-rFJsZDqGBeXDdupjXKUPIMsyI9mw4MBGx1NevfcvtunYzkL6KY_IFRB0Y1xZkmI_qdx2YkOwooY7n4azI1nOJ1WHCw6CwYIH0FmmWpiRqdNiI4tV4eFkZF-mdE6qy4l-TMFJmUgADg41x5v4xOPCuovNZTf_uOWG69DdQ3DURKIZnFVRarrkH-94b5-QHeWnawX9jPBR_8XG3vx_JuBoBb2BEIIHp9lWUCkOIews5NV24bKHz71dWIqt90-VGb0j-vBSLXqUeUWMKUAxLFHrYionc2HpeX2I0LwuljAY737WYjKYwzZ0BxOjWJgTAGnvAAQgMWBYXnX27up0rqoqLYXl8mkw7_9N8Wqll4Ha0J69ZHzIOmDNU8JDwXx2iLw9z_jBtYxb7xXOonUQBPy8UlO3VHrRCEdgDzbQv4rxUAE29vqrK4X5KlutTiapMOOYYVROvuehdDIQn9Eq3s2M6807iWNCcincvhPRv1hRrZuTN8MzBm-yxsNEywxUHEw"
["accept"] => string(1) "1"
["reg_key"] => string(16) "AWNDDwy3D8b8ZGw7"
["c9df031373ed5e390bd0fd1a8846f1185683a227"] => string(0) ""
["_xfToken"] => string(8) "********"
}
}
 
Last edited:

Brad P

Well-known member
Code:
Logs
Server error log
 Clear
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
51 minutes ago src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Today at 6:30 PM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Today at 1:28 PM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Today at 1:25 PM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Today at 1:22 PM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Today at 1:18 PM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Today at 11:22 AM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Today at 8:54 AM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Today at 8:33 AM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Today at 2:59 AM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Today at 2:56 AM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Yesterday at 7:18 PM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Yesterday at 7:15 PM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Yesterday at 6:15 PM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Yesterday at 6:15 PM src/XF/Db/AbstractStatement.php:228
MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value
Yesterday at 11:47 AM src/XF/Db/AbstractStatement.php:228
Showing all items
Log out v2.2.2
Forum software by XenForo® © 2010-2020 XenForo Ltd.
Server error log
XF\Db\Exception: MySQL query error [1364]: Field 'j_p_extras' doesn't have a default value src/XF/Db/AbstractStatement.php:228
Generated by: Unknown account Dec 3, 2020 at 6:42 PM
Stack trace
INSERT  INTO `xf_user` (`visible`, `activity_visible`, `user_group_id`, `timezone`, `language_id`, `last_summary_email_date`, `username`, `email`, `user_state`, `privacy_policy_accepted`, `terms_accepted`, `display_style_group_id`, `secondary_group_ids`, `secret_key`, `cmtv_badges_badge_count`, `user_id`, `username_date`, `username_date_visible`, `style_id`, `permission_combination_id`, `message_count`, `question_solution_count`, `alerts_unviewed`, `alerts_unread`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `avatar_date`, `avatar_width`, `avatar_height`, `avatar_highdpi`, `gravatar`, `security_lock`, `is_moderator`, `is_admin`, `is_staff`, `is_banned`, `reaction_score`, `vote_score`, `custom_title`, `warning_points`, `af_moods_mood_id`, `xa_ams_article_count`, `xa_ams_series_count`, `xb_user_name_data`, `xfmg_album_count`, `xfmg_media_count`, `xfmg_media_quota`, `user_disable_id`, `useress_tags`, `grgi_user_group_icons`, `siropu_referrer_id`, `siropu_referral_count`, `siropu_referrer_credit`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1364, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1364, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1510): XF\Db\AbstractAdapter->insert('xf_user', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1242): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Service/User/Registration.php(298): XF\Mvc\Entity\Entity->save()
#7 src/XF/Service/ValidateAndSavableTrait.php(40): XF\Service\User\Registration->_save()
#8 src/XF/Pub/Controller/Register.php(422): XF\Service\User\Registration->save()
#9 src/XF/Mvc/Dispatcher.php(350): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#11 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#12 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#14 src/XF.php(488): XF\App->run()
#15 index.php(20): XF::runApp('XF\\Pub\\App')
#16 {main}
Request state
array(4) {
  ["url"] => string(18) "/register/register"
  ["referrer"] => string(23) "https://chatbanter.com/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(17) {
    ["username"] => string(0) ""
    ["fa9cb41cf35451d3f2880252ad3b98a01615456e"] => string(7) "Testing"
    ["e160727cfb8f46837538ec00ddff057fc257117a"] => string(0) ""
    ["5e4ebb376afd4df5ac8581a1a07a24cf6ae43b9e"] => string(30) "brad.prout@travisperkins.co.uk"
    ["password"] => string(8) "********"
    ["9f9ae3a384a952c735b696b5905de0f34337fb2a"] => string(8) "********"
    ["dob_month"] => string(1) "2"
    ["dob_day"] => string(2) "28"
    ["dob_year"] => string(4) "1987"
    ["custom_fields"] => array(1) {
      ["siropu_referrer"] => string(6) "Brad P"
    }
    ["accept"] => string(1) "1"
    ["reg_key"] => string(16) "4ZezXRRbK1QKc-dX"
    ["564a0efe249f1691a13f67a865537d98d8898351"] => string(13) "Europe/London"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(1) "/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
 

Brogan

XenForo moderator
Staff member
For future reference, any error which involves doesn't have a default value is due to a disabled add-on which has an incorrect database schema setting for that field.

In most cases, enabling the add-on should resolve it, but the add-on author needs to resolve it with an update.
 
Top