• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.3 User not able to register error

#1
This is the error i got from someone registering i even spoke to the guys saying it just redirected him to the home screen, any help please.

Code:
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'competition_entries' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, 6 minutes ago
Stack Trace
#0 /home/celebcra/public_html/destinychat.com/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/celebcra/public_html/destinychat.com/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/celebcra/public_html/destinychat.com/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/celebcra/public_html/destinychat.com/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
#4 /home/celebcra/public_html/destinychat.com/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert()
#5 /home/celebcra/public_html/destinychat.com/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save()
#6 /home/celebcra/public_html/destinychat.com/library/XenForo/ControllerPublic/Register.php(281): XenForo_DataWriter->save()
#7 /home/celebcra/public_html/destinychat.com/library/Waindigo/JoinUserGroup/Extend/XenForo/ControllerPublic/Register.php(45): XenForo_ControllerPublic_Register->actionRegister()
#8 /home/celebcra/public_html/destinychat.com/library/Tac/FoolBotHoneyPot/ControllerPublic/Register.php(762): Waindigo_JoinUserGroup_Extend_XenForo_ControllerPublic_Register->actionRegister()
#9 /home/celebcra/public_html/destinychat.com/library/XenForo/FrontController.php(347): Tac_FoolBotHoneyPot_ControllerPublic_Register->actionRegister()
#10 /home/celebcra/public_html/destinychat.com/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /home/celebcra/public_html/destinychat.com/index.php(13): XenForo_FrontController->run()
#12 {main}
Request State
array(3) {
  ["url"] => string(44) "http://www.destinychat.com/register/register"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(40) {
    ["54d5553de0318f3728"] => string(0) ""
    ["b19ac53de03190103f"] => string(0) ""
    ["29afa53de03190c7d0"] => string(0) ""
    ["0679253de03190eedf"] => string(10) "RhysJayFTW"
    ["username"] => string(10) "RhysJayFTW"
    ["bb36753de0318f3b14"] => string(0) ""
    ["6bc5b53de03190b448"] => string(0) ""
    ["2e5f153de03190009e"] => string(0) ""
    ["email"] => string(19) "rhysjay99@gmail.com"
    ["5467153de03190a0c2"] => string(19) "rhysjay99@gmail.com"
    ["password"] => string(8) "********"
    ["password_confirm"] => string(8) "********"
    ["ff95453de03190cbb8"] => string(0) ""
    ["e98b053de03190c003"] => string(0) ""
    ["a410253de0318f3ef7"] => string(0) ""
    ["1b48b53de031902f85"] => string(0) ""
    ["a645553de0319071f8"] => string(8) "darkri99"
    ["d6c9f53de031908956"] => string(8) "darkri99"
    ["6461d53de03190375e"] => string(0) ""
    ["12baa53de031910e34"] => string(0) ""
    ["dob_month"] => int(9)
    ["dob_day"] => int(24)
    ["dob_year"] => int(1995)
    ["4a98e53de03190cfa1"] => string(0) ""
    ["2151753de031903f32"] => string(0) ""
    ["ef51b53de0319027af"] => string(4) "male"
    ["gender"] => string(4) "male"
    ["126c153de03190e711"] => string(0) ""
    ["custom_fields"] => array(2) {
      ["PSN"] => string(11) "RhysJayFTW_"
      ["xbox"] => string(8) "DubZombi"
    }
    ["custom_fields_shown"] => array(2) {
      [0] => string(3) "PSN"
      [1] => string(4) "xbox"
    }
    ["35d0f53de031902b95"] => string(14) "Pacific/Midway"
    ["a469053de0319075da"] => string(14) "Pacific/Midway"
    ["ba61b53de031905e5f"] => string(13) "Europe/London"
    ["timezone"] => string(13) "Europe/London"
    ["8bf9653de03190d389"] => string(14) "Pacific/Midway"
    ["recaptcha_challenge_field"] => string(206) "03AHJ_VusXYCtYoodHWYnf8dfOEOvBSSZUOj-1mYei1mss8zVoWqGFBLGseK6rK4P763PNG_UWNBw0-mJ8YbkpDRX5iBUVeU5gsali_-FTJnkVvha1Nll8bZwTzO1zlm0iXmDt9e95YlzIL-qP_5qLqDVA_E784shj41-PF_p1RwHAbqZ0gupa_iy-bjRnQ2OHNoaMNB0q-hMp"
    ["recaptcha_response_field"] => string(12) "ella kingyqu"
    ["agree"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["reg_key"] => string(32) "34c3772b0c158fc6d21e8e978e36790f"
  }
}
 

Brogan

XenForo moderator
Staff member
#2
This appears to be an error with an add-on related to competitions.

You will need to contact the developer for support and a fix.
 

Brogan

XenForo moderator
Staff member
#7
The fact it is disabled is what is causing the error.
It is due to an incorrect setting for the column in the database.