XF 2.2 server error for signing up

Brad P

Well-known member
1612642055639.png

Code:
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"
  }
 
Last edited:

Brad P

Well-known member
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
 
Last edited:
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 :)
 
Top