351 points
Community rank #140
ChuckS
ExpertFriendly Neighbour
MemberLikes (0)
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:
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:
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.
7430 pointsCommunity rank #7Supreme DeityMember of the MonthLifetime member
Erstwhile founder
(joined May 2007)
Likes (0)
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?
You're awesome. Thanks. It's working and the tables are getting filled. Problem with the menu though. I'll research and start a new thread if I need to.
Thanks again!
Chuck S.
Responses (7)
Erstwhile founder (joined May 2007) Likes (0)
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
Member (joined March 2009) Likes (0)
Do I still need these (without the "support_"?
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');
Erstwhile founder (joined May 2007) Likes (0)
Nope, remove those lines.
Thanks,
Andrew
Member (joined March 2009) Likes (0)
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.
Member (joined March 2009) Likes (0)
p.s. Sorry, I meant "tables" instead of "db's". Also, I looked in all the other db's and didn't find the tables there either.
Erstwhile founder (joined May 2007) Likes (0)
Hiya.
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)."
You need to add the lines exactly as I had them.
Note this line in db-config:
// Leave off base prefix (eg: wp_)
Most of the plugins will not reinstall. That's why you need to move the tables as I mentioned.
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');
Do you have a table called "admin_global"? If not then that line doesn't need to be there.
Thanks,
Andrew
Member (joined March 2009) Likes (0)
You're awesome. Thanks. It's working and the tables are getting filled. Problem with the menu though. I'll research and start a new thread if I need to.
Thanks again!
Chuck S.
WordPress Questions?
We've got answers!
Find out more »