Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted March 2Mar 2 Just had this error pop up on my site, not sure if this is the only problem but can't see a login window but can get into the Admin ACP[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.]What do I do to fix this theme issue?Thanks
March 2Mar 2 Author I guess maybe it's beyond a theme issue perhaps, when I go to the look at members this pops upSELECT reply_id, reply_title, reply_added_by, reply_enabled, core_permission_index.perm_id, core_permission_index.perm_view FROM ibf_core_editor_stored_replies AS core_editor_stored_replies LEFT JOIN ibf_core_permission_index AS core_permission_index ON core_permission_index.app='core' AND core_permission_index.perm_type='editorStoredReplies' AND core_permission_index.perm_type_id=core_editor_stored_replies.reply_idIPS\Db\Exception: Unknown storage engine 'InnoDB' (1286)#0 /home/thesig5/public_html/forums/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*thesig5_invis...', Array, true)#1 /home/thesig5/public_html/forums/system/Db/Select.php(286): IPS\Db\_Select->runQuery()#2 /home/thesig5/public_html/forums/applications/core/sources/StoredReplies/StoredReplies.php(223): IPS\Db\_Select->setKeyField('reply_id')#3 /home/thesig5/public_html/forums/system/Helpers/Form/Editor.php(126): IPS\core\_StoredReplies::getStore()#4 /home/thesig5/public_html/forums/system/CustomField/CustomField.php(845): IPS\Helpers\Form\_Editor->__construct('core_pfield_25', NULL, 0, Array, NULL, NULL, NULL, 'core_pfield_25_...')#5 /home/thesig5/public_html/forums/applications/core/sources/ProfileFields/Field.php(297): IPS\_CustomField->buildHelper(NULL)#6 /home/thesig5/public_html/forums/applications/core/modules/admin/members/members.php(155): IPS\core\ProfileFields\_Field::fields(Array, 2)#7 /home/thesig5/public_html/forums/system/Dispatcher/Controller.php(118): IPS\core\modules\admin\members\_members->manage()#8 /home/thesig5/public_html/forums/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()#9 /home/thesig5/public_html/forums/admin/index.php(13): IPS\_Dispatcher->run()#10 {main}Also, ran a database check and can't seem to repair these files that say corrupt[thesig5_invision.ibf_core_solved_index] Unknown storage engine 'InnoDB'[thesig5_invision.ibf_core_solved_index] Corrupt[thesig5_invision.ibf_core_s3_deletions] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_s3_deletions] Corrupt [thesig5_invision.ibf_core_rss_import] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_rss_import] Corrupt [thesig5_invision.ibf_core_rss_imported] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_rss_imported] Corrupt [thesig5_invision.ibf_core_members_logins] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_members_logins] Corrupt [thesig5_invision.ibf_core_member_recognize] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_member_recognize] Corrupt [thesig5_invision.ibf_core_item_member_map] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_item_member_map] Corrupt [thesig5_invision.ibf_core_item_redirect] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_item_redirect] Corrupt [thesig5_invision.ibf_core_item_statistics_cache] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_item_statistics_cache] Corrupt [thesig5_invision.ibf_core_follow_count_cache] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_follow_count_cache] Corrupt [thesig5_invision.ibf_core_editor_stored_replies] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_editor_stored_replies] Corrupt [thesig5_invision.ibf_core_content_featured] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_content_featured] Corrupt [thesig5_invision.ibf_core_alerts_seen] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_alerts_seen] Corrupt [thesig5_invision.ibf_core_achievements_log_milestones] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_achievements_log_milestones] Corrupt [thesig5_invision.ibf_communitymap_comments] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_communitymap_comments] Corrupt [thesig5_invision.ibf_communitymap_customfields] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_communitymap_customfields] Corrupt [thesig5_invision.ibf_communitymap_markers] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_communitymap_markers] Corrupt [thesig5_invision.ibf_communitymap_markers_groups] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_communitymap_markers_groups] Corrupt [thesig5_invision.ibf_communitymap_member_groups] OK [thesig5_invision.ibf_communitymap_members] OK [thesig5_invision.ibf_communitymap_reviews] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_communitymap_reviews] Corrupt Edited March 2Mar 2 by ToeJam
March 2Mar 2 If this is in version 4.x - open your theme for editing - edit html, find the user bar template and restore it to default.
March 2Mar 2 Community Expert Just had this error pop up on my site, not sure if this is the only problem but can't see a login window but can get into the Admin ACPWhat was the latest change done to the forum prior to this happening? thesig5_invision.ibf_core_s3_deletions] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_s3_deletions] CorruptThis error indicates a corruption of the database. Do you manage your own Vps/Dedicated box? If you do, then removing the ib_* log files in mysql data dir will fixed the issue. If you are on a shared hosting plan you will have to contact your host so they can fix this for you.
March 2Mar 2 Author If this is in version 4.x - open your theme for editing - edit html, find the user bar template and restore it to default.I'm having issues at this point of trying to get into the admin acp login Just had this error pop up on my site, not sure if this is the only problem but can't see a login window but can get into the Admin ACPWhat was the latest change done to the forum prior to this happening? thesig5_invision.ibf_core_s3_deletions] Unknown storage engine 'InnoDB' [thesig5_invision.ibf_core_s3_deletions] CorruptThis error indicates a corruption of the database. Do you manage your own Vps/Dedicated box? If you do, then removing the ib_* log files in mysql data dir will fixed the issue. If you are on a shared hosting plan you will have to contact your host so they can fix this for you.I'm on a VSP through a hosting company, and from another site I have on the account the cache folder filled and it needed to get emptied. The diskspace I had fille dup and it froze my email and my websites.Once I freed up space I noticed the error on the site.I'll let my hoster know, hopefully it helpsthanks all!
March 2Mar 2 I'm having issues at this point of trying to get into the admin acp loginIf you have a default theme IPS in your installation, try opening your database table core_themes and changing the column "set_key" to the default for that theme.Clear your browser's cookies and cache and try loading your site. It should load with the default theme.
March 2Mar 2 Community Expert Unknown storage engine 'InnoDB'Your MySQL server doesn’t support InnoDB. You need to contact your hosting provider or server admin to fix this.
March 3Mar 3 Author Let us know how it will go.My issue got resolved, thank you all.My hosting company said "They can try to force a innoDB recovery at level one", they had to go to level 2 to resolve it.So I'm back up and good.Thanks again!