Jump to content

Recommended Posts

Posted (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 by Nathan Explosion
  • Solution
Posted

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.

 

  • 3 weeks later...
Posted
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.

  • 2 months later...
Posted
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?

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

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
  • 4 months later...
Posted

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.

  • 2 weeks later...
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? 

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.

 

 

 

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

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

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...