update broke the forum

[emin.huseynov]

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}

[emin.huseynov]

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

[Marc]

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

[emin.huseynov]

the db is restored, but the errors won't go away

apparently upgrade worked half way?

[Marc]

You need to revert both files and database back to its working state