I am using the multiDB plugin and I know I set up the global tables right, but the only thing that seems to be working is the email notification. The support ticket wont show open tickets in any of the admins even when I test it.
checking the error logs I see that they tickets are trying to access different db's . so I tried a dump with the added sql.txt directly into globals db but it still did not seem to work. should I have did the dump first then activated the support system by visiting the link in admin?
or am I doing something else wrong all together?
the only other thing I did not do was drop the screenshots in the root directory, thought they were redundant?
I am using the multiDB plugin and I know I set up the global tables right, but the only thing that seems to be working is the email notification. The support ticket wont show open tickets in any of the admins even when I test it.
checking the error logs I see that they tickets are trying to access different db's . so I tried a dump with the added sql.txt directly into globals db but it still did not seem to work. should I have did the dump first then activated the support system by visiting the link in admin?
or am I doing something else wrong all together?
the only other thing I did not do was drop the screenshots in the root directory, thought they were redundant?
Again Tony, it's a weekend, but if the only thing that isn't working properly is email notifications then I'd hazard a guess that this is hosting / server related.
Hi Tony, I've never used this plugin, but if it is trying access different db's then I would suggest that the global database isn't defined or your global tables are wrong.
I have other add_global_table additions that are currently working fine like
add_global_table('wp_mass_mailer');
and actually the email is working... I get an email notification. but when I log into admin, there is no ticket. that is where the issue is.
and error logs say
WordPress database error Table 'ichangedthis_d41.wp_users' doesn't exist for query
I added in "ichangedthis" so I dont show username of my main server.
so, even though I added as global table in db-config it seems it is trying to look in the wrong place for this user... still wondering if I have my db-config set up right... or another issue. I have the mult-db set up with over 4000 db's.
maybe I can have you look at my db-config file?
should I have added 'system_faq_cats', 'system_tickets', 'system_tickets_cats', 'system_tickets_messages'
in here?
and on line 110 I see this
/**
* Connects to the database server and selects a database
* @param string $dbuser
* @param string $dbpassword
* @param string $dbname
* @param string $dbhost
*/
should this be uncommented?
as well as this?
function wpdb($dbuser, $dbpassword, $dbname, $dbhost) {
/* Multi-DB Remove
if( defined( "WP_USE_MULTIPLE_DB" ) && CONSTANT( "WP_USE_MULTIPLE_DB" ) == true )
*/
//$this->db_connect();
are you talking about the global tables section in db.php line 28 that says;
$global_tables = array ($table_prefix . 'blogs',$table_prefix . 'blog_versions',$table_prefix . 'registration_log',$table_prefix . 'signups',$table_prefix . 'site',$table_prefix . 'sitecategories',$table_prefix . 'sitemeta',$table_prefix . 'usermeta',$table_prefix . 'users');
Andrew,
thanks that was it exactly. Did not look at the directory. just went with the default set up in the plugin.
I see that the video library is disabled, is there an easy way to enable it?
thanks.
Tony V
I see that the video library is disabled, is there an easy way to enable it?
We removed the videos to make the plugin a bit easier to maintain. Most of the code is still in there if you want to re-enable it but you'll have to modify it to work with the newer videos.
Responses (13)
Member — 29th May 2009 (2 years ago) #
any ideas?
Tony V
Founder & CEO — 30th May 2009 (2 years ago) #
Again Tony, it's a weekend, but if the only thing that isn't working properly is email notifications then I'd hazard a guess that this is hosting / server related.
Developer — 30th May 2009 (2 years ago) #
Hi Tony, I've never used this plugin, but if it is trying access different db's then I would suggest that the global database isn't defined or your global tables are wrong.
Erstwhile founder — 1st June 2009 (2 years ago) #
Hiya,
Can you post what you added to your db-config.php file for this plugin?
Thanks,
Andrew
Member — 3rd June 2009 (2 years ago) #
add_global_table('system_faq_cats');
add_global_table('system_tickets');
add_global_table('system_tickets_cats');
add_global_table('system_tickets_messages');
I have other add_global_table additions that are currently working fine like
add_global_table('wp_mass_mailer');
and actually the email is working... I get an email notification. but when I log into admin, there is no ticket. that is where the issue is.
and error logs say
WordPress database error Table 'ichangedthis_d41.wp_users' doesn't exist for query
I added in "ichangedthis" so I dont show username of my main server.
so, even though I added as global table in db-config it seems it is trying to look in the wrong place for this user... still wondering if I have my db-config set up right... or another issue. I have the mult-db set up with over 4000 db's.
maybe I can have you look at my db-config file?
thanks.
Tony V
Member — 3rd June 2009 (2 years ago) #
well I just found this bit in my db.php line 108
var $global_tables = array('blogs', 'signups', 'site', 'sitemeta', 'users', 'usermeta', 'sitecategories', 'registration_log', 'blog_versions');
should I have added 'system_faq_cats', 'system_tickets', 'system_tickets_cats', 'system_tickets_messages'
in here?
and on line 110 I see this
/**
* Connects to the database server and selects a database
* @param string $dbuser
* @param string $dbpassword
* @param string $dbname
* @param string $dbhost
*/
should this be uncommented?
as well as this?
function wpdb($dbuser, $dbpassword, $dbname, $dbhost) {
/* Multi-DB Remove
if( defined( "WP_USE_MULTIPLE_DB" ) && CONSTANT( "WP_USE_MULTIPLE_DB" ) == true )
*/
//$this->db_connect();
Thanks.
Tony V
Founder & CEO — 3rd June 2009 (2 years ago) #
Hi Tony, not my area of expertise but we'll look into it asap
Erstwhile founder — 3rd June 2009 (2 years ago) #
Hiya,
Nope, leave that area alone. You need to add the tables to the "Global Tables" section.
Ex:
add_global_table('system_faq_cats');
add_global_table('system_tickets');
Leave commented out lines alone ;)
Thanks,
Andrew
Member — 3rd June 2009 (2 years ago) #
Thanks Andrew.
are you talking about the global tables section in db.php line 28 that says;
$global_tables = array ($table_prefix . 'blogs',$table_prefix . 'blog_versions',$table_prefix . 'registration_log',$table_prefix . 'signups',$table_prefix . 'site',$table_prefix . 'sitecategories',$table_prefix . 'sitemeta',$table_prefix . 'usermeta',$table_prefix . 'users');
?
as I mentioned I already have ;
add_global_table('system_faq_cats');
add_global_table('system_tickets');
add_global_table('system_tickets_cats');
add_global_table('system_tickets_messages');
in db-config.php
thanks.
Tony V
Erstwhile founder — 3rd June 2009 (2 years ago) #
Hi Tony,
Please do not modify anything in db.php. There are no user configurable sections in that file.
Edit: Btw, you might want to check those table names. Those don't look right to me.
Thanks,
Andrew
Member — 6th June 2009 (2 years ago) #
Andrew,
thanks that was it exactly. Did not look at the directory. just went with the default set up in the plugin.
I see that the video library is disabled, is there an easy way to enable it?
thanks.
Tony V
Erstwhile founder — 6th June 2009 (2 years ago) #
Hiya,
We removed the videos to make the plugin a bit easier to maintain. Most of the code is still in there if you want to re-enable it but you'll have to modify it to work with the newer videos.
Thanks,
Andrew
Keeper of the Dark Chocolate — 6th June 2009 (2 years ago) #
Some of us are on networks that drop every 5 megs as well. *grumble*
They say it's to prevent file trading but those are in 4 meg segments. I love my library's IT department. :P
Become a member