New to the community? Start here

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’:wink:;

add_global_table(‘admin_global’:wink:;

add_global_table(‘system_faq’:wink:;

add_global_table(‘system_faq_cats’:wink:;

add_global_table(‘system_tickets’:wink:;

add_global_table(‘system_tickets_cats’:wink:;

add_global_table(‘system_tickets_messages’:wink:;

//

//

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!

Fri, 19 Jun 2009 0:56:32
  • Andrew
    • Champion of Loops

    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’:wink:;

    add_global_table(‘support_system_faq_cats’:wink:;

    add_global_table(‘support_system_tickets’:wink:;

    add_global_table(‘support_system_tickets_cats’:wink:;

    add_global_table(‘support_system_tickets_messages’:wink:;

    add_global_table(‘gb_templates’:wink:;

    add_global_table(‘forums’:wink:;

    add_global_table(‘posts’:wink:;

    add_global_table(‘topics’:wink:;

    add_global_table(‘supporters’:wink:;

    add_global_table(‘supporter_ads’:wink:;

    add_global_table(‘supporter_transactions’:wink:;

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

    Thanks,

    Andrew

  • ChuckS
    • The Crimson Coder

    Do I still need these (without the "support_"?

    add_global_table(‘system_faq’:wink:;

    add_global_table(‘system_faq_cats’:wink:;

    add_global_table(‘system_tickets’:wink:;

    add_global_table(‘system_tickets_cats’:wink:;

    add_global_table(‘system_tickets_messages’:wink:;

  • ChuckS
    • The Crimson Coder

    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’:wink:;

    add_global_table(‘admin_support_system_faq’:wink:;

    add_global_table(‘admin_support_system_faq_cats’:wink:;

    add_global_table(‘admin_support_system_tickets’:wink:;

    add_global_table(‘admin_support_system_tickets_cats’:wink:;

    add_global_table(‘admin_support_system_tickets_messages’:wink:;

    add_global_table(‘admin_gb_templates’:wink:;

    add_global_table(‘admin_forums’:wink:;

    add_global_table(‘admin_posts’:wink:;

    add_global_table(‘admin_topics’:wink:;

    add_global_table(‘admin_supporters’:wink:;

    add_global_table(‘admin_supporter_ads’:wink:;

    add_global_table(‘admin_supporter_transactions’:wink:;

    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
    • Champion of Loops

    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’:wink:;

    add_global_table(‘support_faq_cats’:wink:;

    add_global_table(‘support_tickets’:wink:;

    add_global_table(‘support_tickets_cats’:wink:;

    add_global_table(‘support_tickets_messages’:wink:;

    add_global_table(‘gb_templates’:wink:;

    add_global_table(‘forums’:wink:;

    add_global_table(‘posts’:wink:;

    add_global_table(‘topics’:wink:;

    add_global_table(‘supporters’:wink:;

    add_global_table(‘supporter_ads’:wink:;

    add_global_table(‘supporter_transactions’:wink:;

    add_global_table(‘admin_global’:wink:;

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

    Thanks,

    Andrew