Phil7789 Posted October 21, 2017 Posted October 21, 2017 Hey, does anybody know or can tell me what tables the database for IPS 4.x uses? I've upgraded from 3.x to 4.x when it was released and still have some orphaned tables (including some plugins I do not use anymore). After having problems with converting my database from utf8 to utf8mb4, because the system still threw the information that those changes should be made, I changed some tables manually, which kept utf8. Know all checks run fine, but I am not sure if I could drop those tables I changed as they're perhaps not needed anymore. Is there anybody who could provide me a list of the "standard tables" you have with a clean 4.x installation? Or can I find a list somewhere? I am already running a demo version for upgrade and plugin testing so it would be a mess to overwrite this with a clean installation and revert it afterwards, if somebody wonders why I don't do it this way Thanks, Phil
Faqole Posted October 21, 2017 Posted October 21, 2017 6 hours ago, Phil7789 said: Hey, does anybody know or can tell me what tables the database for IPS 4.x uses? I've upgraded from 3.x to 4.x when it was released and still have some orphaned tables (including some plugins I do not use anymore). After having problems with converting my database from utf8 to utf8mb4, because the system still threw the information that those changes should be made, I changed some tables manually, which kept utf8. Know all checks run fine, but I am not sure if I could drop those tables I changed as they're perhaps not needed anymore. Is there anybody who could provide me a list of the "standard tables" you have with a clean 4.x installation? Or can I find a list somewhere? I am already running a demo version for upgrade and plugin testing so it would be a mess to overwrite this with a clean installation and revert it afterwards, if somebody wonders why I don't do it this way Thanks, Phil Hello Phil, Why do not you install a copy of Ipb 4.2. as a test forum. It will give you a list of the standard tables.
Phil7789 Posted October 22, 2017 Author Posted October 22, 2017 Hi, as I wrote above I already have a test forum with my demo license key for testing purposes. I would have to delete everything and reconfigure it afterwards which is a lot of work, so I asked because it might've been that somebody has a clean install and could just copy & paste the names of the tables
Martin A. Posted October 22, 2017 Posted October 22, 2017 localhost/cleanIps42/ http://localhost/phpMyAdmin/db_sql.php?db=cleanIps42 Your SQL query has been executed successfully. SHOW TABLES; calendar_calendars calendar_event_comments calendar_event_reminders calendar_event_reviews calendar_event_rsvp calendar_events calendar_import_feeds calendar_import_map calendar_venues cms_blocks cms_containers cms_custom_database_1 cms_database_categories cms_database_comments cms_database_fields cms_database_fields_reciprocal_map cms_database_fields_thumbnails cms_database_reviews cms_database_revisions cms_databases cms_folders cms_media cms_media_folders cms_page_widget_areas cms_pages cms_templates cms_url_store 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_clubs core_clubs_fields core_clubs_fieldvalues core_clubs_memberships core_clubs_node_map core_content_meta core_deletion_log core_dev core_edit_history core_email_templates core_emoticons core_error_logs core_file_logs core_file_storage core_files core_files_temp core_follow core_geoip_cache core_googleauth_used_codes core_group_promotions 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_member_history core_member_ranks core_member_status_replies core_member_status_updates core_members core_members_known_devices core_members_known_ip_addresses core_members_warn_actions core_members_warn_logs core_members_warn_reasons core_menu core_message_posts core_message_topic_user_map core_message_topics core_moderator_logs core_moderators core_modules core_notification_defaults core_notification_preferences core_notifications core_permission_index core_pfields_content core_pfields_data core_pfields_groups core_plugins core_polls core_profanity_filters core_profile_steps core_question_and_answer core_queue core_ratings core_rc_comments core_rc_index core_rc_reports core_reactions core_reputation_index core_reputation_leaderboard_history core_reputation_levels core_rss_export core_search_index core_search_index_item_map core_search_index_tags core_security_answers core_security_questions core_seo_meta core_sessions core_share_links core_sitemap core_social_promote core_social_promote_content core_social_promote_sharers core_soft_delete_log core_spam_service_log core_statistics core_store core_streams core_sys_conf_settings core_sys_cp_sessions core_sys_lang core_sys_lang_words core_sys_social_group_members core_sys_social_groups core_tags core_tags_cache core_tags_perms core_tasks core_tasks_log 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_themes core_upgrade_history core_validating core_view_updates core_voters core_widget_areas core_widget_trash core_widgets forums_answer_ratings forums_archive_posts forums_archive_rules forums_forums forums_posts forums_question_ratings forums_rss_import forums_rss_imported forums_topic_mmod forums_topics forums_view_method Tables for Calendar, Core, Pages and Forums.
Meddysong Posted October 23, 2017 Posted October 23, 2017 I have the whole suite: blog_blogs blog_comments blog_entries blog_rss_import blog_rss_imported calendar_calendars calendar_event_comments calendar_event_reminders calendar_event_reviews calendar_event_rsvp calendar_events calendar_import_feeds calendar_import_map calendar_venues chat_log_archive cms_blocks cms_containers cms_database_categories cms_database_comments cms_database_fields cms_database_fields_reciprocal_map cms_database_fields_thumbnails cms_database_reviews cms_database_revisions cms_databases cms_folders cms_media cms_media_folders cms_page_database_map cms_page_widget_areas cms_pages cms_templates cms_url_store 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_clubs core_clubs_fields core_clubs_fieldvalues core_clubs_memberships core_clubs_node_map core_content_meta core_deletion_log core_dev core_edit_history core_email_templates core_emoticons core_error_logs core_file_logs core_file_storage core_files core_files_temp core_follow core_geoip_cache core_googleauth_used_codes core_group_promotions 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_member_history core_member_ranks core_member_status_replies core_member_status_updates core_members core_members_known_devices core_members_known_ip_addresses core_members_warn_actions core_members_warn_logs core_members_warn_reasons core_menu core_message_posts core_message_topic_user_map core_message_topics core_moderator_logs core_moderators core_modules core_notification_defaults core_notification_preferences core_notifications core_permission_index core_pfields_content core_pfields_data core_pfields_groups core_plugins core_polls core_profanity_filters core_profile_steps core_question_and_answer core_queue core_ratings core_rc_comments core_rc_index core_rc_reports core_reactions core_reputation_index core_reputation_leaderboard_history core_reputation_levels core_rss_export core_search_index core_search_index_item_map core_search_index_tags core_security_answers core_security_questions core_seo_meta core_sessions core_share_links core_sitemap core_social_promote core_social_promote_content core_social_promote_sharers core_soft_delete_log core_spam_service_log core_statistics core_store core_streams core_sys_conf_settings core_sys_cp_sessions core_sys_lang core_sys_lang_words core_sys_social_group_members core_sys_social_groups core_tags core_tags_cache core_tags_perms core_tasks core_tasks_log 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_themes core_upgrade_history core_validating core_view_updates core_voters core_widget_areas core_widget_trash core_widgets downloads_categories downloads_ccontent downloads_cfields downloads_comments downloads_downloads downloads_filebackup downloads_files downloads_files_records downloads_reviews downloads_sessions forums_answer_ratings forums_archive_posts forums_archive_rules forums_forums forums_posts forums_question_ratings forums_rss_import forums_rss_imported forums_topic_mmod forums_topics forums_view_method gallery_album_comments gallery_album_reviews gallery_albums gallery_bandwidth gallery_categories gallery_comments gallery_images gallery_images_uploads gallery_reviews nexus_alternate_contacts nexus_billing_agreements nexus_cart_uploads nexus_coupons nexus_customer_addresses nexus_customer_cards nexus_customer_fields nexus_customers nexus_donate_goals nexus_donate_logs nexus_eom nexus_fraud_rules nexus_hosting_accounts nexus_hosting_errors nexus_hosting_queues nexus_hosting_servers nexus_invoices nexus_licensekeys nexus_notes nexus_package_base_prices nexus_package_fields nexus_package_groups nexus_package_images nexus_packages nexus_packages_ads nexus_packages_hosting nexus_packages_products nexus_paymethods nexus_payouts nexus_product_options nexus_purchases nexus_referral_banners nexus_referral_rules nexus_referrals nexus_reviews nexus_ship_orders nexus_shipping nexus_support_default_content nexus_support_departments nexus_support_fields nexus_support_notify nexus_support_ratings nexus_support_replies nexus_support_request_log nexus_support_requests nexus_support_severities nexus_support_staff_dpt_order nexus_support_staff_preferences nexus_support_statuses nexus_support_stock_actions nexus_support_streams nexus_support_tracker nexus_support_views nexus_tax nexus_transactions I've deleted the ones which showed my custom databases and plugins, although I can't promise that there aren't a couple of non-standard ones in there which I'm not aware of. That said, you could always get a five-day demo of the entire suite and then check using the SQL Toolbox in the ACP.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.