associationamber

@teraßyte Thank you very much!

Hi! Thanks for your help! I have a lot of groups, more 611.

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.

Hi! Thanks for the recommendations! I wrote earlier the essence of the situation:

Hi! Tell me please, where can I increase the number of minor groups.

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.

Hi! My error is still unresolved. Are there any difficulties with its solution?

No, didn't add

Invision Community 4.7.8

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 ( '7oghh3kdpemlumomlgukq0rsjl', 'Katrin23', 'katrin23', 1086, '91.142.167.48', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36', 1679927537, 0, 4, 'core', 'online', 'online', 0, 'Chrome', '111.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}

HI! I click on the "online users" tab and an error is displayed.

I created a new group again. And the error didn't show up. If it repeats, I will write to you.

i create a New Group

Hello! I have a problem again. When I create a new user group, an error is displayed:

Thanks. There was an update last week. And I thought it was fixed in him.