Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted December 23, 20222 yr Hi! I add to the user a new right. And here is the error. I attach a screenshot
December 23, 20222 yr 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?
December 23, 20222 yr Author 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.
December 23, 20222 yr 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, 20222 yr by Nathan Explosion
December 27, 20222 yr Solution 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.
January 18, 20232 yr Author Hi! I have the same problem again : I add to the user a new right. And here is the error. I attach a screenshot
January 18, 20232 yr 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).
January 18, 20232 yr Author Thanks. There was an update last week. And I thought it was fixed in him.
January 18, 20232 yr 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.
April 14, 20231 yr Author 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?
April 14, 20231 yr 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
April 14, 20231 yr Author 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, 20231 yr by associationamber
September 6, 20231 yr 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.
September 18, 20231 yr 4 minutes ago, associationamber said: Hi! Tell me please, where can I increase the number of minor groups. Sorry, this is not configurable.
September 19, 20231 yr 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?
September 19, 20231 yr Author 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.
September 19, 20231 yr Why won't clubs work for you? This would be an easy way to avoid having that many groups.
September 19, 20231 yr Author 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.
September 19, 20231 yr 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, 20231 yr by teraßyte
September 19, 20231 yr Yea, as @teraßyte said, I would go with clubs. Either private or not, depends on your setup and requirements.
September 25, 20231 yr Author 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.