this plugin can not find the user meta tables.

blue suit

wordpress creates the user meta tables. This is a listing plugin. and I’ve never heard of it not finding the tables in a normal working wordpress setup.

Sorry I get this

‘[29-Oct-2014 13:40:31 UTC] WordPress database error Not unique ‘table/alias: ‘MYDB_usermeta’ for query SELECT * FROM MYDB_usermeta INNER JOIN MYDB_usermeta ON MYDB_users.ID = MYDB_usermeta.user_id

WHERE MYDB_usermeta.meta_key =’MYDB_capabilities’ made by do_action(‘user-lists_page_ameta-admin-configure’), call_user_func_array, amrmeta_configure_page, amr_rebuild_in_realtime_with_info, amr_build_user_data_maybe_cache, amr_get_alluserdata, amru_get_users

[29-Oct-2014 13:43:44 UTC] WordPress database error Not unique table/alias: ‘MYDB_usermeta’ for query SELECT * FROM MYDB_usermeta INNER JOIN MYDB_usermeta ON MYDB_users.ID = MYDB_usermeta.user_id

WHERE MYDB_usermeta.meta_key =’MYDB_capabilities’ made by do_action(‘user-lists_page_ameta-admin-configure’), call_user_func_array, amrmeta_configure_page, amr_rebuild_in_realtime_with_info, amr_build_user_data_maybe_cache, amr_get_alluserdata, amru_get_users

[29-Oct-2014 13:44:21 UTC] WordPress database error Not unique table/alias: ‘MYDB_usermeta’ for query SELECT * FROM MYDB_usermeta INNER JOIN MYDB_usermeta ON MYDB_users.ID = MYDB_usermeta.user_id

WHERE MYDB_usermeta.meta_key =’MYDB_capabilities’ made by require_once(‘**************\wp-admin\admin.php’), do_action(‘users_page_ameta-list?ulist=1’), call_user_func_array, amr_list_user_meta, alist_one, amr_try_build_cache_now, amr_build_user_data_maybe_cache, amr_get_alluserdata, amru_get_users

[29-Oct-2014 13:44:42 UTC] WordPress database error Not unique table/alias: ‘MYDB_usermeta’ for query SELECT * FROM MYDB_usermeta INNER JOIN MYDB_usermeta ON MYDB_users.ID = MYDB_usermeta.user_id

WHERE MYDB_usermeta.meta_key =’MYDB_capabilities’ made by require_once(‘***********\wp-admin\admin.php’), do_action(‘users_page_ameta-list?ulist=2′), call_user_func_array, amr_list_user_meta, alist_one, amr_try_build_cache_now, amr_build_user_data_maybe_cache, amr_get_alluserdata, amru_get_users’

Bluesuit
it’s saying that somehow you have two or more table or aliases for MYDB_usermeta. “Not unique ‘table/alias: ‘MYDB_usermeta’ “

This is not happening anywhere else that I know of which is weird, however I did find this https://www.cozmoslabs.com/forums/topic/wp-core-user-queries-breaking-fix-via-email/
which says possibly the queries should be using aliases on the main query, in case something else also trying to affect the query.

I’ll see if it makes sense for me to make an update and if so, it will be up soon.