Posted August 4, 20222 yr Hi, Our Forum site is completely down - Looking for any pointers ... Can we just Install the Current Version over the top to fix for example ... Any help to get the system back up would be appreciated. Sample of error is below: SELECT count FROM `core_follow_count_cache` WHERE class='IPS\forums\Forum' and id=9 IPS\Db\Exception: Table 'eepos_forums.core_follow_count_cache' doesn't exist (1146) #0 /home/eepos/public_html/forum/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*eepos_forums:...', Array, true) #1 /home/eepos/public_html/forum/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 /home/eepos/public_html/forum/system/Db/Select.php(370): IPS\Db\_Select->rewind() #3 /home/eepos/public_html/forum/system/Patterns/ActiveRecord.php(609): IPS\Db\_Select->first() #4 /home/eepos/public_html/forum/system/Patterns/ActiveRecord.php(761): IPS\Patterns\_ActiveRecord::_followers('forum', 9, 3, Array, NULL, NULL, NULL, true) #5 /home/eepos/public_html/forum/system/Content/Item.php(8051): IPS\Patterns\_ActiveRecord::_followersCount('forum', 9, 3, Array, NULL) #6 /home/eepos/public_html/forum/system/Theme/Theme.php(4495) : eval()'d code(48): IPS\Content\_Item::containerFollowerCount(Object(IPS\forums\Forum)) #7 /home/eepos/public_html/forum/system/Theme/Dev/Template.php(171): IPS\Theme\theme_forums_front_forums_forumDisplay(Object(IPS\forums\Forum), '\n<div class='ip...') #8 /home/eepos/public_html/forum/applications/forums/modules/front/forums/forums.php(421): IPS\Theme\Dev\_Template->__call('forumDisplay', Array) #9 /home/eepos/public_html/forum/applications/forums/modules/front/forums/forums.php(38): IPS\forums\modules\front\forums\_fo
August 4, 20222 yr Community Expert Management It looks like you are experiencing a MySQL problem. Get in touch with your host and see if they are aware of any issues. A missing table is not a good sign, so it's worth investigating the cause of that.
August 4, 20222 yr Author Im thinking an older upgrade gone wrong perhaps? Is there a way to recreate SQL tables
August 4, 20222 yr 5 minutes ago, charlie@e-epos.com said: Im thinking an older upgrade gone wrong perhaps? Is there a way to recreate SQL tables If the table is lost, deleted, or corrupt then restoring from a backup is about the only option to restore the tables with the data in them.
August 4, 20222 yr There is no effective way to recreate a database table with its data still intact. The only recommended and safe way to restore, is to restore the entire backup.