Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
associationamber Posted December 23, 2022 Posted December 23, 2022 Hi! I add to the user a new right. And here is the error. I attach a screenshot
Nathan Explosion Posted December 23, 2022 Posted December 23, 2022 Pretty much what it says...the data you are attempting to save in mgroup_others (column for secondary groups) is too long for the column. That column's length is 245 in the schema.json: Does the member really need to be in that many secondary groups?
associationamber Posted December 23, 2022 Author Posted December 23, 2022 3 minutes ago, Nathan Explosion said: Does the member really need to be in that many secondary groups? Yes. These are all the courses and classes that the user has taken.
associationamber Posted December 23, 2022 Author Posted December 23, 2022 and in reality this user has only 62 secondary groups
Nathan Explosion Posted December 23, 2022 Posted December 23, 2022 (edited) 15 minutes ago, associationamber said: and in reality this user has only 62 secondary groups With 3 characters per group ID, plus 61 commas = more than the length of the column... Just pointing out the reason for the error. Ask Invision nicely to change the length. Edited December 23, 2022 by Nathan Explosion
Solution Marc Posted December 27, 2022 Solution Posted December 27, 2022 Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release. SeNioR- and associationamber 2
associationamber Posted January 18, 2023 Author Posted January 18, 2023 Hi! I have the same problem again : I add to the user a new right. And here is the error. I attach a screenshot
Mark H Posted January 18, 2023 Posted January 18, 2023 That's the same issue, which is not yet fixed. As my colleague noted, this will be addressed in a future release (most likely the next one). associationamber 1
associationamber Posted January 18, 2023 Author Posted January 18, 2023 Thanks. There was an update last week. And I thought it was fixed in him.
Jim M Posted January 18, 2023 Posted January 18, 2023 33 minutes ago, associationamber said: Thanks. There was an update last week. And I thought it was fixed in him. No. You can check our release notes for updates of when your bug fix is included in a release. It isn't always the next release, I'm afraid. associationamber 1
associationamber Posted April 14, 2023 Author Posted April 14, 2023 On 1/18/2023 at 7:26 PM, Jim M said: No. You can check our release notes for updates of when your bug fix is included in a release. It isn't always the next release, I'm afraid. Hi! My error is still unresolved. Are there any difficulties with its solution?
Marc Posted April 14, 2023 Posted April 14, 2023 39 minutes ago, associationamber said: Hi! My error is still unresolved. Are there any difficulties with its solution? Not so much difficulty, as there being multiple ways around resolving the issue. However we do have to bear in mind that we have this issue showing at present with only 1 person (yourself), so while the issue is valid, and we do have a bug report open for it, we have to bear in mind the majority of our clients on this, and ensure any fixes do not affect other areas. Groups of course affect every area of the suite, and the vast majority of people will not have over 62 groups. It's a very individual and unusual use case
associationamber Posted April 14, 2023 Author Posted April 14, 2023 (edited) Users study at our school and take various courses, electives. Each course has a separate section. A new user group is created for each course. I can't delete a section of a course that a user has taken before. Because in the course section there are materials that the user can return to at any time. + There is also a problem in the section - online users. The problem has the same cause. Full error code: INSERT INTO `core_sessions` ( `id`, `member_name`, `seo_name`, `member_id`, `ip_address`, `browser`, `running_time`, `login_type`, `member_group`, `current_appcomponent`, `current_module`, `current_controller`, `current_id`, `uagent_key`, `uagent_version`, `uagent_type`, `search_thread_id`, `search_thread_time`, `data`, `location_url`, `location_lang`, `location_data`, `location_permissions`, `theme_id`, `in_editor` ) VALUES ( 'torn0g2qmjaadgoo9a9t9pdr29', 'Katrin23', 'katrin23', 1086, '91.142.168.32', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36', 1681499241, 0, 4, 'core', 'online', 'online', 0, 'Chrome', '112.0.0.0', 'browser', 0, 0, 'ipsDataLayerEvents|a:0:{}', 'https://atlantida-amber.org/forum/index.php'loc_viewing_online_users'/online/', '[]', '325,203,505,506,507,499,474,476,473,440,460,459,449,445,439,458,444,456,475,447,452,465,463,488,479,455,441,450,448,446,443,453,489,467,371,219,248,392,495,29,17,44,110,184,239,328,457,71,483,466,241,343,427,75,415,107,155,187,224,319,66,401,494,100,141,175,215,310,51,83,387,477,123,151,190,290,39,374,464,89,131,160,196,282,63,22,124,253,397,30,68,136,409,77,147,426,358,425,284,302,262,24,35,52,195,188,180,149,132,198,285,269,231,254,339,326,295,347,413,404,372,370,470,498,81,58,250,240,230,220,205,270,286,297,306,98,133,199,296,320,298,375,382,345,430,419,451,405,25,182,82,233,327,399,454,143,91,4,362,480,503,292,217,364,273,204,406,153,317,189,64,232,436,336,400,490,238,461,221,411,408,344,403,281,373,213,122,331,46,193,158,361,31,11,16,57,90,391,435,118,169,245,309,73,412,484,103,192,266,333,130,43,257,442,183,289,423,194,305,247,497,264,379,294,144,337,237,300,431,369,348,395,340,3,127,47,54,27,106,210,398,307,8,268,321,261,105,45,121,478,40,34,53,99,88,65,356,42,74,85,181,256,346,487,303,376,428,80,96,119,145,214,258,352,212,6,432,407,304,368,438,236,20,86,323,482,209,14,55,28,41,206,272,330,394,492,67,87,108,135,170,208,351,384,429,314,389,437,491,234,259,276,249,313,462,271,277,278,280,279,10,92,161,291,496,242,318,420,140,365,246,355,315,129,226,287,388,211,228,312,481,218,283,359,424,378,115,177,308,402,36,12,377,299,267,363,263,418,417,381,202,342,176,338,56,360,416,502,109,128,156,201,243,288,150,164,174,167,166,49,168,222,225,227,114,501,163,197,255,354,142,23,15,19,157,179,350,472,367,165,486,33,62,50,76,229,311,357,421,94,117,146,186,32,59,48,216,252,332,380,469,79,93,111,134,171,60,322,393,468,84,102,125,154,178,223,275,260,341,433,274,385,191,386,504,301,159,390,353,113,324,13,422,101,139,334,152,61,293,366,434,185,235,69,316,383,471,200,251,78,329,396,485,173,207,265,349,410,500,18,7,9,37,26,95,120,148,104,126,162,112,137,72,335,414,493,116,138,172,244,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530', 5, 0, ? ) ON DUPLICATE KEY UPDATE `id`=VALUES(`id`), `member_name`=VALUES(`member_name`), `seo_name`=VALUES(`seo_name`), `member_id`=VALUES(`member_id`), `ip_address`=VALUES(`ip_address`), `browser`=VALUES(`browser`), `running_time`=VALUES(`running_time`), `login_type`=VALUES(`login_type`), `member_group`=VALUES(`member_group`), `current_appcomponent`=VALUES(`current_appcomponent`), `current_module`=VALUES(`current_module`), `current_controller`=VALUES(`current_controller`), `current_id`=VALUES(`current_id`), `uagent_key`=VALUES(`uagent_key`), `uagent_version`=VALUES(`uagent_version`), `uagent_type`=VALUES(`uagent_type`), `search_thread_id`=VALUES(`search_thread_id`), `search_thread_time`=VALUES(`search_thread_time`), `data`=VALUES(`data`), `location_url`=VALUES(`location_url`), `location_lang`=VALUES(`location_lang`), `location_data`=VALUES(`location_data`), `location_permissions`=VALUES(`location_permissions`), `theme_id`=VALUES(`theme_id`), `in_editor`=VALUES(`in_editor`) IPS\Db\Exception: Data too long for column 'location_permissions' at row 1 (1406) #0 /var/www/atlantida-amber.org/forum/system/Db/Db.php(941): IPS\_Db->preparedQuery() #1 /var/www/atlantida-amber.org/forum/system/Session/Store/Database.php(77): IPS\_Db->insert() #2 /var/www/atlantida-amber.org/forum/system/Session/Front.php(381): IPS\Session\Store\_Database->updateSession() #3 [internal function]: IPS\Session\_Front->write() #4 /var/www/atlantida-amber.org/forum/applications/core/modules/front/online/online.php(45): session_write_close() #5 /var/www/atlantida-amber.org/forum/system/Dispatcher/Controller.php(118): IPS\core\modules\front\online\_online->manage() #6 /var/www/atlantida-amber.org/forum/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 /var/www/atlantida-amber.org/forum/index.php(13): IPS\_Dispatcher->run() #8 {main} ***** The "online users" tab does not work. And I cannot give new rights to users who have completed more than 62 different courses. Edited April 14, 2023 by associationamber
Marc Posted September 6, 2023 Posted September 6, 2023 This issue was resolved in the recently released 4.7.13 release. Please update in order to fix this issue, and if you see any problem after that point, please let us know.
associationamber Posted September 18, 2023 Author Posted September 18, 2023 Hi! Tell me please, where can I increase the number of minor groups.
Jim M Posted September 18, 2023 Posted September 18, 2023 4 minutes ago, associationamber said: Hi! Tell me please, where can I increase the number of minor groups. Sorry, this is not configurable.
Joel R Posted September 19, 2023 Posted September 19, 2023 6 hours ago, associationamber said: Hi! Tell me please, where can I increase the number of minor groups. This is a gentle way of IPS saying that you are using membergroups in an unusual and not recommended manner. Can you help explain why you need to group members in separate groups? 1. When users finish with a course, can you put them into 1 membergroup ("Finished students")? 2. Have you thought about using Clubs, which are ways of grouping users without using permissions?
associationamber Posted September 19, 2023 Author Posted September 19, 2023 3 hours ago, Joel R said: This is a gentle way of IPS saying that you are using membergroups in an unusual and not recommended manner. Can you help explain why you need to group members in separate groups? 1. When users finish with a course, can you put them into 1 membergroup ("Finished students")? 2. Have you thought about using Clubs, which are ways of grouping users without using permissions? Hi! Thanks for the recommendations! I wrote earlier the essence of the situation: On 4/14/2023 at 10:08 PM, associationamber said: Users study at our school and take various courses, electives. Each course has a separate section. A new user group is created for each course. I can't delete a section of a course that a user has taken before. Because in the course section there are materials that the user can return to at any time. + There is also a problem in the section - online users. The problem has the same cause. Full error code: INSERT INTO `core_sessions` ( `id`, `member_name`, `seo_name`, `member_id`, `ip_address`, `browser`, `running_time`, `login_type`, `member_group`, `current_appcomponent`, `current_module`, `current_controller`, `current_id`, `uagent_key`, `uagent_version`, `uagent_type`, `search_thread_id`, `search_thread_time`, `data`, `location_url`, `location_lang`, `location_data`, `location_permissions`, `theme_id`, `in_editor` ) VALUES ( 'torn0g2qmjaadgoo9a9t9pdr29', 'Katrin23', 'katrin23', 1086, '91.142.168.32', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36', 1681499241, 0, 4, 'core', 'online', 'online', 0, 'Chrome', '112.0.0.0', 'browser', 0, 0, 'ipsDataLayerEvents|a:0:{}', 'https://atlantida-amber.org/forum/index.php'loc_viewing_online_users'/online/', '[]', '325,203,505,506,507,499,474,476,473,440,460,459,449,445,439,458,444,456,475,447,452,465,463,488,479,455,441,450,448,446,443,453,489,467,371,219,248,392,495,29,17,44,110,184,239,328,457,71,483,466,241,343,427,75,415,107,155,187,224,319,66,401,494,100,141,175,215,310,51,83,387,477,123,151,190,290,39,374,464,89,131,160,196,282,63,22,124,253,397,30,68,136,409,77,147,426,358,425,284,302,262,24,35,52,195,188,180,149,132,198,285,269,231,254,339,326,295,347,413,404,372,370,470,498,81,58,250,240,230,220,205,270,286,297,306,98,133,199,296,320,298,375,382,345,430,419,451,405,25,182,82,233,327,399,454,143,91,4,362,480,503,292,217,364,273,204,406,153,317,189,64,232,436,336,400,490,238,461,221,411,408,344,403,281,373,213,122,331,46,193,158,361,31,11,16,57,90,391,435,118,169,245,309,73,412,484,103,192,266,333,130,43,257,442,183,289,423,194,305,247,497,264,379,294,144,337,237,300,431,369,348,395,340,3,127,47,54,27,106,210,398,307,8,268,321,261,105,45,121,478,40,34,53,99,88,65,356,42,74,85,181,256,346,487,303,376,428,80,96,119,145,214,258,352,212,6,432,407,304,368,438,236,20,86,323,482,209,14,55,28,41,206,272,330,394,492,67,87,108,135,170,208,351,384,429,314,389,437,491,234,259,276,249,313,462,271,277,278,280,279,10,92,161,291,496,242,318,420,140,365,246,355,315,129,226,287,388,211,228,312,481,218,283,359,424,378,115,177,308,402,36,12,377,299,267,363,263,418,417,381,202,342,176,338,56,360,416,502,109,128,156,201,243,288,150,164,174,167,166,49,168,222,225,227,114,501,163,197,255,354,142,23,15,19,157,179,350,472,367,165,486,33,62,50,76,229,311,357,421,94,117,146,186,32,59,48,216,252,332,380,469,79,93,111,134,171,60,322,393,468,84,102,125,154,178,223,275,260,341,433,274,385,191,386,504,301,159,390,353,113,324,13,422,101,139,334,152,61,293,366,434,185,235,69,316,383,471,200,251,78,329,396,485,173,207,265,349,410,500,18,7,9,37,26,95,120,148,104,126,162,112,137,72,335,414,493,116,138,172,244,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530', 5, 0, ? ) ON DUPLICATE KEY UPDATE `id`=VALUES(`id`), `member_name`=VALUES(`member_name`), `seo_name`=VALUES(`seo_name`), `member_id`=VALUES(`member_id`), `ip_address`=VALUES(`ip_address`), `browser`=VALUES(`browser`), `running_time`=VALUES(`running_time`), `login_type`=VALUES(`login_type`), `member_group`=VALUES(`member_group`), `current_appcomponent`=VALUES(`current_appcomponent`), `current_module`=VALUES(`current_module`), `current_controller`=VALUES(`current_controller`), `current_id`=VALUES(`current_id`), `uagent_key`=VALUES(`uagent_key`), `uagent_version`=VALUES(`uagent_version`), `uagent_type`=VALUES(`uagent_type`), `search_thread_id`=VALUES(`search_thread_id`), `search_thread_time`=VALUES(`search_thread_time`), `data`=VALUES(`data`), `location_url`=VALUES(`location_url`), `location_lang`=VALUES(`location_lang`), `location_data`=VALUES(`location_data`), `location_permissions`=VALUES(`location_permissions`), `theme_id`=VALUES(`theme_id`), `in_editor`=VALUES(`in_editor`) IPS\Db\Exception: Data too long for column 'location_permissions' at row 1 (1406) #0 /var/www/atlantida-amber.org/forum/system/Db/Db.php(941): IPS\_Db->preparedQuery() #1 /var/www/atlantida-amber.org/forum/system/Session/Store/Database.php(77): IPS\_Db->insert() #2 /var/www/atlantida-amber.org/forum/system/Session/Front.php(381): IPS\Session\Store\_Database->updateSession() #3 [internal function]: IPS\Session\_Front->write() #4 /var/www/atlantida-amber.org/forum/applications/core/modules/front/online/online.php(45): session_write_close() #5 /var/www/atlantida-amber.org/forum/system/Dispatcher/Controller.php(118): IPS\core\modules\front\online\_online->manage() #6 /var/www/atlantida-amber.org/forum/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 /var/www/atlantida-amber.org/forum/index.php(13): IPS\_Dispatcher->run() #8 {main} ***** The "online users" tab does not work. And I cannot give new rights to users who have completed more than 62 different courses.
Daniel F Posted September 19, 2023 Posted September 19, 2023 Why won't clubs work for you? This would be an easy way to avoid having that many groups.
associationamber Posted September 19, 2023 Author Posted September 19, 2023 24 minutes ago, Daniel F said: Why won't clubs work for you? This would be an easy way to avoid having that many groups. Each new group is given unique information based on the group's request. It is important for us that each group has access to information specifically for their course. We cannot unite all students.
teraßyte Posted September 19, 2023 Posted September 19, 2023 (edited) You can create a new (private) club for each course, and add the members to that club. The specific information you mention can be added to the club itself, and only its members will be able to see it. There is no need for all members to join all clubs (unite). The only problem I can see is re-creating the groups as clubs and manually moving all members into them. If you have a lot of members/groups (as seen in the screenshot above), a custom modification to automatically move the members might be a good idea. Edited September 19, 2023 by teraßyte ArashDev and Daniel F 2
Daniel F Posted September 19, 2023 Posted September 19, 2023 Yea, as @teraßyte said, I would go with clubs. Either private or not, depends on your setup and requirements. associationamber 1
associationamber Posted September 25, 2023 Author Posted September 25, 2023 On 9/19/2023 at 4:16 PM, teraßyte said: The only problem I can see is re-creating the groups as clubs and manually moving all members into them. If you have a lot of members/groups (as seen in the screenshot above), a custom modification to automatically move the members might be a good idea. Hi! Thanks for your help! I have a lot of groups, more 611.
Recommended Posts