undefined instead of roles when selecting an actor

Let me try on my local env. Can you provide me with the list of plugins installed in your multisite env?

I will try to create a similar env and see if I can reproduce the error.

Also, do let me know the WP version you are running in your multisite env.

I am running two verstions of the site side by side so I can have one for developement one closer to production….

production is on 3.5
dev site is 3.5.1

I thought of the plugin idea as well and i have disabled all of the plugins on the dev site and I am still having the problem.

I even switched back to the default 2012 theme to see if my theme was causing the problem and it did not fix it.

I am testing it on a multisite installation on one of the sub sites not the main site.

I think your javascript is fine, i am guessing the db querry to pull out the users was not prepared correctly for a multisite install…. but I haven’t not had time to go through your code yet.

I found the problem. I dumped mysql log and found out that when the app is querying the database for users. It is looking for user tables in the individual site tables. (eg wp_8_users and eg wp_8_usermeta)

User data is kept in the main or default group of tables of a multisite install. wp_users and wp_usermeta (wp_users and wp_usermeta)

So you plugin would have worked on the main site of a multisite but not one of the sub sites.

I was able to do a search of you code and it looks like you need to update two files

process_flow.php line 402ish the database query should be:

$users = $wpdb->get_results( "SELECT users_1.ID, users_1.display_name FROM {$wpdb->base_prefix}users users_1
         					INNER JOIN {$wpdb->base_prefix}usermeta usermeta_1 ON ( users_1.ID = usermeta_1.user_id )
								WHERE (usermeta_1.meta_key = '{$wpdb->prefix}capabilities' AND CAST( usermeta_1.meta_value AS CHAR ) LIKE '%administrator%')");

and
workflow.php line 175ish the database query should be:

$users = $wpdb->get_results( $wpdb->prepare( "SELECT users_1.ID, users_1.display_name FROM {$wpdb->base_prefix}users users_1
            					INNER JOIN {$wpdb->base_prefix}usermeta usermeta_1 ON ( users_1.ID = usermeta_1.user_id )
									WHERE (usermeta_1.meta_key = '{$wpdb->prefix}capabilities' AND CAST( usermeta_1.meta_value AS CHAR ) LIKE %s)",
                           $user_role ) );

using base_prefix instead of prefix returns the base tables for a multisite install, where the user data is located.

I just did a search of your code for $wpdb->prefix}users so if there are other places you call for user data it will need to be updated as well. I updated those two locations and things seem to be working now.

hopefully this helps

great. good catch. And thanks for taking the time to look into the issue.

Do let me know if you need any other features to improve the plugin.