Not a bug XF\Db\Exception: MySQL query error [1364]: Field 'ap_ss_ignored_user_style' doesn't have a default value src/XF/Db/AbstractStatement.php

[HomieHunter]

Affected version

2.2.9

Please help to solve it, sir
This problem occurs when registering a new member.
- I have also removed several add-ons to solve the problem.
but it doesn't work at all.

I also checked on the server side, my hosting,
no problem at all.

please solve the problem

Stack trace​

INSERT INTO xf_user_profile (user_id, location, password_date, dob_day, dob_month, dob_year, signature, website, following, ignored, avatar_crop_x, avatar_crop_y, banner_date, banner_position_y, about, custom_fields, connected_accounts, view_count) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1364, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1364, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1514): XF\Db\AbstractAdapter->insert('xf_user_profile', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1246): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Mvc/Entity/Entity.php(1264): XF\Mvc\Entity\Entity->save(true, false)
#7 src/XF/Service/User/Registration.php(301): XF\Mvc\Entity\Entity->save()
#8 src/XF/Service/ValidateAndSavableTrait.php(42): XF\Service\User\Registration->_save()
#9 src/XF/Pub/Controller/Register.php(426): XF\Service\User\Registration->save()
#10 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#12 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Register), NULL)
#13 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2352): XF\Mvc\Dispatcher->run()
#15 src/XF.php(524): XF\App->run()
#16 index.php(20): XF::runApp('XF\\Pub\\App')
#17 {main}

Request state
array(4) {
["url"] => string(28) "/index.php?register/register"
["referrer"] => string(37) "https://osintx.pw/index.php?register/"
["_GET"] => array(1) {
["register/register"] => string(0) ""
}
["_POST"] => array(13) {
["_xfToken"] => string(8) "********"
["username"] => string(0) ""
["9c0dc7b52847662ade87b599c4fd34c1d44bb7c8"] => string(7) "Drakens"
["04799f25b69a17a80d76c1ca16c6c4eead0d81ce"] => string(27) "breachedsociety75@gmail.com"
["79c32f2c4c91afe19950d5c79e8a2279e4509b6f"] => string(8) "********"
["g-recaptcha-response"] => string(1750) "P1_eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.hadwYXNza2V5xQSu6HzFcltX7KyW7U5IkJ6j3Qeedh9GnT3DibuPRYnnFCEv0cvPgQi9bhVaKOtjkIC-sepMNY-IBOb34FVPj-fqtTsXhmRjuuF7mQKXznaEvubDpCvVtqlDiyDhE6cACnyFrdWXxxfS9qWW8or6RxPO8B2S4udZtEH9WEru8OUjWq3_SMXSMIheuyeuVlZpLG5ilUtLMJb3IzrMmTnUBO_lexmaiq08lRY5ZcLpcCR1lGF4wvSbILvPL3yehbmVguuVMip405JsPlHtzvE3foUHiCnacsgNGWskyCIP79havSrIx-3jsaHZxuaBvn_Qv9k4qcuEolATiEBIlzi9z94--SJMXaqZkLdQ8-6L0rCwtXgoqf5LMyYrRlBSGN89HUPLFNMlNterASCHdTxWEiahaQkWIdAWaiBNs2QiwyYJQ4THqSyuLnAp8i_FEzTSSa60ZW4ytpNR_BlE4EINQ-naoD4Okc8fOiXbTzYSWnfMbkh7M1mcQjeE9vZeIele7Q4SZfLn5bdzttimcg4V3tqUGgh2_1RA30zyu0OVbXSeEVu68CLWW9AKrjdRkyY3vV4aB3JENlOR6v0feFZS2UqTTI7SuhyPlqFyBGWMWbdxl9QuFpKjWSofBjpamI540A-QTTiw-2ubzHjjN3U6Ov6BUiiAKFz4Mkz-QSrCI7NEAXB5Nft7yuyhd2J2-j1o-qAPzs1lGYiTetaGq_HxadtPNcnBbOIn8hQfaHZwoi7LFXElMES1VMN1hcttF0F3nkit-I3GwK5cAzlEO_ULB_WxkeghecNCP35KbMve0gXRPJat3WKguulyaGfQymdanvL74gk_I_44EVdSV1DSqS9HOx8BoG3fUIYsgNWLh627RBwR15py2tKBFNe71o3E1X4SNXsTSndPWsxRwaFiiRbrhbPEJG16zQ7xRM9x2MN9TkPZlRgVqHsZ_k3qqrlldoIYf0fpG4tXLeGR7FNW0nNgaPcyzSJF5qWHqVIKOdBI1dVUJCe0qT-HwZld0rrrdWXprck6u592JoVuAAk9BEfZCxr5V3nvkpr2WKDy4K7k8GIz36zl2kwhPD9W8JGbQjcqYTsallmzEdlN4ztnG3q5gMczR4PTX5LMmOLYT9K6OC-c65bPh-yj8_dwEXz0_4YTvdW5aNlOWPkiSVgg159aCuKK725gfZpgDa2f7jvs-LAKzf7nwVNOoerNwlzb4GM_uWpKyp6FcgvImIia8XQs7DUnUoOXMMehnemUAOKqi8McF20l8vbatWL0Ato-_24KWtk7_ttXxKNcneNVNLRyq_nhDGD-HRSRmOVRc8_pBoNms3sfYjc3Vz17pyw6DiLLTAKtcIlFin0UPNNhPD6G0u6FqUe37r226vesD16I-rikiB1e-UtHv-3ZvQPnIWuH74s1lzFx53-1MLCOkfX_gM2RT6rwL7V2D2BE8wYbSD-P4ziCfkJrEH60sc2M2FrY-F7IPrf3qUdVcvJUAN5lOJ8BiOuV6x96T_qfsWBow754Nb2KO-LfjuQJ-ZtJVSaNJpDY314HWGJG95rHuF8JWWdvSXoaiPiE9LpkAHb6avwsLf7UpqZUO2xVzHoec6NleHDOZk1zy6hzaGFyZF9pZM4PcupvomtyqDNhYjI4MzE2onBkAA.Gm4RnStyKhG3KY05p627QbpGqdksgBPIijYsT1rghq0"
["h-captcha-response"] => string(1750) "P1_eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.hadwYXNza2V5xQSu6HzFcltX7KyW7U5IkJ6j3Qeedh9GnT3DibuPRYnnFCEv0cvPgQi9bhVaKOtjkIC-sepMNY-IBOb34FVPj-fqtTsXhmRjuuF7mQKXznaEvubDpCvVtqlDiyDhE6cACnyFrdWXxxfS9qWW8or6RxPO8B2S4udZtEH9WEru8OUjWq3_SMXSMIheuyeuVlZpLG5ilUtLMJb3IzrMmTnUBO_lexmaiq08lRY5ZcLpcCR1lGF4wvSbILvPL3yehbmVguuVMip405JsPlHtzvE3foUHiCnacsgNGWskyCIP79havSrIx-3jsaHZxuaBvn_Qv9k4qcuEolATiEBIlzi9z94--SJMXaqZkLdQ8-6L0rCwtXgoqf5LMyYrRlBSGN89HUPLFNMlNterASCHdTxWEiahaQkWIdAWaiBNs2QiwyYJQ4THqSyuLnAp8i_FEzTSSa60ZW4ytpNR_BlE4EINQ-naoD4Okc8fOiXbTzYSWnfMbkh7M1mcQjeE9vZeIele7Q4SZfLn5bdzttimcg4V3tqUGgh2_1RA30zyu0OVbXSeEVu68CLWW9AKrjdRkyY3vV4aB3JENlOR6v0feFZS2UqTTI7SuhyPlqFyBGWMWbdxl9QuFpKjWSofBjpamI540A-QTTiw-2ubzHjjN3U6Ov6BUiiAKFz4Mkz-QSrCI7NEAXB5Nft7yuyhd2J2-j1o-qAPzs1lGYiTetaGq_HxadtPNcnBbOIn8hQfaHZwoi7LFXElMES1VMN1hcttF0F3nkit-I3GwK5cAzlEO_ULB_WxkeghecNCP35KbMve0gXRPJat3WKguulyaGfQymdanvL74gk_I_44EVdSV1DSqS9HOx8BoG3fUIYsgNWLh627RBwR15py2tKBFNe71o3E1X4SNXsTSndPWsxRwaFiiRbrhbPEJG16zQ7xRM9x2MN9TkPZlRgVqHsZ_k3qqrlldoIYf0fpG4tXLeGR7FNW0nNgaPcyzSJF5qWHqVIKOdBI1dVUJCe0qT-HwZld0rrrdWXprck6u592JoVuAAk9BEfZCxr5V3nvkpr2WKDy4K7k8GIz36zl2kwhPD9W8JGbQjcqYTsallmzEdlN4ztnG3q5gMczR4PTX5LMmOLYT9K6OC-c65bPh-yj8_dwEXz0_4YTvdW5aNlOWPkiSVgg159aCuKK725gfZpgDa2f7jvs-LAKzf7nwVNOoerNwlzb4GM_uWpKyp6FcgvImIia8XQs7DUnUoOXMMehnemUAOKqi8McF20l8vbatWL0Ato-_24KWtk7_ttXxKNcneNVNLRyq_nhDGD-HRSRmOVRc8_pBoNms3sfYjc3Vz17pyw6DiLLTAKtcIlFin0UPNNhPD6G0u6FqUe37r226vesD16I-rikiB1e-UtHv-3ZvQPnIWuH74s1lzFx53-1MLCOkfX_gM2RT6rwL7V2D2BE8wYbSD-P4ziCfkJrEH60sc2M2FrY-F7IPrf3qUdVcvJUAN5lOJ8BiOuV6x96T_qfsWBow754Nb2KO-LfjuQJ-ZtJVSaNJpDY314HWGJG95rHuF8JWWdvSXoaiPiE9LpkAHb6avwsLf7UpqZUO2xVzHoec6NleHDOZk1zy6hzaGFyZF9pZM4PcupvomtyqDNhYjI4MzE2onBkAA.Gm4RnStyKhG3KY05p627QbpGqdksgBPIijYsT1rghq0"
["accept"] => string(1) "1"
["reg_key"] => string(16) "2sxAZQee3XhXEIRJ"
["c4f276d76403cd9817c5f8e1d44f873da1132651"] => string(14) "Asia/Hong_Kong"
["_xfRequestUri"] => string(20) "/index.php?register/"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

 

[Jeremy P]

If you require support, associate your forum user name with your customer account and post in the relevant forum.