emin.huseynov Posted August 9, 2022 Share Posted August 9, 2022 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} Link to comment Share on other sites More sharing options...
emin.huseynov Posted August 9, 2022 Author Share Posted August 9, 2022 (edited) 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, 2022 by emin.huseynov Link to comment Share on other sites More sharing options...
Marc Posted August 9, 2022 Share Posted August 9, 2022 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 Link to comment Share on other sites More sharing options...
emin.huseynov Posted August 9, 2022 Author Share Posted August 9, 2022 the db is restored, but the errors won't go away apparently upgrade worked half way? Link to comment Share on other sites More sharing options...
Marc Posted August 9, 2022 Share Posted August 9, 2022 You need to revert both files and database back to its working state Link to comment Share on other sites More sharing options...
Recommended Posts