Roles and users disappeared

  • philliplord

    (@philliplord)


    14 years, 4 months ago

    I am having a problem with roles and users on my WP network. If I look at “All users” I appear to have none. If I try to add an existing user, then I get a message “That user is already a member of this site”

    The history of this blog is a bit complex. Originally, it was a WPMU installation, which I upgraded to WP3. This worked fine. However, we got hacked via timthumb. I restored into a vanilla WP3. This failed with a mysterious “Error Database connection” problem.

    This turned out to be not a database connection issue per se, but stem from the change of table names for the default blog — wp_1_* to wp_*. I fixed this by renaming the wp_1_* tables to wp_*. Content has magically reappeared. Network users are in place. But the association with the user and the blog is broken. This only happens for the first blog (stored in wp_*) which is why I am pretty sure that it is the renaming that caused the issue.

    It’s all a bit unfortunate really that the WPMU to WP3 update didn’t fix the table names at that point, rather than leaving the database in a half WPMU and half WP3 configuration. Still, aside from this, any pointers as to how I might fix this would be gratefully received.

Viewing 1 replies (of 1 total)
  • Thread Starter philliplord

    (@philliplord)

    14 years, 4 months ago

    Okay, fixed it.

    There are keys called wp_1 in both the wp_options and wp_usermeta table all of which need changing. That’s really quite messy. I understand why the database uses a duplicate schema, rather than a single schema with a blog_id column which would have been the “correct” way to do it. But then having table names IN as values in the database also seems to be overegging the pudding.

    Still, all in all, I think it was worth the effort, even if it wasn’t a deliberate choice. Although wordpress 3 and upward *should* be able to cope with a database originally from WPMU, overtime, I suspect it will cope less and less well with this special case. Fixing the situation so I have a “real” WP3 installation seems better.

    This is, of course, assuming I don’t find any other problems.

    Phil

Viewing 1 replies (of 1 total)

The topic ‘Roles and users disappeared’ is closed to new replies.