New to the community? Start here

Multi-db error, site not working now

Hello,

I have a 256 multi-db wordpress/MU buddypress site (sportsblognet.com)

Everything was working fine, but I got curios when

I was looking through my phpmyadmin and noticed that I had a few tables (bp_activity, bp_activity_meta, and wp_domain_mapping_logins) that were in d4 instead of in global.

So, naturally I wanted to rectify this, so I exported the 3 tables with drop table, and imported them into global. I then went into db-config.php and added the global tables.

Now I can’t get onto my site it just shows this:

Warning: Invalid argument supplied for foreach() in /home/sbn/public_html/wp-content/db.php on line 848

Warning: error_log(/tmp/db-connect.txt) [function.error-log]: failed to open stream: Permission denied in /home/sbn/public_html/wp-content/db.php on line 932

Warning: error_log(/tmp/db-connect.txt) [function.error-log]: failed to open stream: Permission denied in /home/sbn/public_html/wp-content/db.php on line 932

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/sbn/public_html/wp-content/db.php on line 447

Warning: Invalid argument supplied for foreach() in /home/sbn/public_html/wp-content/db.php on line 828

So I undid everything and placed humpty dumpty back the way it was and I still get those errors.

Please Help.

Mon, 8 Mar 2010 17:36:05
  • Andrew
    • Champion of Loops

    Hiya,

    Several things are going on here:

    1) The bp tables in d4 was caused by a Multi-DB bug. I’m prepping a new version that will fix this. When upgrading to the new version you will need to remove the global table lines you added to db-config.php

    2) It looks like you might have failed to add the Domain Mapping table to db-config.php when installing the plugin,

    3) The “error_log” errors are being caused by another bug which will be fixed in the new release.

    4) The “Warning: Invalid argument supplied for foreach() in /home/sbn/public_html/wp-content/db.php on line 828” seems to be caused by a db-config.php config error. Make sure you didn’t mess anything up when adding the additional lines.

    The new version will be available in a few minutes.

    Thanks,

    Andrew

  • Rich
    • Design Lord, Child of Thor

    this is what they were when it worked fine

    //	EX: add_global_table('something');
    

    
add_global_table('bb_forums');
    

    
add_global_table('bb_meta');
    

    
add_global_table('bb_posts');
    

    
add_global_table('bb_terms');
    

    
add_global_table('bb_term_relationships');
    

    
add_global_table('bb_term_taxonomy');
    

    
add_global_table('bb_topics');
    

    
add_global_table('domain_mapping');
    

    
add_global_table('dpa_achievements');
    

    
add_global_table('dpa_achievements_categories');
    

    
add_global_table('dpa_achievements_unlocked');
    

    
add_global_table('wp_ust');
    

    
add_global_table('wp_site_posts');
    

    
add_global_table('wp_term_counts');

    i added:

    add_global_table('wp_domain_mapping_logins');
    

    
add_global_table('wp_bp_activity');
    

    
add_global_table('wp_bp_activity_meta');

    but have since taken it out and it still doesn’t work

  • Rich
    • Design Lord, Child of Thor

    Ok, so it works now, it was a problem with the db-config.php, but

    When upgrading to the new version you will need to remove the global table lines you added to db-config.php

    Do you mean not adding:

    add_global_table('wp_bp_activity');
    

    
add_global_table('wp_bp_activity_meta');

    Or take everything out of the global tables?