XF 1.5 Server Error when users attempt to register

[Yusareba]

Unregistered users are receiving server errors when attempting to register. When going to ACP>tools>server error logs it is flooded with the following:



the error expanded is:

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'brapp_relationship_user' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, 16 minutes ago
Stack Trace
#0 /home2/yusareba/public_html/gameguardian.gg/forum/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home2/yusareba/public_html/gameguardian.gg/forum/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home2/yusareba/public_html/gameguardian.gg/forum/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home2/yusareba/public_html/gameguardian.gg/forum/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
#4 /home2/yusareba/public_html/gameguardian.gg/forum/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
#5 /home2/yusareba/public_html/gameguardian.gg/forum/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
#6 /home2/yusareba/public_html/gameguardian.gg/forum/library/XenForo/ControllerPublic/Register.php(416): XenForo_DataWriter->save()
#7 /home2/yusareba/public_html/gameguardian.gg/forum/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Register->actionRegister()
#8 /home2/yusareba/public_html/gameguardian.gg/forum/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home2/yusareba/public_html/gameguardian.gg/forum/index.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
  ["url"] => string(56) "http://gameguardian.gg/forum/index.php?register/register"
  ["_GET"] => array(1) {
    ["register/register"] => string(0) ""
  }
  ["_POST"] => array(14) {
    ["username"] => string(0) ""
    ["559cc03682ac26934b92d31f580dd743"] => string(12) "yusarebanned"
    ["f8bbba1a7b62de6a38ecdb32322abc59"] => string(0) ""
    ["d940350ecc543cd375d971fa4e1db975"] => string(17) "yusareba@mail.com"
    ["2023623d5999e44f3cf597a99ede86df"] => string(0) ""
    ["dob_month"] => string(1) "3"
    ["dob_day"] => string(2) "19"
    ["dob_year"] => string(4) "1992"
    ["e5bc5cc67915294dee79c51c6080212c"] => string(15) "America/Chicago"
    ["recaptcha_challenge_field"] => string(292) "03AHJ_VutUQIqycv0B4lieuGz6zvB2_0h9Zj4G469W3u9w2e4Y0Ib1UsqgG7Umgbx5L334FmviZ43GF5i2UZNS9NOz21yWPMRUG4h0fA2KLbu5z2QNPFa2emLf9auS1XrTaPrcun59I0MPQXrM7UruzpzckKwL1kWLFN8HNlTsoWwEU5K0lROCFWyq_oJgbA1et9qXLK37iAHkmqiW-fjhw_1nlURreXCQklD6mpPmwB9Dpxc9bB7myoXHj2UbGwtacWBgbewAupvImvoi1_k1JqKoapEKU_LA9w"
    ["recaptcha_response_field"] => string(3) "926"
    ["agree"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["reg_key"] => string(32) "33b5f7a5984a07c2168d648205900cf8"
  }
}

------------------------------------------------------------------------------------------------------------------------------------

Sorry for the inefficient posting of the error. Does anyone have any advice for me? :\

 

[Yusareba]

I honestly believe it has something to do with an add-on that I attempted to use earlier today. I was attempting to understand user groups and utilized this:

https://xenforo.com/community/resources/icewind-clone-user-group.2887/

however at the bottom, I was taught that I didn't need the addon at that this would suffice:

https://xenforo.com/community/resources/implementing-permissions-across-multiple-user-groups.358/

----------------------------------------------------

Original conversation is located here:

https://xenforo.com/community/threads/user-permissions-conflict.120558/#post-1095947


TL;DR: I jumped the gun and installed an add-on that I didn't need and it effectively made the user registration process explode on itself. Solution?
Fortunately this a brand new forum, with only two members (Myself included), so If I need to wipe out and replace a parent folder somewhere, It wouldn't be a loss.

 

[Paul B]

Looks to be an issue with an add-on (is it disabled?) - possibly "brapp" or a conflict with another add-on.

You would need to contact the developer of the "brapp" add-on for support in the first instance.

 

[Yusareba]

Interesting. I believe you're right. It seems to be working again after enabling ALL add-ons. Now to determine which one is causing the error and what to do to avoid it. Thank you.

 

[Paul B]

Disable them one at a time until the error reoccurs - that will help you identify it.

The problem is due to an incorrect database setting for the field- the author can resolve it very easily.