Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
charlie@e-epos.com Posted August 4, 2022 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
Management Matt Posted August 4, 2022 Management 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 1
charlie@e-epos.com Posted August 4, 2022 Author Posted August 4, 2022 Im thinking an older upgrade gone wrong perhaps? Is there a way to recreate SQL tables
UncrownedGuard Posted August 4, 2022 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.
Mark H Posted August 4, 2022 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.
Recommended Posts