XF 2.2 server error for signing up

[Brad P]

XF\Db\Exception: MySQL query error [1364]: Field 'ap_frame' doesn't have a default value src/XF/Db/AbstractStatement.php:228
Generated by: Unknown account Feb 6, 2021 at 8:06 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`, `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`) 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(2326): 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(16) {
    ["username"] => string(0) ""
    ["f957a7c1c3666595e52373026d3abc09461a73eb"] => string(3) "Bot"
    ["deb5802a617248a79513ea421fcd70d412cf5923"] => string(19) ""
    ["email"] => string(0) ""
    ["3886def34c60f9cd134cfeedbd9911bf4365b393"] => string(8) "********"
    ["dob_month"] => string(1) "2"
    ["dob_day"] => string(2) "28"
    ["dob_year"] => string(4) "1987"
    ["g-recaptcha-response"] => string(548) "03AGdBq27MuXzWuuIYbMNY7Qhe4Xex3flQIx55haaw6HMCU3d66_QpvhAVHNkKWVmS55YOYRq-JC--in7tBaBLOC7MLkJcKPHC2_RvcN98LJLc8ixSNX-5EIiRIn1_Oc8KNK4QcgtBxee-CSSeS_L_IZB6gQrxdhjoS7jaU4Fy05Of5HHVo78f44iFo5GiYBfhGn6o-uKvoNx6DbXu3pc947537GZTPiTV3AvyG7EC_y2XED1jIh_4nBHYYAND3TqVxc6JqmjogsSwFmwSBzROEia4mc_F5jo5huFr81RauzTfcx0kKJz48o2Zn0t384oCDuOwz1j_mDcbh4szK78629r9bHN0bYcUofPP1Lp8rCkmdhWmwNPt67f0TMf_-61uHMRslPP70XQjyzYWGHtKJ2Dv7K8z1_djumniJUbux8NqG2EEWyFLzXWoP9Tb_JL1xlm3rt9sszNPoNMZzg6kJ11fW87X4P3bNIjcGffpwwTnQc6hAkoIBtsyGcTsrnUgp3933vrjYf_L-_HW_67LEhaIQ61WIiqJww"
    ["accept"] => string(1) "1"
    ["reg_key"] => string(16) "3UD9c1YgjxQs5CB_"
    ["7f9f3c08c4bd4494190f0574d1b8db96368be4cf"] => string(13) "Europe/London"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(1) "/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }

 

[Nicolas FR]

we can see the email adress in attachment and code... you must delete it or blur it.

 

[Brad P]

we can see the email adress in attachment and code... you must delete it or blur it.

Ideally i'd like support than that mate, its a fake account that i am making to product the error above

EDIT: THIS IS NOW FIXED, AN EDIT FROM THE DATABASE FIXED THIS

 

[CypherForums]

Ideally i'd like support than that mate, its a fake account that i am making to product the error above

EDIT: THIS IS NOW FIXED, AN EDIT FROM THE DATABASE FIXED THIS

There is a column , might be generated due to some third party addon installation , and remain after installation as well , or created manually that do not have set default value. set the default value manually then have a look deeply inside