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

XF 1.4 Problem adding secondary user groups

Discussion in 'Troubleshooting and Problems' started by Alexander Firth, Dec 31, 2014.

  1. Alexander Firth

    Alexander Firth Active Member

    I'm trying to add my admin account to another couple of user groups as additional user groups. This wasn't a problem, but I noticed today I've been removed from these secondary user groups (only I have admin access). I went through the changes list, and it said my secondary user groups were removed on December 23rd, but I did nothing I can remember on this day with regards to add-ons etc. I now get an error when I try to add them back: "The server responded with an error. The error message is in the JavaScript console."

    This only happens for my own personal account. Any ideas?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Open the browser console and check the error message.

    That may provide an indication as to what is causing it.
     
  3. Alexander Firth

    Alexander Firth Active Member

    PHP
    Fatal error: Zend_Uri::factory(): Failed opening required 'Zend/Loader.php' (include_path='/var/www/vhosts/youthdebates.org/httpdocs/forums/library/Nobita/Schedule/src:.') in /var/www/vhosts/youthdebates.org/httpdocs/forums/library/Zend/Uri.php on line 135

    Nobita would mean an add-on, but I only installed that add-on today and apparently I was removed from the user groups a week ago. Confusing :(
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    You will need to post in the add-on thread for support with that.

    I wouldn't be able to comment on why you were removed from the user groups.
    In a default installation that would only happen via a user group promotion and the criteria no longer being met, an account upgrade expiring, or by an administrator.
     
  5. Alexander Firth

    Alexander Firth Active Member

    Thanks, you're always on hand to answer questions within 2 minutes, I love it :p
     
  6. Main Company

    Main Company Active Member

    Data too long for column 'secondary_group_ids'

    I'm going to post a Secondary Group error error I just rec'v'd over the wkend, rather than try to create a new thread. While it's similar, it's different in that I rec'v'd the error when attemptng to save a member update after adding that user to 3-new secondary groups. Here's the server log, with domain and username details removed/changed...

    XenForo 1.4.2

    Server Error Log
    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'secondary_group_ids' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: admin, Friday at 5:27 PM
    Stack Trace
    #0 /var/www/xenforo/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/xenforo/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /var/www/xenforo/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_user...', Array)
    #3 /var/www/xenforo/library/XenForo/DataWriter.php(1640): Zend_Db_Adapter_Abstract->update('xf_user', Array, 'user_id = 2')
    #4 /var/www/xenforo/library/XenForo/DataWriter.php(1609): XenForo_DataWriter->_update()
    #5 /var/www/xenforo/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save()
    #6 /var/www/xenforo/library/XenForo/ControllerAdmin/User.php(513): XenForo_DataWriter->save()
    #7 /var/www/xenforo/library/XenForo/FrontController.php(347): XenForo_ControllerAdmin_User->actionSave()
    #8 /var/www/xenforo/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /var/www/xenforo/admin.php(13): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
    ["url"] => string(63) "https://discuss.forumdomain.com/admin.php?users/username.2/save"
    ["_GET"] => array(1) {
    ["users/username_2/save"] => string(0) ""
    }
    ["_POST"] => array(45) {
    ["username"] => string(6) "username"
    ["email"] => string(39) "adminuser@forumdomain.com"
    ["password"] => string(8) "********"
    ["user_group_id"] => string(1) "2"
    ["secondary_group_ids"] => array(88) {
    [0] => string(1) "3"
    [1] => string(2) "21"
    [2] => string(2) "45"
    [3] => string(2) "24"
    [4] => string(2) "25"
    [5] => string(2) "61"
    [6] => string(2) "23"
    [7] => string(2) "22"
    [8] => string(2) "53"
    [9] => string(2) "29"
    [10] => string(2) "47"
    [11] => string(2) "46"
    [12] => string(2) "18"
    [13] => string(2) "35"
    [14] => string(2) "36"
    [15] => string(2) "37"
    [16] => string(2) "38"
    [17] => string(1) "4"
    [18] => string(2) "55"
    [19] => string(2) "56"
    [20] => string(2) "57"
    [21] => string(2) "54"
    [22] => string(2) "28"
    [23] => string(2) "20"
    [24] => string(2) "15"
    [25] => string(2) "32"
    [26] => string(2) "31"
    [27] => string(2) "17"
    [28] => string(1) "5"
    [29] => string(2) "67"
    [30] => string(2) "16"
    [31] => string(2) "80"
    [32] => string(2) "12"
    [33] => string(2) "11"
    [34] => string(2) "33"
    [35] => string(2) "34"
    [36] => string(1) "6"
    [37] => string(2) "27"
    [38] => string(2) "39"
    [39] => string(2) "13"
    [40] => string(2) "50"
    [41] => string(2) "51"
    [42] => string(2) "60"
    [43] => string(2) "62"
    [44] => string(1) "7"
    [45] => string(2) "48"
    [46] => string(2) "78"
    [47] => string(2) "79"
    [48] => string(2) "81"
    [49] => string(2) "84"
    [50] => string(2) "82"
    [51] => string(2) "65"
    [52] => string(2) "64"
    [53] => string(2) "40"
    [54] => string(2) "90"
    [55] => string(2) "92"
    [56] => string(2) "91"
    [57] => string(2) "87"
    [58] => string(2) "59"
    [59] => string(2) "83"
    [60] => string(2) "69"
    [61] => string(2) "52"
    [62] => string(2) "73"
    [63] => string(2) "93"
    [64] => string(2) "94"
    [65] => string(2) "63"
    [66] => string(2) "71"
    [67] => string(2) "74"
    [68] => string(2) "88"
    [69] => string(2) "89"
    [70] => string(2) "85"
    [71] => string(2) "86"
    [72] => string(2) "66"
    [73] => string(2) "68"
    [74] => string(2) "77"
    [75] => string(2) "75"
    [76] => string(1) "8"
    [77] => string(2) "41"
    [78] => string(1) "9"
    [79] => string(2) "42"
    [80] => string(2) "76"
    [81] => string(2) "10"
    [82] => string(2) "43"
    [83] => string(2) "58"
    [84] => string(2) "72"
    [85] => string(2) "14"
    [86] => string(2) "49"
    [87] => string(2) "44"
    }
    ["user_state"] => string(5) "valid"
    ["gender"] => string(4) "male"
    ["dob_month"] => string(0) ""
    ["dob_day"] => string(0) ""
    ["dob_year"] => string(0) ""
    ["location"] => string(0) ""
    ["occupation"] => string(0) ""
    ["homepage"] => string(0) ""
    ["about"] => string(9) "blah blah"
    ["custom_title"] => string(7) "none"
    ["signature"] => string(64) "[​IMG]"
    ["message_count"] => string(4) "6075"
    ["like_count"] => string(3) "333"
    ["trophy_points"] => string(1) "0"
    ["custom_fields"] => array(11) {
    ["phone"] => string(0) ""
    ["mobile"] => string(0) ""
    ["fax"] => string(0) ""
    ["gplus"] => string(0) ""
    ["address"] => string(0) ""
    ["aim"] => string(0) ""
    ["icq"] => string(0) ""
    ["yahoo"] => string(0) ""
    ["skype"] => string(0) ""
    ["facebook"] => string(0) ""
    ["twitter"] => string(0) ""
    }
    ["custom_fields_shown"] => array(11) {
    [0] => string(5) "phone"
    [1] => string(6) "mobile"
    [2] => string(3) "fax"
    [3] => string(5) "gplus"
    [4] => string(7) "address"
    [5] => string(3) "aim"
    [6] => string(3) "icq"
    [7] => string(5) "yahoo"
    [8] => string(5) "skype"
    [9] => string(8) "facebook"
    [10] => string(7) "twitter"
    }
    ["style_id"] => string(1) "2"
    ["language_id"] => string(1) "1"
    ["timezone"] => string(19) "America/Los_Angeles"
    ["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"
    ["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(30) "/admin.php?users/username.2/edit"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
    }
    }
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    Is the member really in~90 user groups?

    You are likely exceeding the field size in the database.
     
  8. Main Company

    Main Company Active Member

    Yes.

    Virtually all of our Nodes are Private, as this is how we control access. But this user has access to ALL of them (they are the only one).
     
  9. Brogan

    Brogan XenForo Moderator Staff Member

    Why not just create a single user group which has access to all private nodes and add them to that?
     
  10. Main Company

    Main Company Active Member

    Do i just create a new group with permissions set to view nodes (as in attached image), then add this user to this secondary group?

    2nd_permissions.jpg
     
  11. Brogan

    Brogan XenForo Moderator Staff Member

    Yes, create the new user group and set the permissions for that group for each private node as required, mirroring what is set for each node specific user group.

    Then add the member to it, and remove them from all of the other user groups.

    If there are permissions already set in the Registered user group, such as "View member lists", you can leave those as Not Set (No).

    This resource explains how to set up cumulative permissions: http://xenforo.com/community/resources/implementing-permissions-across-multiple-user-groups.358/
     
  12. Main Company

    Main Company Active Member

    So, just to be clear, this means going thru all 90 nodes and adding this secondary group to each?
     
  13. Brogan

    Brogan XenForo Moderator Staff Member

    Yes, if they are all private nodes.
     
  14. Main Company

    Main Company Active Member

    Great. Thanks. This will simplify things for me.
     
  15. Main Company

    Main Company Active Member

    I am finally getting to this now, and I just realized that I also must update my settings in ForumWatch Add-on.

    You see, I currently have 1-group mapped to each private node in ForumWatch. This way, when I add a user to a group, they not only get access to that private node, but they also are certain to get all new messages and new threads posted in that private node. It makes it really easy for me to add new users and control their access and notifications.

    But now, if I have to create a master group, which 1-group is given "viewership" credentials to numererous private nodes, then I also must map this master group to the same private nodes in ForumWatch.

    Just an FYI.
     

Share This Page