Problems with Site ID

  • there seems to be a problem with site ID (under “Domain Mapping: Domains”) being properly assigned. For example, I have a site with 8 websites, which are all numbered 1-8. These were all added before a recent update in the plugin (I want to say last December) and there was never any problem with the site ID’s.

    I recently added some sites and they would not map no matter what I did. Randomly putting in numbers between 1-30 and then upgrading the network revealed that the system was assigning the sites a different ID than the number I was assigning it (under “Domain Mapping: Domains”). So, site 9 was changing it to 16, site 10 was changing it to site 23 and site 11 was changing it to site 26. This was how I was able to eventually get the newly added domains to map. It took 1/2 hour to do this just for two domains. (In other words, if I put in site 9, 10, 11, it would not map the domain and I had to randomly put in numbers between 1-30 to figure out which ones the system, apparently, was assigning to the domains).

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Ron Rennick

    (@wpmuguru)

    Site IDs are IDENTITY fields where the value is assigned by MySQL.

    Did you or your webhost support restore a backup?

    In the future if you are restoring a backup, it’s better to either drop the table or reset the identity counter on the table.

    Thread Starter Mindtrain

    (@mindtrain)

    Thanks for the help, Rick.

    I did not restore from a backup.

    How do I go about reseting the identity counter?

    If you can point me in the direction of where I need to go to reset the identity counter? Or how I would do that, I would appreciate it.

    I am paying for a “managed” “premium” host and they have said that I am completely on my own with this, which is really unhelpful.

    Thread Starter Mindtrain

    (@mindtrain)

    I found this:

    https://www.ads-software.com/support/topic/reset-site-ids-on-multisite?replies=7

    Is this what I need to fix the problem?

    Plugin Author Ron Rennick

    (@wpmuguru)

    If you can point me in the direction of where I need to go to reset the identity counter?

    Here’s an explanation of identity fields: https://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html. You will need to look at your DB to determine how the ID fields got changed.

    “Randomly putting in numbers” is not the proper approach. To map a domain name to a site, you have to specify the existing Site ID of the site to map.

    See my Domain Mapping Instructions for full details.

    From My Sites, Network Admin, Sites
    /wp-admin/network/settings.php

    Hover over the blog name (or the Edit link) for the site you want to map to a domain. You will see a link like “https://…/wp-admin/network/site-info.php?id=15”
    The Site ID is at the end (e.g. 15).

    All the entries where you put in an incorrect Site ID, you should simply delete. Then put in mappings with valid Site IDs.

    Thread Starter Mindtrain

    (@mindtrain)

    hi george,

    yes, sadly, I had either forgotten about this or never knew about it. I suppose I should have updated here with that info when I finally figured it out a couple of weeks ago. It is, indeed, super simple.

    I pay what is, for me, a lot of money for a “managed” host and they did not even mention this. moreover, they were the ones who initially configured the multisite, then they just left me in the lurch and said it was a plugin problem and not a server issue.

    needless to say, I will be moving everything over to my own server at digital ocean soon.

    thank you for replying, George!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Problems with Site ID’ is closed to new replies.

Tags