XF 2.2 Server error registering

[Brad P]

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) "********"
}
}

 

[Brad P]

I've disabled recaptcha see if that was the cause but it's still saying the above.

 

[Ozzy47]

What’s the actual error?

 

[Brad P]

What’s the actual error?

Hi @Ozzy47
This what I get when trying to sign up.

 

[Ozzy47]

And what is the error? You only posted part of the stack trace and request state.

 

[Brad P]

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"
  }
}

 

[Ozzy47]

I’ve no idea what j_p_extras is. Have you tried with all addons disabled?

 

[Brad P]

I’ve no idea what j_p_extras is. Have you tried with all addons disabled?

Yeah I've disabled all add-ons and still the the same error.

 

[Ozzy47]

Okay, what about custom user fields?

 

[Brad P]

Found the issue @Ozzy47 it was an add-on that was currently disabled causing it, I've enabled it and sent message to the developer thank you for the help

 

[Ozzy47]

Odd, but glad you found the addon causing the issue.

 

[Brad P]

j_p_extras

Indeed it's this one causing it. Annoying it's been like this for about a month I did wonder why no body was singing up for quite some time.

 

[Paul B]

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.