associationamber Posted March 27 Share Posted March 27 HI! I click on the "online users" tab and an error is displayed. Link to comment Share on other sites More sharing options...
CodePixel Posted March 27 Share Posted March 27 Can you paste full error here? associationamber 1 Link to comment Share on other sites More sharing options...
associationamber Posted March 27 Author Share Posted March 27 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...
CodePixel Posted March 27 Share Posted March 27 Which version of Community Suite are you using? Link to comment Share on other sites More sharing options...
associationamber Posted March 27 Author Share Posted March 27 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...
CodePixel Posted March 27 Share Posted March 27 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 Author Share Posted March 27 No, didn't add Link to comment Share on other sites More sharing options...
Miss_B Posted March 27 Share Posted March 27 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 Share Posted March 27 The amount of available member groups is causing the issue. I have logged a bug for this. SeNioR- and associationamber 2 Link to comment Share on other sites More sharing options...
Recommended Posts