Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Zaretta Hammond Posted January 25, 2021 Posted January 25, 2021 EX1054 Something went wrong. Please try again. Does anyone have any guidance on how to fix this? TECHNICAL DETAILS EX1054 Something went wrong. Please try again. TECHNICAL DETAILS REPLACE INTO `core_sys_cp_sessions` ( `session_id`, `session_ip_address`, `session_member_name`, `session_member_id`, `session_location`, `session_log_in_time`, `session_running_time`, `session_url`, `session_app_data`, `session_cookie_key` ) VALUES ( '0ae8afa42c3723c4f92bed0b48d59985', '47.224.1.244', 'Guest', 0, 'app=core&module=system&controller=login', 0, 1611598587, IPS\Http\Url\Internal::__set_state(array( 'seoPagination' => NULL, 'base' => 'admin', 'isInternal' => true, 'isFriendly' => false, 'url' => 'https://crebydesign.com/community/admin/''adsess=0ae8afa42c3723c4f92bed0b48d59985&app=core&module=system&controller=login&ref=YXBwPWNvcmUmbW9kdWxlPXN5c3RlbSZjb250cm9sbGVyPWxvZ2luJnJlZj1ZWEJ3UFdOdmNtVW1iVzlrZFd4bFBYTjVjM1JsYlNaamIyNTBjbTlzYkdWeVBXeHZaMmx1Sm5KbFpqMD0=', 'data' => array ( 'scheme' => 'https', 'host' => 'crebydesign.com', 'port' => NULL, 'user' => NULL, 'pass' => NULL, 'path' => '/community/admin/', 'query' => 'adsess=0ae8afa42c3723c4f92bed0b48d59985&app=core&module=system&controller=login&ref=YXBwPWNvcmUmbW9kdWxlPXN5c3RlbSZjb250cm9sbGVyPWxvZ2luJnJlZj1ZWEJ3UFdOdmNtVW1iVzlrZFd4bFBYTjVjM1JsYlNaamIyNTBjbTlzYkdWeVBXeHZaMmx1Sm5KbFpqMD0=', 'fragment' => NULL, ), 'queryString' => array ( 'adsess' => '0ae8afa42c3723c4f92bed0b48d59985', 'app' => 'core', 'module' => 'system', 'controller' => 'login', 'ref' => 'YXBwPWNvcmUmbW9kdWxlPXN5c3RlbSZjb250cm9sbGVyPWxvZ2luJnJlZj1ZWEJ3UFdOdmNtVW1iVzlrZFd4bFBYTjVjM1JsYlNaamIyNTBjbTlzYkdWeVBXeHZaMmx1Sm5KbFpqMD0=', ), 'hiddenQueryString' => array ( ), )), '4d0f9970687c735de2e816f294c6c552', ? ) IPS\Db\Exception: Unknown column 'session_cookie_key' in 'field list' (1054) #0 /home/ready48/crebydesign.com/community/system/Db/Db.php(968): IPS\_Db->preparedQuery('/*IPS\\Session\\_...', Array) #1 /home/ready48/crebydesign.com/community/system/Session/Admin.php(123): IPS\_Db->replace('core_sys_cp_ses...', Array) #2 [internal function]: IPS\Session\_Admin->write('0ae8afa42c3723c...', '') #3 /home/ready48/crebydesign.com/community/system/Session/Session.php(149): session_regenerate_id() #4 /home/ready48/crebydesign.com/community/applications/core/modules/admin/system/login.php(210): IPS\_Session->setMember(Object(IPS\Member)) #5 /home/ready48/crebydesign.com/community/applications/core/modules/admin/system/login.php(99): IPS\core\modules\admin\system\_login->_doLogin(Object(IPS\Member)) #6 /home/ready48/crebydesign.com/community/system/Dispatcher/Controller.php(96): IPS\core\modules\admin\system\_login->manage() #7 /home/ready48/crebydesign.com/community/system/Dispatcher/Dispatcher.php(152): IPS\Dispatcher\_Controller->execute() #8 /home/ready48/crebydesign.com/community/admin/index.php(14): IPS\_Dispatcher->run() #9 {main} These details only show because you are logged in as an administrator. These details only show because you are logged in as an administrator. These details only show because you are logged in as an administrator.
Daniel F Posted January 25, 2021 Posted January 25, 2021 This column was dropped with IPS 4.5.0. Had you any issues while the upgrade to 4.5.x? It seems that some of your files weren't replaced. I would suggest to download a fresh set of files from the client area and then replace your current files with the new set. If the issue still remains, please submit a ticket and we'll take a look.
Zaretta Hammond Posted January 25, 2021 Author Posted January 25, 2021 We had initially done the update but it broke the connection between wordpress and the forums so we restored a backup. It was working fine after the backup restore though initially.
Daniel F Posted January 25, 2021 Posted January 25, 2021 28 minutes ago, Zaretta Hammond said: We had initially done the update but it broke the connection between wordpress and the forums so we restored a backup. It was working fine after the backup restore though initially. Please make sure that then all DB tables were restored successful too! It seems that some or all database tables have a 4.5 state while the 4.4.x files were restored successful
Zaretta Hammond Posted January 26, 2021 Author Posted January 26, 2021 I restored the databases from the day before we did the update and it didn't fix the issue. What other options do we have for fixing this? Is there a way to actually talk to someone from support? I emailed support but they didn't offer any help, just said what I already knew the problem to be.
CoffeeCake Posted January 26, 2021 Posted January 26, 2021 On 1/25/2021 at 1:35 PM, Zaretta Hammond said: Unknown column 'session_cookie_key' in 'field list' (1054) The error message shows that the database schema is not what the code expects it to be. It is trying to write to a column (session_cookie_key) that is not there. This indicates that one or more of the following things is happening: The source code on your site is not correct. Download and replace all of your files on your host with known good copies from the Client Area, or with the versions that existed before the upgrade. The database on your site is the wrong version. Restore from backup. You have some sort of nasty database corruption. Restore from backup.
Recommended Posts