Sharing User Tables Roles don't show in User List

  • I highly appreciate your help on two questions:

    I successfully shared wp_user and wp_usermeta tables on 2 WP installations (both 3.2.1).
    The problem: No user roles show in the user listing. But if clicking on “edit” resp. going to a single profile the correct roles show.

    Any idea on how to persuade the user listing to show roles too?

    Second question:
    The wp_user holds more than 10,000 user. Calling the user listing in the “mother” installation loads the listing quickly and easily.
    Calling the user listing from the second installation uses a loading time of 1 minute and more.

    Both installations on the same domain (the second one in a subdir) and both installations in the same database.

    I have no clue, why the second installation is having problems loading the user listing.

    Thank you so much in advance and kind regards from Austria,
    eliZZZa

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter eliZZZa

    (@elizzza)

    The second questions is answered: The plugin WP-Orphanage was the culprit!

    Thread Starter eliZZZa

    (@elizzza)

    There is one hint in the Codex, but unfortunately I don’t know, how to achieve, that the capabilites for the second site are written into the user table of the first too.

    #### FROM THE CODEX ####
    Custom User and Usermeta Tables
    CUSTOM_USER_TABLE and CUSTOM_USER_META_TABLE are used to designated that the user and usermeta tables normally utilized by WordPress are not used, instead these values/tables are used to store your user information.

    define(‘CUSTOM_USER_TABLE’, $table_prefix.’my_users’);
    define(‘CUSTOM_USER_META_TABLE’, $table_prefix.’my_usermeta’);
    Please note that permissions in the user_meta tables are stored with the table prefix of the site. So in the CUSTOM_USER_META_TABLE one must have entries for each site using that table. At the very least for the administrator, to avoid the “you do not have permissions error” you should have:

    prefix1_capabilities = a:1:{s:13:”administrator”;b:1;} and prefix2_capabilities = a:1:{s:13:”administrator”;b:1;} etc

    #### END FROM THE CODEX ####

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Sharing User Tables Roles don't show in User List’ is closed to new replies.