Error migrating multisite

  • Hello,
    I’m trying to migrate a wordpress multisite website using subdomains.

    I’ve edited the database with the searchandreplace script to change the domain.
    I’ve edited the table_prefix, the domain and database connection on config.php.

    The sites looks ok on the frontend, but in the backend the users on Network Admin > Users are not linked to any Sites and I cannot add new users to websites from the Network Admin > Sites screen because the Roles dropdown is empty.

    Any help?

Viewing 1 replies (of 1 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    I’m trying to migrate a wordpress multisite website using subdomains.

    Migrate how?

    Are you changing the domain or are you just moving to the new server?

    I cannot add new users to websites from the Network Admin > Sites screen because the Roles dropdown is empty.

    So normally you have the prefix wp_ and the table wp_options. In that table you have a option named wp_user_roles and everything works. But then you make a new site, and you pick a different DB prefix, maybe you heard it was more secure, or maybe you wanted both tables in the same DB. Either way, if you changed your PREFIX to, say wp_wdssrr_, then now you have wp_wdssrr_options instead, and when you copy over your old options content, no one can log in. It’s because you have to rename that option to wp_wdssrr_user_roles

Viewing 1 replies (of 1 total)
  • The topic ‘Error migrating multisite’ is closed to new replies.