XF 2.2server error for signing up

Well-known member

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')
#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:

nicodak

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

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:

CypherForums

Member
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

Replies
7
Views
94
Replies
6
Views
306
Replies
0
Views
139
Replies
1
Views
250
Replies
3
Views
214