XF 1.4 Problem adding secondary user groups

[Alexander Firth]

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?

 

[Paul B]

Open the browser console and check the error message.

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

 

[Alexander Firth]

Open the browser console and check the error message.

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

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

 

[Paul B]

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.

 

[Alexander Firth]

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.

Thanks, you're always on hand to answer questions within 2 minutes, I love it

 

[Main Company]

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) "

"
["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"
}
}

 

[Paul B]

Is the member really in~90 user groups?

You are likely exceeding the field size in the database.

 

[Main Company]

Is the member really in~90 user groups?

You are likely exceeding the field size in the database.

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

 

[Paul B]

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

 

[Main Company]

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

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?

 

[Paul B]

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/

 

[Main Company]

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.

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

 

[Paul B]

Yes, if they are all private nodes.

 

[Main Company]

Great. Thanks. This will simplify things for me.

 

[Main Company]

Yes, if they are all private nodes.

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.