Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
March 27, 20232 yr Author 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}
March 27, 20232 yr Author 3 minutes ago, CodePixel.dev said: Which version of Community Suite are you using? Invision Community 4.7.8
March 27, 20232 yr Did you add lately any plugin or app? If so, try disabling it and see if that helps.
March 27, 20232 yr Community Expert 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?
March 27, 20232 yr The amount of available member groups is causing the issue. I have logged a bug for this.
September 6, 20231 yr Community Expert Solution 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.