MultiDB Some blogs display blank page.

My website use Wordpress 3.0.1 which has around 700 blogs.

I've just install multi-DB 3.0.1 (I think the installation was correctly) with 16 DBs.

After installation finished, no error was found. I can access my website correctly. All data were copied to new 16DB.

But there are some problems with some of my blogs. Some appear blank page (few blogs) Most of blogs display correctly.

I go to check those error blogs in Wordpress --> Super Admin --> Site, I can see those blog's names but can not edit or delete them, there are no options. The rest are normal (mostly)

When I checked tables in PHPMyAdmin, the table was copied correcltly.

It seem like script partially could not connect to some blogs ( the example sequence number of each error blog are 59,60,63.....)

I have no idea to correct this problems.

  • noii167

    Hello, I repeated installation of multiDB. Here are my steps
    Fist, I run SQL query in PHPmyadmin to created all database
    CREATE DATABASE insurx_0 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_2 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_3 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_4 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_5 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_6 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_7 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_8 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_9 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_a DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_b DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_c DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_d DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_e DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_f DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_global DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE DATABASE insurx_vip_1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    This is my dbconfig.php

    <?php

    define ('DB_SCALING', '16');
    add_dc_ip('ip.ip.ip.', 'dc1'); <---- my ip was censored
    add_global_table('wp_site_posts');
    add_global_table('wp_term_counts');
    add_db_server('global', 'dc1', 1, 1,'localhost','localhost', 'insurx_global', 'user', 'pass');
    add_db_server('1', 'dc1', 1, 1,'localhost','localhost', 'insurx_1', 'user', 'pass');
    add_db_server('2', 'dc1', 1, 1,'localhost','localhost', 'insurx_2', 'user', 'pass');
    add_db_server('3', 'dc1', 1, 1,'localhost','localhost', 'insurx_3', 'user', 'pass');
    add_db_server('4', 'dc1', 1, 1,'localhost','localhost', 'insurx_4', 'user', 'pass');
    add_db_server('5', 'dc1', 1, 1,'localhost','localhost', 'insurx_5', 'user', 'pass');
    add_db_server('6', 'dc1', 1, 1,'localhost','localhost', 'insurx_6', 'user', 'pass');
    add_db_server('7', 'dc1', 1, 1,'localhost','localhost', 'insurx_7', 'user', 'pass');
    add_db_server('8', 'dc1', 1, 1,'localhost','localhost', 'insurx_8', 'user', 'pass');
    add_db_server('9', 'dc1', 1, 1,'localhost','localhost', 'insurx_9', 'user', 'pass');
    add_db_server('a', 'dc1', 1, 1,'localhost','localhost', 'insurx_a', 'user', 'pass');
    add_db_server('b', 'dc1', 1, 1,'localhost','localhost', 'insurx_b', 'user', 'pass');
    add_db_server('c', 'dc1', 1, 1,'localhost','localhost', 'insurx_c', 'user', 'pass');
    add_db_server('d', 'dc1', 1, 1,'localhost','localhost', 'insurx_d', 'user', 'pass');
    add_db_server('e', 'dc1', 1, 1,'localhost','localhost', 'insurx_e', 'user', 'pass');
    add_db_server('f', 'dc1', 1, 1,'localhost','localhost', 'insurx_f', 'user', 'pass');
    add_db_server('g', 'dc1', 1, 1,'localhost','localhost', 'insurx_g', 'user', 'pass');
    add_db_server('vip1', 'dc1', 1, 1,'localhost','localhost', 'insurx_vip_1', 'user', 'pass');
    //------------------------------------------------------------------------//
    //---VIP Blogs------------------------------------------------------------//
    //------------------------------------------------------------------------//
    // Usage: add_vip_blog(BLOG_ID, DS)
    // EX: add_vip_blog(1, 'vip1');

    add_vip_blog(1, 'vip1');
    ?>

    this is my config in move-blogs.php

    $dbname = "insur"; <-- my old database
    $blog_table_prefix = 'wp_';
    $newdb_prefix = 'insurx_';

    $dbhost = 'localhost';
    $dbuname = 'user';
    $dbpass = 'pass';

    //How many db's are you moving into (16, 256, or 4096)?
    $db_scaling = '16';

    When I ran move-blogs.php , everything seem ok, all tables were copied to a new database completely with no error.

    I can open my main domain ,display correctly. Some of blogs appear normal. BUT some blogs can not open and display as blank page like the previous multidb installation. WhenI go to check blogs in wordpress multisite, no options at each error blogs was seen and could not access edit page.

    These are blog error ' s number 59, 60, 63,109,126,138,158,,168,,191,196,,221,236,and more !...

    I have checked MSLQ error log, no error or warning was found.

    I have chkeced PHP error log, no error was found.

    I think I installed multiDB correctly.

    Could you please check this problems?

  • James Farmer

    @noii167 I think the main problem is that this isn't an issue that anyone else has experienced and as we don't have access to your site etc. it's also not simple to diagnose.

    So it isn't one of our downloads not working - per se - but your implementation of it that isn't going so well :slight_frown:

    Still - we'll look again at the issues and try to provide some recommendations about how you can resolve the problems by redoing stuff etc.

    But that's more for Aaron than me.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.