Support System plugin add_global_tables

Hello,
Thanks for the great plugin! I just installed it into WPMU 2.7.1 with Multi-DB installed. Everything seems to be working fine. The install created the db tables into a regular Multi-db ( _d4) and not the global db. Here's my addition to the db-config.php:

// Usage: add_global_table(TABLE_NAME)

// EX: add_global_table('something');

add_global_table('admin_global');
add_global_table('system_faq');
add_global_table('system_faq_cats');
add_global_table('system_tickets');
add_global_table('system_tickets_cats');
add_global_table('system_tickets_messages');

//------------------------------------------------------------------------//

Here's what the db looks like. Apparently the forums, templates and supporter plugins are in there too.

admin_d4 (12)

wp_forums
wp_gb_templates
wp_posts
wp_supporters
wp_supporter_ads
wp_supporter_transactions
wp_support_faq
wp_support_faq_cats
wp_support_tickets
wp_support_tickets_cats
wp_support_tickets_messages
wp_topics

Am I OK, or am I doing something wrong?
Much Thanks!

  • Andrew

    You need to add the lines to db-config.php before uploading the plugins.

    Based on the tables you listed you need to add this to your db-config.php:

    add_global_table('support_system_faq');
    add_global_table('support_system_faq_cats');
    add_global_table('support_system_tickets');
    add_global_table('support_system_tickets_cats');
    add_global_table('support_system_tickets_messages');
    add_global_table('gb_templates');
    add_global_table('forums');
    add_global_table('posts');
    add_global_table('topics');
    add_global_table('supporters');
    add_global_table('supporter_ads');
    add_global_table('supporter_transactions');

    Then you need to move those tables from admin_d4 to your global table (admin_global).

    Thanks,
    Andrew

  • ChuckS

    Well, now I'm all messed up. I moved the db's as you said. Then I thought I would just start fresh. I deleted the support type db's and support plugin files. Added the code to db-config.php as suggested above, only added my db prefix "admin" from my global example to be consistant as follows:

    add_global_table('admin_global');
    add_global_table('admin_support_system_faq');
    add_global_table('admin_support_system_faq_cats');
    add_global_table('admin_support_system_tickets');
    add_global_table('admin_support_system_tickets_cats');
    add_global_table('admin_support_system_tickets_messages');
    add_global_table('admin_gb_templates');
    add_global_table('admin_forums');
    add_global_table('admin_posts');
    add_global_table('admin_topics');
    add_global_table('admin_supporters');
    add_global_table('admin_supporter_ads');
    add_global_table('admin_supporter_transactions');

    The "support" tables did not create. So I re-installed the support plugin, thinking it would create the tables. Selected "FAQ Manager and "Support Ticket Manager", they worked but no db's were created (even refreshing MyAdminphp).

    That didn't work so I started over, deleted the plugin and removed the "admin" part except for admin_global, re-installed the plugin. Still no go.

    I don't know much as a newbie, are we sure we want "system" in there? The incsub-support.php refers to "support_faq", etc. I looked at the help file sql.txt and it didn't include "system" either. But anyway, the db's still aren't created.

    Please clarify. You help is much appreciated.

  • Andrew

    Hiya.

    I moved the db's as you said.

    I didn't say anything about moving databases. I said "Then you need to move those tables from admin_d4 to your global table (admin_global)."

    only added my db prefix "admin" from my global example to be consistant as follows

    You need to add the lines exactly as I had them.

    Note this line in db-config:
    // Leave off base prefix (eg: wp_)

    The "support" tables did not create. So I re-installed the support plugin, thinking it would create the tables. Selected "FAQ Manager and "Support Ticket Manager", they worked but no db's were created (even refreshing MyAdminphp).

    Most of the plugins will not reinstall. That's why you need to move the tables as I mentioned.

    I don't know much as a newbie, are we sure we want "system" in there?

    Oops, that's my mistake. You're definitely right.

    add_global_table('support_faq');
    add_global_table('support_faq_cats');
    add_global_table('support_tickets');
    add_global_table('support_tickets_cats');
    add_global_table('support_tickets_messages');
    add_global_table('gb_templates');
    add_global_table('forums');
    add_global_table('posts');
    add_global_table('topics');
    add_global_table('supporters');
    add_global_table('supporter_ads');
    add_global_table('supporter_transactions');

    add_global_table('admin_global');

    Do you have a table called "admin_global"? If not then that line doesn't need to be there.

    Thanks,
    Andrew

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.