WordPress.org

Ready to get started?Download WordPress

Forums

Magic Fields 2
Redundant tables in multisite? (2 posts)

  1. ade11
    Member
    Posted 1 year ago #

    We note your plugin creates 4 tables at the top level, wp_mf_custom_fields, etc.

    Please can you mention if these tables are intentional? Are they used? In future releases of the plugin, are they likely to be removed?

    We ask because we have a development-production setup for QA, where development is done on non-live servers, and then copied to the live production domain when ready. Only a single site's blog tables and uploads are copied over, not top level tables, so we need to confirm the plugin will work correctly without them.

    Please advise!

    http://wordpress.org/extend/plugins/magic-fields-2/

  2. Magenta Cuda
    Member
    Posted 1 year ago #

    I am not the author of this plugin but since I have studied the design of this plugin I can answer some of your questions. First, on my installation there are 5 not 4 Magic Fields 2 tables: wp_mf_custom_fields, wp_mf_custom_groups, wp_mf_custom_taxonomy, wp_mf_post_meta and wp_mf_posttypes. These tables contain names and attributes of fields, taxonomies and post types and are essential to the operation of Magic Fields 2. Magic Fields 2 will not work without them.

    My two cents:

    If you only copy the WordPress tables then there are many WordPress plugins that you will not be able to use not just Magic Fields 2. In particular, two very popular plugins that I use NextGen Gallery and WooCommerce both create their own tables. I believe it is both valid and quite common for plugins to create their own tables.

    Having said that I have also studied the design of two other WordPress CMS plugins, Pods and Types, which have similar storage requirements to Magic Fields 2 and neither of these plugins create additional tables but instead store the information in the WordPress tables wp_options, wp_postmeta and wp_posts. So it is possible to make a CMS plugin without creating additional tables. Furthermore, in addition to the difficulty that the additional tables are causing you I have found post copy utilities such as Duplicate Post and Post Duplicator cannot work with Magic Fields 2 as some essential field data is stored in non WordPress tables which a generic plugin cannot know about.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic