1. 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

Discussion in 'Troubleshooting and Problems' started by Maxxamillion, Aug 3, 2014.

  1. Maxxamillion

    Maxxamillion Active Member

    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"
      }
    }
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    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.
     
  3. Maxxamillion

    Maxxamillion Active Member

    could i not just uninstall the add on to fix the issue?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    If you don't use it, yes.
     
  5. whynot

    whynot Well-Known Member

    #1 Disable it
    #2 Contact the developer as Brogan advised it.
     
  6. Maxxamillion

    Maxxamillion Active Member

    seems odd though as the add on was already disabled, ill uninstall see if that helps
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    The fact it is disabled is what is causing the error.
    It is due to an incorrect setting for the column in the database.
     
  8. Maxxamillion

    Maxxamillion Active Member

    gotach thanks brogan you are mr helpful as always. Ive uninstalled it works fine now... solved
     

Share This Page