error in move-blogs.php on line 107, 108, 122, 123

Hello,

I have question about the multi-db plugin install.

I was doing this two things for instructions:

“1) Place the files in the specified directories”

and

“2) Configure db-config.php”

But in file wp-content/scripts/move-blogs.php?table=copy i have this errors:

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 107

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 108

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 107

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 108

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 107

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 108

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 107

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 108

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 107

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 108

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 107

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 108

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 107

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 108

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 107

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 108

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 122

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 123

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 122

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 123

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 122

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 123

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 122

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 123

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 122

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 123

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 122

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 123

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 122

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 123

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 122

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 123

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 122

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /(…:wink:disappointed:move-blogs.php on line 123

  • marcin
    • New Recruit

    ok, I set global db detail. Now this is my config.php file:

    Code:
    <?php
    define(‘DB_NAME’, ‘hotelope_multi0global’:wink:; // The name of the database
    define(‘DB_USER’, ‘hotelope_blogger’:wink:; // Your MySQL username
    define(‘DB_PASSWORD’, ‘******************************’:wink:; // …and password
    define(‘DB_HOST’, ‘localhost’:wink:; // 99% chance you won’t need to change this value
    define(‘DB_CHARSET’, ‘utf8’:wink:;
    define(‘DB_COLLATE’, ”:wink:;
    define(‘VHOST’, ‘no’:wink:;
    $base = ‘/’;

    define(‘SECRET_KEY’, ’30b9f37b9524c3d0ace6709614c08ad8c340ddfb4a2650b2930d7a60abe5ace3′:wink:; // Change this to a unique phrase.
    define(‘SECRET_SALT’, ‘3341560b4450d05b151a8e93cd11e7be6788e3f3d9805d157a1af0d4ce846501’:wink:; // Change this to a unique phrase.

    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!’ );
    $table_prefix = ‘wp_’; // Only numbers, letters, and underscores please!
    define (‘WPLANG’, ”:wink:;
    define( “WP_USE_MULTIPLE_DB”, false );
    define(‘ABSPATH’, dirname(__FILE__).’/’:wink:;
    require_once(ABSPATH.’wp-settings.php’:wink:;
    ?>

    and link: http://hotelopedia.pl/

    what’s wrong with this config? :disappointed:

  • marcin
    • New Recruit

    my db-config.php :

    <?php

    define (‘DB_SCALING’, ’16’:wink:;

    add_dc_ip(‘123.123.123.’, ‘dc1’:wink:;

    add_global_table(‘tabela_globalna’:wink:;

    add_db_server(‘global’, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101’, ‘hotelope_multi0global’, ‘hotelope_blogger’, ‘*************’:wink:;

    add_db_server(‘0’, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101’, ‘hotelope_multi00’, ‘hotelope_blogger’, ‘*************’:wink:;

    (……………..)

    (……………..)

    (……………..)

    add_db_server(‘f’, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101’, ‘hotelope_multi0f’, ‘hotelope_blogger’, ‘*************’:wink:;

    add_db_server(‘vip1’, ‘dc1′, 1, 1,’64.120.23.72′,’192.168.0.101’, ‘hotelope_multi0vip_1’, ‘hotelope_blogger’, ‘*************’:wink:;

    add_vip_blog(1, ‘vip1’:wink:;

    ?>

    what’s wrong with this file?

  • Andrew
    • Champion of Loops

    For starters I highly doubt the ip for your db server is 123.123.123. You need to update that bit to reflect your db server IP. Looking on the other lines it seems it’s 64.120.23.72 so you need to replace 123.123.123. with 64.120.23.

    Also, you’ve configured the main blog to be in it’s own database. Make sure the tables are actually in that database.

    Thanks,

    Andrew