Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted August 9, 20222 yr Hi I clicked on the proposed update as always. I think it was from 4.7.0 to 4.7.1? Anyway, in the admin page it told me it needs to fix something in db and I proceeded with that. As a result the site is broken. The admin page says: An error occurred (500 Error) We're sorry, but a temporary technical error has occurred which means we cannot display this site right now.Incorrect key file for table 'ibf_core_sys_lang'; try to repair it You can try again by clicking the button below, or try again later. the main page of the forum says: SELECT * FROM `ibf_forums_topics` AS `forums_topics` WHERE `tid`='485524' IPS\Db\Exception: Incorrect key file for table 'ibf_forums_topics'; try to repair it (1034) #0 /home/forum7b/public_html/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*forum7b_16::f...', Array, true) #1 /home/forum7b/public_html/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 /home/forum7b/public_html/system/Db/Select.php(370): IPS\Db\_Select->rewind() #3 /home/forum7b/public_html/system/Patterns/ActiveRecord.php(138): IPS\Db\_Select->first() #4 /home/forum7b/public_html/system/Patterns/ActiveRecord.php(181): IPS\Patterns\_ActiveRecord::load('485524') #5 /home/forum7b/public_html/system/Http/Url/Internal.php(177): IPS\Patterns\_ActiveRecord::loadFromUrl(Object(IPS\Http\Url\Friendly)) #6 /home/forum7b/public_html/system/Http/Url/Friendly.php(218): IPS\Http\Url\_Internal->correctUrlFromVerifyClass('\\IPS\\forums\\Top...') #7 /home/forum7b/public_html/system/Dispatcher/Front.php(303): IPS\Http\Url\_Friendly->correctFriendlyUrl() #8 /home/forum7b/public_html/system/Dispatcher/Front.php(87): IPS\Dispatcher\_Front->checkUrl() #9 /home/forum7b/public_html/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\_Front->init() #10 /home/forum7b/public_html/index.php(13): IPS\_Dispatcher::i() #11 {main} LINK the second fragment above is actually from a topic thread the index page error is this: SELECT forums_topics.tid FROM `ibf_forums_topics` AS `forums_topics` LEFT JOIN `ibf_forums_forums` AS `forums_forums` ON forums_topics.forum_id=forums_forums.id WHERE ( forums_topics.forum_id IN(2,49,65,34,43,63,67,28,29,30,31,4,39,6,7,5,11,72,8,35,10,70,13,44,45,46,47,48,26,12,14,15,16,36,21) ) AND forums_topics.state='open' AND forums_topics.approved=1 AND forums_topics.approved!=-2 AND forums_topics.approved!=-3 AND ( NULLIF(forums_topics.moved_to, '') IS NULL ) AND forums_forums.can_view_others=1 ORDER BY forums_topics.last_post desc LIMIT 7 IPS\Db\Exception: Incorrect key file for table 'ibf_forums_topics'; try to repair it (1034) #0 /home/forum7b/public_html/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*forum7b_16::f...', Array, true) #1 /home/forum7b/public_html/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 [internal function]: IPS\Db\_Select->rewind() #3 /home/forum7b/public_html/system/Content/Item.php(3260): iterator_to_array(Object(IPS\Db\Select)) #4 /home/forum7b/public_html/applications/forums/sources/Topic/Topic.php(310): IPS\Content\_Item::getItemsWithPermission(Array, 'forums_topics.l...', 7, NULL, -1, 256, Object(IPS\Member), false, false, false, false, NULL, false, true, true, true, false) #5 /home/forum7b/public_html/system/Content/Widget.php(476): IPS\forums\_Topic::getItemsWithPermission(Array, 'forums_topics.l...', 7, NULL, -1, 256) #6 /home/forum7b/public_html/system/Widget/Widget.php(833): IPS\Content\_Widget->render() #7 /home/forum7b/public_html/system/Widget/Widget.php(888): IPS\_Widget->_render() #8 /home/forum7b/public_html/uploads/template_5_94a9d7649fb9cdbfc784d3516e61a717_global.php(18295): IPS\_Widget->__toString() #9 /home/forum7b/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\Cache\class_core_front_global->widgetContainer('sidebar', 'vertical') #10 /home/forum7b/public_html/uploads/template_5_94a9d7649fb9cdbfc784d3516e61a717_global.php(15536): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array) #11 /home/forum7b/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\Cache\class_core_front_global->sidebar('right') #12 /home/forum7b/public_html/uploads/template_5_94a9d7649fb9cdbfc784d3516e61a717_global.php(6766): IPS\Theme\_SandboxedTemplate->__call('sidebar', Array) #13 /home/forum7b/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\Cache\class_core_front_global->globalTemplate('Bakililar.az \xD0\x90...', '\n\n<div class='i...', Array) #14 /home/forum7b/public_html/system/Dispatcher/Dispatcher.php(173): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array) #15 /home/forum7b/public_html/system/Dispatcher/Standard.php(113): IPS\_Dispatcher->finish() #16 /home/forum7b/public_html/system/Dispatcher/Front.php(625): IPS\Dispatcher\_Standard->finish() #17 /home/forum7b/public_html/init.php(927) : eval()'d code(57): IPS\Dispatcher\_Front->finish() #18 /home/forum7b/public_html/system/Dispatcher/Dispatcher.php(155): IPS\Dispatcher\chat_hook_tabNewWindow->finish() #19 /home/forum7b/public_html/index.php(13): IPS\_Dispatcher->run() #20 {main}
August 9, 20222 yr Author as we are trying to fix db, the site shows some errors that might be due to partial upgrade? [[Template core/front/global/userBar is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]][[Template core/front/global/mobileNavigationIcon is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]] [[Template core/front/global/navBarItems is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]] [[Template core/front/global/quickSearch is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]] [[Template core/front/global/mobileNavBar is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]] [[Template core/front/global/breadcrumb is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]] when trying to go into admin page: [[Template core/admin/global/globalTemplate is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]] Edited August 9, 20222 yr by emin.huseynov
August 9, 20222 yr This was an issue on your database itself (crashed tables) which is not something that can be caused by the software itself. I would suggest reverting to your backup and re-running the upgrade, as something has certainly gone wrong on your database server during this process
August 9, 20222 yr Author the db is restored, but the errors won't go away apparently upgrade worked half way?