associationamber Posted March 27, 2023 Share Posted March 27, 2023 HI! I click on the "online users" tab and an error is displayed. Link to comment Share on other sites More sharing options...
szalik.dev Posted March 27, 2023 Share Posted March 27, 2023 Can you paste full error here? associationamber 1 Link to comment Share on other sites More sharing options...
associationamber Posted March 27, 2023 Author Share Posted March 27, 2023 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} Link to comment Share on other sites More sharing options...
szalik.dev Posted March 27, 2023 Share Posted March 27, 2023 Which version of Community Suite are you using? Link to comment Share on other sites More sharing options...
associationamber Posted March 27, 2023 Author Share Posted March 27, 2023 3 minutes ago, CodePixel.dev said: Which version of Community Suite are you using? Invision Community 4.7.8 Link to comment Share on other sites More sharing options...
szalik.dev Posted March 27, 2023 Share Posted March 27, 2023 Did you add lately any plugin or app? If so, try disabling it and see if that helps. Link to comment Share on other sites More sharing options...
associationamber Posted March 27, 2023 Author Share Posted March 27, 2023 No, didn't add Link to comment Share on other sites More sharing options...
Miss_B Posted March 27, 2023 Share Posted March 27, 2023 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? Link to comment Share on other sites More sharing options...
Daniel F Posted March 27, 2023 Share Posted March 27, 2023 The amount of available member groups is causing the issue. I have logged a bug for this. associationamber and SeNioR- 2 Link to comment Share on other sites More sharing options...
Solution Marc Posted September 6, 2023 Solution Share Posted September 6, 2023 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. Link to comment Share on other sites More sharing options...
Recommended Posts