Multisite problems with site-id being the same

  • Hello!

    I have a multisite with sites A, B and C, where A is the main.
    When asked, A reports site-id: 1
    B reports site-id: 2
    C reports site-id: 1

    Also, when I change theme or settings on A, they also reflect on C, but not B.

    Something is very wrong with C. I checked database and it seems that C refers to its own subdomain only 120 times, where B refers to its subdomain +20.000 times.

    If this was not a multisite, I would repair permalinks or replace domain name to be correct in database by saving “site url”, but I am unsure what to do in this case.

    Can you think of a good solution here?

Viewing 9 replies - 1 through 9 (of 9 total)

  • Can you check the wp_blogs table and see if the blog_id is stored wrong there and also check auto-increment is set in the blog_id column or not?

    Thread Starter prokops

    (@prokops)

    Thanks for answering Vijay

    wp_blogs looks fine, sites A, B and C are ID= 1, 2 and 3.
    So nothing off there.

    When I try frontend, site C reports id=1, so something is off in database.

    Did you check wp-config.php if something is set as wrong for CURRENT_SITE constants?

    Thread Starter prokops

    (@prokops)

    These are the constants:
    —

    define(‘MULTISITE’, true);
    define(‘SUBDOMAIN_INSTALL’, true);
    define(‘PATH_CURRENT_SITE’, ‘/’);
    define(‘SITE_ID_CURRENT_SITE’, 1);
    define(‘BLOG_ID_CURRENT_SITE’, 1);
    $table_prefix = ‘ycld_’;
    define( ‘WP_DEBUG’, true );
    define( ‘WP_DEBUG_DISPLAY’, false );
    define( ‘WP_DEBUG_DISPLAY_LOG’, true );
    define( ‘WP_DISABLE_FATAL_ERROR_HANDLING’, true);
    define( ‘WPMS_ON’, true );
    define(‘WP_ALLOW_MULTISITE’, true);

    —
    I am unsure about what could look off here?

    there is no DOMAIN_CURRENT_SITE constant?

    Thread Starter prokops

    (@prokops)

    yes there is:
    define(‘DOMAIN_CURRENT_SITE’, ‘xxxxxxxxx.dk’);

    What happens when you add a site D? did you try that?

    Thread Starter prokops

    (@prokops)

    I made a new site. This reports: SITE ID: 4 when asked.

    So the problem is with my site C. Another problem it has is that site C will not load themes properly backend: https://paste.pics/9d06faae2046f95076e32b20d23fe8e4

    Maybe problems are connected?

    I am getting to desperate measures and thinking of search&replace database of site C to replace url to the correct subdomain.

    Can you think of something Vijay?

    Try to compare Site B and Site C data in database and find what is wrong in site C

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Multisite problems with site-id being the same’ is closed to new replies.