Online users

[associationamber]

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

[CodePixel]

Can you paste full error here?

[associationamber]

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}

[CodePixel]

Which version of Community Suite are you using?

[associationamber]

3 minutes ago, CodePixel.dev said:

Which version of Community Suite are you using?

Invision Community 4.7.8 

[CodePixel]

Did you add lately any plugin or app? If so, try disabling it and see if that helps.

[associationamber]

No, didn't add

[Miss_B]

This looks to be related to this:

https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html

What was the latest change/modification done to the forum prior to this happening?

[Daniel F]

The amount of available member groups is causing the issue. I have logged a bug for this. 

[Marc Stridgen]

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.