Error Message!

Hello,

We are trying to move our WP MultiSite running on Multi-DB from one server to a more powerful one and its an export/import stuff which is already take care of.
Since its a straight export/import with same control panels on both server, the only change is IP and we have updated the new IP to the /wp-contents/db-config.php file.

But we get to see the following message:
"The site you have requested is not installed properly. Please contact the system administrator.".

What could be wrong? Any ideas..?

Thanks & Regards

  • Mustafa

    Hi mikee17,

    Are you sure to your database server support remote connection?
    Also,you can look this tip.

    if you are using local server before your configuration like as

    add_db_server('0', 'dc1', 1, 1,'','localhost', 'test0', 'test',  'test');
    add_db_server('1', 'dc1', 1, 1,'','localhost', 'test1', 'test',  'test');
    .
    .
    .

    but if you wanna using another server.Your configuration like as

    add_db_server('0', 'dc1', 1, 1,'serverip','', 'test0', 'test',  'test');
    add_db_server('1', 'dc1', 1, 1,'serverip','', 'test1', 'test',  'test');
  • mikee17

    Hi Phil,

    I tried .txt and it was not taking either...here is the code:

    <?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', '4096'); //AS - 12th Jan 2010 | changed to 4096 from 256
    //------------------------------------------------------------------------//
    //---DC IPs---------------------------------------------------------------//
    //------------------------------------------------------------------------//
    //	Usage: add_dc_ip(IP, DC)
    //	EX: add_dc_ip('123.123.123.', 'dc1');
    //My IP: '207.32.176.117' // NEW: '23.19.41.75'
    //add_dc_ip('207.32.176.', 'dc1'); // AS - 12th Jan 2010
    add_dc_ip('23.19.41.', 'dc1'); // AS - 11th Aug 2011 | NEW server IP
    //------------------------------------------------------------------------//
    //---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');
    
    //AS - 13th Nov 2009 - start.
    #add_global_table('blogs');
    add_global_table('blog_activity');
    #add_global_table('blog_versions');
    add_global_table('comment_activity');
    add_global_table('communities');
    add_global_table('communities_members');
    add_global_table('communities_news_items');
    add_global_table('communities_notifications');
    add_global_table('communities_pages');
    add_global_table('communities_posts');
    add_global_table('communities_topics');
    add_global_table('domain_mapping');
    add_global_table('forums');
    add_global_table('friends');
    add_global_table('mass_mailer');
    add_global_table('messages');
    add_global_table('posts');
    add_global_table('post_activity');
    #add_global_table('registration_log');
    add_global_table('reports_comment_activity');
    add_global_table('reports_post_activity');
    add_global_table('reports_user_activity');
    add_global_table('sent_messages');
    #add_global_table('signups');
    add_global_table('signup_language');
    #add_global_table('site');
    #add_global_table('sitecategories');
    #add_global_table('sitemeta');
    add_global_table('site_comments');
    add_global_table('site_posts');
    //add_global_table('supporters'); // 17th
    //add_global_table('supporter_ads'); // 17th
    add_global_table('supporter_transactions');
    add_global_table('term_counts');
    add_global_table('tips');
    add_global_table('topics');
    #add_global_table('usermeta');
    #add_global_table('users');
    add_global_table('user_activity');
    //---
    add_global_table('gb_templates');
    add_global_table('am_actions');
    add_global_table('am_queue');
    add_global_table('am_schedule');
    //AS - 13th Nov 2009 - end.
    //AS - 16th Nov 2009 - start.
    add_global_table('domain_map'); // table named "domain_mapping" already exists! check later?
    //AS - 16th Nov 2009 - end.
    //AS - 17th Nov 2009 - start.
    //add_global_table('affiliatedata'); // AS, 19th Jan 2010 | Affiliate lite plugin << deactivated
    //add_global_table('affiliatereferrers'); // AS, 19th Jan 2010 | Affiliate lite plugin << deactivated
    //--
    add_global_table('supporters');
    add_global_table('supporter_signup_stats');
    add_global_table('supporter_daily_stats');
    add_global_table('supporter_ads');
    //AS - 17th Nov 2009 - end.
    //AS - 07th Dec 2009 - start. | BuddyPress
    /* AS, 28th Apr 2010
    add_global_table('bp_activity_user_activity_cached');
    add_global_table('bp_friends');
    add_global_table('bp_groups');
    add_global_table('bp_groups_groupmeta');
    add_global_table('bp_groups_members');
    add_global_table('bp_groups_wire');
    add_global_table('bp_messages_messages');
    add_global_table('bp_messages_notices');
    add_global_table('bp_messages_recipients');
    add_global_table('bp_messages_threads');
    add_global_table('bp_notifications');
    add_global_table('bp_user_blogs');
    add_global_table('bp_user_blogs_blogmeta');
    add_global_table('bp_user_blogs_comments');
    add_global_table('bp_user_blogs_posts');
    add_global_table('bp_xprofile_data');
    add_global_table('bp_xprofile_fields');
    add_global_table('bp_xprofile_groups');
    add_global_table('bp_xprofile_wire');
    AS, 28th Apr 2010 */
    //AS - 07th Dec 2009 - end.
    //AS - 23rd Dec 2009 - start.
    add_global_table('vn_site_categories');
    add_global_table('vn_user_membership');
    //AS - 23rd Dec 2009 - end.
    //AS - 26th Dec 2009 - start.
    add_global_table('vn_membership_products');
    //AS - 26th Dec 2009 - end.
    //AS - 25th Jun 2010 - start.
    add_global_table('vn_plr_product_title'); // for PLR site
    //AS - 25th Jun 2010 - end.
    //AS - 26th Aug 2010 - start.
    add_global_table('vn_rpt_user_stats'); // Actually a report table not related to WP, but is now used for de-activating blogs of cancelled/suspended users, so added here.
    //AS - 26th Aug 2010 - end.
    //AS - 13th Oct 2010 - start.
    add_global_table('vn_squeeze_details'); // for Squeeze site
    //AS - 13th Oct 2010 - end.
    //AS - 02nd May 2011 - start.
    add_global_table('autoblog'); // for new version(3.4.1) of AutoBlog
    //AS - 02nd May 2011 - end.
    
    //------------------------------------------------------------------------//
    //---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');
    //
    //	Note: you can also place this section in a file called db-list.php in wp-content
    add_db_server('global', 'dc1', 1, 1,'localhost','localhost', 'wpmuglobal', 'autowpz',  '12345');
    
    add_db_server('000', 'dc1', 1, 1,'localhost','localhost', 'wpmu000', 'autowpz',  '12345');
    add_db_server('001', 'dc1', 1, 1,'localhost','localhost', 'wpmu001', 'autowpz',  '12345');
    add_db_server('002', 'dc1', 1, 1,'localhost','localhost', 'wpmu002', 'autowpz',  '12345');
    add_db_server('003', 'dc1', 1, 1,'localhost','localhost', 'wpmu003', 'autowpz',  '12345');
    // =============== I REMOVED MANY TO REDUCE FILE SIZE =======its 4096=========
    add_db_server('ffb', 'dc1', 1, 1,'localhost','localhost', 'wpmuffb', 'autowpz',  '12345');
    add_db_server('ffc', 'dc1', 1, 1,'localhost','localhost', 'wpmuffc', 'autowpz',  '12345');
    add_db_server('ffd', 'dc1', 1, 1,'localhost','localhost', 'wpmuffd', 'autowpz',  '12345');
    add_db_server('ffe', 'dc1', 1, 1,'localhost','localhost', 'wpmuffe', 'autowpz',  '12345');
    add_db_server('fff', 'dc1', 1, 1,'localhost','localhost', 'wpmufff', 'autowpz',  '12345'); 
    
    //add_db_server('vip1', 'dc1', 1, 1,'localhost','localhost', 'wpmuvip1', 'autowpz',  '12345');
    //------------------------------------------------------------------------//
    //---VIP Blogs------------------------------------------------------------//
    //------------------------------------------------------------------------//
    //	Usage: add_vip_blog(BLOG_ID, DS)
    //	EX: add_vip_blog(1, 'vip1');
    
    //add_vip_blog(1, 'vip1');
    
    ?>

    Thanks & Regards

  • mikee17

    Hi Phil,

    dbuser and dbpass values are fake!

    Here is the wp-config.php file:

    // ** MySQL settings - You can get this info from your web host ** //
    /** The name of the database for WordPress */
    //define('DB_NAME', 'autowpz');
    
    /** MySQL database username */
    define('DB_USER', 'autowpz');
    
    /** MySQL database password */
    define('DB_PASSWORD', '12345');
    
    /** MySQL hostname */
    define('DB_HOST', 'localhost');
    
    /** Database Charset to use in creating database tables. */
    define('DB_CHARSET', 'utf8');
    
    /** The Database Collate type. Don't change this if in doubt. */
    define('DB_COLLATE', '');
    define('VHOST', 'yes');
    $base = '/';
    define('DOMAIN_CURRENT_SITE', 'topsiteblog.com' );
    define('PATH_CURRENT_SITE', '/' );
    define('SITE_ID_CURRENT_SITE', 1);
    define('BLOGID_CURRENT_SITE', '1' );
    
    /* Uncomment to allow blog admins to edit their users. See http://trac.mu.wordpress.org/ticket/1169 */
    //define( "EDIT_ANY_USER", true );
    /* Uncomment to enable post by email options. See http://trac.mu.wordpress.org/ticket/1084 */
    //define( "POST_BY_EMAIL", true );
    
    /**#@+
     * Authentication Unique Keys and Salts.
     *
     * Change these to different unique phrases!
     * You can generate these using the {@link https://api.wordpress.org/secret-key/1.1/salt/ WordPress.org secret-key service}
     * You can change these at any point in time to invalidate all existing cookies. This will force all users to have to log in again.
     *
     * @since 2.6.0
     */
    define('AUTH_KEY',         'my_value');
    define('SECURE_AUTH_KEY',  'my_value');
    define('LOGGED_IN_KEY',    'my_value');
    define('NONCE_KEY',        'my_value');
    define('AUTH_SALT',        'my_value');
    define('SECURE_AUTH_SALT', 'my_value');
    define('LOGGED_IN_SALT',   'my_value');
    define('NONCE_SALT',       'my_value');
    /**#@-*/
    
    /**
     * WordPress Database Table prefix.
     *
     * You can have multiple installations in one database if you give each a unique
     * prefix. Only numbers, letters, and underscores please!
     */
    $table_prefix  = 'wp_';
    
    /**
     * WordPress Localized Language, defaults to English.
     *
     * Change this to localize WordPress.  A corresponding MO file for the chosen
     * language must be installed to wp-content/languages. For example, install
     * de.mo to wp-content/languages and set WPLANG to 'de' to enable German
     * language support.
     */
    define ('WPLANG', '');
    
    // double check $base
    if( $base == 'BASE' )
    	die( 'Problem in wp-config.php - $base is set to BASE when it should be the path like "/" or "/blogs/"! Please fix it!' );
    
    // uncomment this to enable WP_CONTENT_DIR/sunrise.php support
    define( 'SUNRISE', 'on' );
    
    // uncomment to move wp-content/blogs.dir to another relative path
    // remember to change WP_CONTENT too.
    // define( "UPLOADBLOGSDIR", "fileserver" );
    
    // If VHOST is 'yes' uncomment and set this to a URL to redirect if a blog does not exist or is a 404 on the main blog. (Useful if signup is disabled)
    // For example, the browser will redirect to http://examples.com/ for the following: define( 'NOBLOGREDIRECT', 'http://example.com/' );
    // Set this value to %siteurl% to redirect to the root of the site
    // define( 'NOBLOGREDIRECT', '' );
    // On a directory based install you must use the theme 404 handler.
    
    // Location of mu-plugins
    // define( 'WPMU_PLUGIN_DIR', '' );
    // define( 'WPMU_PLUGIN_URL', '' );
    // define( 'MUPLUGINDIR', 'wp-content/mu-plugins' );
    
    define( "WP_USE_MULTIPLE_DB", false );
    
    define('WP_ALLOW_MULTISITE', true);
    
    /*
    define( 'MULTISITE', true );
    define( 'SUBDOMAIN_INSTALL', true );
    $base = '/';
    define( 'DOMAIN_CURRENT_SITE', 'topsiteblog.com' );
    define( 'PATH_CURRENT_SITE', '/' );
    define( 'SITE_ID_CURRENT_SITE', 1 );
    define( 'BLOG_ID_CURRENT_SITE', 1 );
    */
    
    /* That's all, stop editing! Happy blogging. */
    
    /** Absolute path to the WordPress directory. */
    if ( !defined('ABSPATH') )
    	define('ABSPATH', dirname(__FILE__) . '/');
    
    /** Sets up WordPress vars and included files. */
    require_once(ABSPATH . 'wp-settings.php');
  • mikee17

    Hi,

    Thank you all for the help.

    Our issue is almost solved, the new server guys said this:
    "I think that the backups were not fully importing properly and in the end we had to hack together a custom php-cli.ini which set all of the timeout and memory limits to unlimited to allow the import script to finish properly.
    The backup is not overly large, but the sheer number of databases/users/associations was apparently causing interworx to have some issues."

    We are using Multi-DB with 4096 DB's.

    Thanks & Regards

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.