Tarun Posted June 15, 2016 Share Posted June 15, 2016 I just updated to the latest version of the forum software and ran the utf8mb4 converter. Upon looking through my database I noticed a lot of tables did not converted. I suspect that they're no longer used though I'd like to verify that they're not core IPS tables before removing them. I have three plugins installed, see below. The following are all utf8_unicode_ci: (Table name - Number of Rows) bbcode_mediatag - 9 conf_settings - 362 conf_settings_titles - 88 contactform_antispam - 3 contactform_customfields - 0 core_archive_log - 19 core_archive_restore - 1 core_hooks_files - 32 core_inline_messages - 0 core_like_cache - 4,172 core_rss_imported - 0 core_sys_login - 2 core_sys_settings_titles - 44 custom_bbcode - 41 installed_mods - 8 rc_reports_index - 5 reg_antispam - 0 sfs_blocked - 7,570 sfs_settings - 1 sfs_tracking - 4 sfs_whitelist - 0 subscriptions - 0 subscription_currency - 4 subscription_extra - 0 subscription_logs - 0 subscription_methods - 6 subscription_trans - 0 I think that contactform was from a modification I used back in the early 3.x series. I know I used SFS with 3.4.x. I believe subscriptions have gone away also but used to be a part of IPS. The plugins I have installed are: Group Name Indicator Enabled Donate Sidebar Enabled Who Was Online I'm also going to put a test forum on just to double compare what is and is not there to see what I can remove. Thanks in advance everyone. Link to comment Share on other sites More sharing options...
Tarun Posted June 15, 2016 Author Share Posted June 15, 2016 So I did a clean install on a test forum and copied all the database table names. After that, I installed the three plugins I use just to compare. They didn't add any new database tables which helped me see that the ones I posted are leftovers. For those interested, here is a list of a clean install database tables: calendar_calendars calendar_events calendar_event_comments calendar_event_reviews calendar_event_rsvp calendar_import_feeds calendar_import_map chat_log_archive core_acp_search_index core_acp_tab_order core_acronyms core_admin_login_logs core_admin_logs core_admin_permission_rows core_advertisements core_announcements core_api_keys core_api_logs core_applications core_attachments core_attachments_map core_banfilters core_bulk_mail core_cache core_dev core_dnames_change core_edit_history core_email_templates core_emoticons core_error_logs core_files core_files_temp core_file_logs core_file_storage core_follow core_geoip_cache core_groups core_hooks core_ignored_users core_image_proxy core_incoming_emails core_ipsconnect_queue core_ipsconnect_slaves core_item_markers core_javascript core_leaders core_leaders_groups core_log core_login_handlers core_mail_error_logs core_members core_members_warn_actions core_members_warn_logs core_members_warn_reasons core_member_ranks core_member_status_replies core_member_status_updates core_menu core_message_posts core_message_topics core_message_topic_user_map core_moderators core_moderator_logs core_modules core_notifications core_notification_defaults core_notification_preferences core_permission_index core_pfields_content core_pfields_data core_pfields_groups core_plugins core_polls core_profanity_filters core_question_and_answer core_queue core_ratings core_rc_comments core_rc_index core_rc_reports core_reputation_index core_reputation_levels core_search_index core_search_index_tags core_seo_meta core_sessions core_share_links core_sitemap core_soft_delete_log core_spam_service_log core_store core_streams core_sys_conf_settings core_sys_cp_sessions core_sys_lang core_sys_lang_words core_sys_social_groups core_sys_social_group_members core_tags core_tags_cache core_tags_perms core_tasks core_tasks_log core_themes core_theme_conflict core_theme_content_history core_theme_css core_theme_resources core_theme_settings_fields core_theme_settings_values core_theme_templates core_upgrade_history core_validating core_view_updates core_voters core_widgets core_widget_areas core_widget_trash forums_answer_ratings forums_archive_posts forums_archive_rules forums_forums forums_posts forums_question_ratings forums_rss_import forums_rss_imported forums_topics forums_topic_mmod Took a database backup before trying anything also. Dropped all the tables that I posted in my first post and so far so good. Hope this helps some people who may need it! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.