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 1 hour ago, ToeJam said: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?36 minutes ago, ToeJam said: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 57 minutes ago, Adlago said: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 1 hour ago, ToeJam said: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? 1 hour ago, ToeJam said: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 14 minutes ago, ToeJam said: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 1 hour ago, ToeJam said: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 2Mar 2 1 hour ago, ToeJam said:I'll let my hoster know, hopefully it helpsLet us know how it will go.
March 3Mar 3 Author 19 hours ago, Miss_B said: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!