Localhost Multisite New Site Issue

  • K-Fella

    (@k-fella)


    10 years, 5 months ago

    Hi,

    Today I needed to do some client work and visited my multisite admin panel but when I tried logging in it kept redirecting me back to the login page without any errors. Upon checking the php_error.log file there was the following error: Duplicate entry '0' for key 'PRIMARY' for query INSERT INTO 'wp_usermeta'

    I opened up phpmyadmin and checked the entry with the id of 0 which was a meta_key of ‘wporg_favourites’ set to my nickname. I deleted that entry and was able to login as a result. I then added a new site and it seemed to get added but it didn’t appear in the My Sites dropdown menu. I can visit the dashboard for the new site and it loads. The homepage for the new site however is blank. In the dashboard under Users my Super Admin user is not listed for the new site. I tried adding it manually but it doesn’t get saved. Again in the php_error.log file there is an error:

    WordPress database error Duplicate entry '0' for key 'PRIMARY' for query INSERT INTO 'wp_usermeta' ... made by add_existing_user_to_blog, add_user_to_blog ...

    By the way, the new entry in wp_usermeta with an id of 0 is now a meta_key called session_tokens after logging in worked.

    Does anyone have any idea how to fix this?

The topic ‘Localhost Multisite New Site Issue’ is closed to new replies.