Multi DB warning

Hi Guys,

Got a problem, I've currently installed multidb on a new wpmu network (my main domain and a test blog), i set up 256 DB's, completed installing multidb but when i visit my site i get this message:

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

Fatal error: Call to undefined method m_wpdb::handle_error_connecting() in /home/marketbl/public_html/wp-content/db.php on line 223

so i deleted the db.php file and the site appeared.

Any ideas? Have i missed something? Followed a tutorial i came across online.

Freddie

  • marcobrasil65

    I have a problem to install multi db wordpress mu 2.9.2 the error is this:

    Warning Invalid Argument supplied for foreach() in xxx/xxx/xxx/wp-content/db.php on line 164

    and error

    Fatal Error: Call to undefinied methd m_wpdb::handle_error_connecting() in xxx/xxx/xxx/wp-content/db.php on line 223

    Is possissible resolve?

    i installed wp mu 2.9.2

    host have gostgator

    Please help to multidb 4096 for networg blog

  • JimKernan

    <?php
    // Plugin Name: Multi-DB
    // Plugin URI: https://premium.wpmudev.org/project/Multiple-Databases
    // Author: Andrew Billits (Incsub)
    // Version: 2.9.2
    //------------------------------------------------------------------------//
    //---DB Scaling-----------------------------------------------------------//
    //------------------------------------------------------------------------//
    // 16,256,4096
    define ('DB_SCALING', '16');
    //------------------------------------------------------------------------//
    //---DC IPs---------------------------------------------------------------//
    //------------------------------------------------------------------------//
    // Usage: add_dc_ip(IP, DC)
    // EX: add_dc_ip('123.123.123.', 'dc1');
    add_dc_ip('67.222.53.133', 'dc1');
    //------------------------------------------------------------------------//
    //---Global Tables--------------------------------------------------------//
    //------------------------------------------------------------------------//
    // Do not include default global tables
    // Leave off base prefix (eg: wp_)
    //
    // Usage: add_global_table(TABLE_NAME)
    // EX: add_global_table('something');
    add_global_table('main_table');
    //------------------------------------------------------------------------//
    //---DB Servers-----------------------------------------------------------//
    //------------------------------------------------------------------------//
    // Database servers grouped by dataset.
    // R can be 0 (no reads) or a positive integer indicating the order
    // in which to attempt communication (all locals, then all remotes)
    //
    // Usage: add_db_server(DS, DC, READ, WRITE, HOST, LAN_HOST, NAME, USER, PASS)
    // EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword');
    //
    // Note: you can also place this section in a file called db-list.php in wp-content
    // EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword');
    add_db_server('0', 'dc1', 1, 1,'','67.222.53.133', 'db_global', 'user', 'password');

    add_db_server('0', 'dc1', 1, 1,'','67.222.53.133', 'db_0', 'user', 'password');
    add_db_server('1', 'dc1', 1, 1,'','67.222.53.133', 'db_1', 'user', 'password');
    add_db_server('2', 'dc1', 1, 1,'','67.222.53.133', 'db_2', 'user', 'password');
    add_db_server('3', 'dc1', 1, 1,'','67.222.53.133', 'db_3', 'user', 'password');
    add_db_server('4', 'dc1', 1, 1,'','67.222.53.133', 'db_4', 'user', 'password');
    add_db_server('5', 'dc1', 1, 1,'','67.222.53.133', 'db_5', 'user', 'password');
    add_db_server('6', 'dc1', 1, 1,'','67.222.53.133', 'db_6', 'user', 'password');
    add_db_server('7', 'dc1', 1, 1,'','67.222.53.133', 'db_7', 'user', 'password');
    add_db_server('8', 'dc1', 1, 1,'','67.222.53.133', 'db_8', 'user', 'password');
    add_db_server('9', 'dc1', 1, 1,'','67.222.53.133', 'db_9', 'user', 'password');
    add_db_server('a', 'dc1', 1, 1,'','67.222.53.133', 'db_a', 'user', 'password');
    add_db_server('b', 'dc1', 1, 1,'','67.222.53.133', 'db_b', 'user', 'password');
    add_db_server('c', 'dc1', 1, 1,'','67.222.53.133', 'db_c', 'user', 'password');
    add_db_server('d', 'dc1', 1, 1,'','67.222.53.133', 'db_d', 'user', 'password');
    add_db_server('e', 'dc1', 1, 1,'','67.222.53.133', 'db_e', 'user', 'password');
    add_db_server('f', 'dc1', 1, 1,'','67.222.53.133', 'db_f', 'user', 'password');

    //------------------------------------------------------------------------//
    //---VIP Blogs------------------------------------------------------------//
    //------------------------------------------------------------------------//
    // Usage: add_vip_blog(BLOG_ID, DS)
    // EX: add_vip_blog(1, 'vip1');

    Thanks in advance

  • turkon

    I have solved the problem. I was living the problem because of localhost.Use this like this. The errors will go. And everything seems working right now.

    add_db_server('global', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_global', 'username', 'password');
    add_db_server('0', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_0', 'username', 'password');
    add_db_server('1', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_1', 'username', 'password');
    add_db_server('2', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_2', 'username', 'password');
    add_db_server('3', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_3', 'username', 'password');
    add_db_server('4', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_4', 'username', 'password');
    add_db_server('5', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_5', 'username', 'password');
    add_db_server('6', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_6', 'username', 'password');
    add_db_server('7', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_7', 'username', 'password');
    add_db_server('8', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_8', 'username', 'password');
    add_db_server('9', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_9', 'username', 'password');
    add_db_server('a', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_a', 'username', 'password');
    add_db_server('b', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_b', 'username', 'password');
    add_db_server('c', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_c', 'username', 'password');
    add_db_server('d', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_d', 'username', 'password');
    add_db_server('e', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_e', 'username', 'password');
    add_db_server('f', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_f', 'username', 'password');

    But I have some questions,how will I be sure about the server's database if it is using the old one or new ones?

    Regards,
    Mustafa