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

XF 1.5 Can not create User anymore

Discussion in 'Troubleshooting and Problems' started by Freelancer, Jan 28, 2016.

  1. Freelancer

    Freelancer Well-Known Member

    Okay with 42 add-ons now this does not come as a real surprise but unexpected.

    I can not create any user in the ACP anymore. The following error is displayed NO MATTER what name, password I use... It looks like the form is not processed and the error is the same as if you leave all fields empty.

    xf_create_user_error.jpg

    As per SOP I THEN DEACTIVATED ALL ADD-ONS and when I try to create a user with everything deactivated, I get the following Server Error:

    Code:
    erver Error Log
    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'useress_tags' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: XXXXXXXXXXXXXX, 6 minutes ago
    Stack Trace
    #0 /var/www/clients/client180/web812/web/library/Zend/Db/Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/clients/client180/web812/web/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /var/www/clients/client180/web812/web/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /var/www/clients/client180/web812/web/library/XenForo/DataWriter.php(1638): Zend_Db_Adapter_Abstract->insert('xf_user', Array)
    #4 /var/www/clients/client180/web812/web/library/XenForo/DataWriter.php(1627): XenForo_DataWriter->_insert()
    #5 /var/www/clients/client180/web812/web/library/XenForo/DataWriter.php(1419): XenForo_DataWriter->_save()
    #6 /var/www/clients/client180/web812/web/library/XenForo/ControllerAdmin/User.php(513): XenForo_DataWriter->save()
    #7 /var/www/clients/client180/web812/web/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_User->actionSave()
    #8 /var/www/clients/client180/web812/web/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /var/www/clients/client180/web812/web/admin.php(13): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
      ["url"] => string(54) "https://www.xxxxxxxxxxxxxxxx.com/admin.php?users/0/save"
      ["_GET"] => array(1) {
        ["users/0/save"] => string(0) ""
      }
      ["_POST"] => array(45) {
        ["username"] => string(11) "NewTestUser"
        ["email"] => string(0) ""
        ["password"] => string(8) "********"
        ["user_group_id"] => string(1) "2"
        ["user_state"] => string(5) "valid"
        ["gender"] => string(0) ""
        ["dob_month"] => string(0) ""
        ["dob_day"] => string(0) ""
        ["dob_year"] => string(0) ""
        ["location"] => string(0) ""
        ["occupation"] => string(0) ""
        ["homepage"] => string(0) ""
        ["custom_fields"] => array(8) {
          ["FavoriteGun"] => string(0) ""
          ["aim"] => string(0) ""
          ["icq"] => string(0) ""
          ["yahoo"] => string(0) ""
          ["skype"] => string(0) ""
          ["gtalk"] => string(0) ""
          ["facebook"] => string(0) ""
          ["twitter"] => string(0) ""
        }
        ["custom_fields_shown"] => array(8) {
          [0] => string(11) "CustomField"
          [1] => string(3) "aim"
          [2] => string(3) "icq"
          [3] => string(5) "yahoo"
          [4] => string(5) "skype"
          [5] => string(5) "gtalk"
          [6] => string(8) "facebook"
          [7] => string(7) "twitter"
        }
        ["about"] => string(0) ""
        ["custom_title"] => string(0) ""
        ["signature"] => string(0) ""
        ["message_count"] => string(1) "0"
        ["like_count"] => string(1) "0"
        ["trophy_points"] => string(1) "0"
        ["style_id"] => string(1) "0"
        ["language_id"] => string(1) "6"
        ["timezone"] => string(16) "Europe/Amsterdam"
        ["enable_rte"] => string(1) "1"
        ["enable_flash_uploader"] => string(1) "1"
        ["content_show_signature"] => string(1) "1"
        ["email_on_conversation"] => string(1) "1"
        ["default_watch_state"] => string(11) "watch_email"
        ["visible"] => string(1) "1"
        ["activity_visible"] => string(1) "1"
        ["receive_admin_email"] => string(1) "1"
        ["allow_view_profile_enable"] => string(1) "1"
        ["allow_view_profile"] => string(7) "members"
        ["allow_post_profile_enable"] => string(1) "1"
        ["allow_post_profile"] => string(7) "members"
        ["allow_receive_news_feed_enable"] => string(1) "1"
        ["allow_receive_news_feed"] => string(7) "members"
        ["allow_send_personal_conversation_enable"] => string(1) "1"
        ["allow_send_personal_conversation"] => string(7) "members"
        ["allow_view_identities_enable"] => string(1) "1"
        ["allow_view_identities"] => string(7) "members"
        ["_xfToken"] => string(8) "********"
        ["_xfRequestUri"] => string(20) "/admin.php?users/add"
        ["_xfNoRedirect"] => string(1) "1"
        ["_xfResponseType"] => string(4) "json"
      }
    }
    
    Because I recognized the reference to @Daniel Hood 's "User Essentials" add-on I switched that add-on back to enabled and bingo, the user can be created just as expected.

    My logic says now, that UserEss is conflicting with other add-ons, but is the origin of the problem, because it generates server errors even if switched OFF....

    Right?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    The problem is with the add-on; you will need to post in the add-0n thread for support.

    It is specifically related to when the add-on is disabled due to an incorrect setting for the database schema.
     
    Freelancer likes this.
  3. Freelancer

    Freelancer Well-Known Member

    Thank you Brogan for analyzing that. Could you please merge this post into the UserEss discussion thread? If not possible I will post it there again.

    Edit: Thread can be deleted.
     
    Last edited: Jan 28, 2016
  4. Freelancer

    Freelancer Well-Known Member

    Update: After testing, I can say that this is caused by one specific add-on only (not even a conflict).
     

Share This Page