Jump to content

EX1406

associationamber

By associationamber
in Technical Problems

 Share
Go to solution Solved by Marc,

Recommended Posts

  • 3 weeks later...
  • 2 months later...
Marc Grand Master

Marc

Posted
Posted
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

Link to comment
Share on other sites
associationamber Explorer

associationamber

Posted
  • Author
Posted (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. Could contain: File, Webpage, Page, Text

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 by associationamber
Link to comment
Share on other sites
  • 4 months later...
  • 2 weeks later...
Joel R Mentor

Joel R

Posted
Posted
6 hours ago, associationamber said:

Hi! 

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

Could contain: Page, Text, File

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? 

Link to comment
Share on other sites
associationamber Explorer

associationamber

Posted
  • Author
Posted
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. Could contain: File, Webpage, Page, Text

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.

 

 

 

Link to comment
Share on other sites
teraßyte Grand Master

teraßyte

Posted
Posted (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 by teraßyte
Link to comment
Share on other sites
associationamber Explorer

associationamber

Posted
  • Author
Posted
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.

Link to comment
Share on other sites
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
Invision Community © 2024 IPS, Inc.
×
×
  • Create New...