charlie@e-epos.com Posted August 4, 2022 Share Posted August 4, 2022 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 Link to comment Share on other sites More sharing options...
Management Matt Posted August 4, 2022 Management Share Posted August 4, 2022 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. Marc Stridgen 1 Link to comment Share on other sites More sharing options...
charlie@e-epos.com Posted August 4, 2022 Author Share Posted August 4, 2022 Im thinking an older upgrade gone wrong perhaps? Is there a way to recreate SQL tables Link to comment Share on other sites More sharing options...
UncrownedGuard Posted August 4, 2022 Share Posted August 4, 2022 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. Link to comment Share on other sites More sharing options...
Mark H Posted August 4, 2022 Share Posted August 4, 2022 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. Link to comment Share on other sites More sharing options...
Recommended Posts